Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

dbix::class::storage::dbi::sybase::ase::nobindvars(3) [mojave man page]

DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars(3)	User Contributed Perl Documentation  DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars(3)

DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars - Storage::DBI subclass for Sybase ASE without placeholder support DESCRIPTION
If you're using this driver then your version of Sybase or the libraries you use to connect to it do not support placeholders. You can also enable this driver explicitly using: my $schema = SchemaClass->clone; $schema->storage_type('::DBI::Sybase::ASE::NoBindVars'); $schema->connect($dsn, $user, $pass, \%opts); See the discussion in "Using ? Placeholders & bind parameters to $sth->execute" in DBD::Sybase for details on the pros and cons of using placeholders. One advantage of not using placeholders is that "select @@identity" will work for obtaining the last insert id of an "IDENTITY" column, instead of having to do "select max(col)" in a transaction as the base Sybase driver does. When using this driver, bind variables will be interpolated (properly quoted of course) into the SQL query itself, without using placeholders. The caching of prepared statements is also explicitly disabled, as the interpolation renders it useless. AUTHORS
You may distribute this code under the same terms as Perl itself. perl v5.18.2 2013-12-16 DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars(3)

Check Out this Related Man Page

DBIx::Class::Storage::DBI::NoBindVars(3)		User Contributed Perl Documentation		  DBIx::Class::Storage::DBI::NoBindVars(3)

DBIx::Class::Storage::DBI::NoBindVars - Sometime DBDs have poor to no support for bind variables DESCRIPTION
This class allows queries to work when the DBD or underlying library does not support the usual "?" placeholders, or at least doesn't support them very well, as is the case with DBD::Sybase METHODS
connect_info We can't cache very effectively without bind variables, so force the "disable_sth_caching" setting to be turned on when the connect info is set. _prep_for_execute Manually subs in the values for the usual "?" placeholders. interpolate_unquoted This method is called by "_prep_for_execute" for every column in order to determine if its value should be quoted or not. The arguments are the current column data type and the actual bind value. The return value is interpreted as: true - do not quote, false - do quote. You should override this in you Storage::DBI::<database> subclass, if your RDBMS does not like quotes around certain datatypes (e.g. Sybase and integer columns). The default method returns false, except for integer datatypes paired with values containing nothing but digits. WARNING!!! Always validate that the bind-value is valid for the current datatype. Otherwise you may very well open the door to SQL injection attacks. _prep_interpolated_value Given a datatype and the value to be inserted directly into a SQL query, returns the necessary string to represent that value (by e.g. adding a '$' sign) AUTHORS
You may distribute this code under the same terms as Perl itself. perl v5.18.2 2013-07-12 DBIx::Class::Storage::DBI::NoBindVars(3)
Man Page

15 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

placeholders in file names

I am writing a script that looks for files. I need to know if there is a placeholder character when doing this. I know that you can user a wildcard (*) character, but I would prefer to be a bit more specific. When I get files in a specific directory, I know part of the name, but not the rest and... (7 Replies)
Discussion started by: dsimpg2
7 Replies

2. Solaris

New to Perl-LDAP

Hi all I am new to perl-ldap. Trying to install DBD module on sun solaris which has the iplanet51 ldap already installed. I have got the DBD-LDAP-0.03.tar file , and un packed it. From the dir DBD-LDAP-0.03 - i tried to do $ perl Makefile.PL and i got the... (10 Replies)
Discussion started by: kaushi
10 Replies

3. Shell Programming and Scripting

Connect to a Remote Sybase Server Through Script

Hi all, I am trying to connect to Remote Sybase database Server through shell script. I am operating on WindowsXP, connect to Unix(version SunOS: 5.8) The thing is i dont know how to connect to Sybase Server through my script file? Are there any manual pages which can guide me through the... (3 Replies)
Discussion started by: Aparna_k82
3 Replies

4. UNIX for Advanced & Expert Users

F3 to F10 not working with TERM=ansi ?

Hello friends, I am using SCO Openserver 5.0.7. At the server console, the function keys F3-F10 do not work with my Sybase 4.2 application when I set the TERM environment variable to 'ansi'. What changes should I do to the terminfo source of 'ansi' to enable the function keys? An... (5 Replies)
Discussion started by: sabu
5 Replies

5. Windows & DOS: Issues & Discussions

how to connect to sybase database?

hi, I'd like to connect to a Sybase ASE 12 through a a graphic user interface (GUI) that run on windows and solaris10, because i need to do some querys. The database is running on solaris 10. I'm not an expert using databases, but i know how to use some SQL commands through command line... (3 Replies)
Discussion started by: danin
3 Replies

6. AIX

Check Sybase installation

Hi, How do i check if Sybase is installed on aix..The sybase guy is doing remote installation and i need to check if he has installed sybase or not. ive tried the following approaches. #lslpp -L "*Sybase*" # tried other strings like "*ybase*" , "*base*" #lslpp -ha |grep syb # tried... (4 Replies)
Discussion started by: muzahed
4 Replies

7. Solaris

Sunfire 490 connect to IBM SAN DS4000

Hi All Recently i plan use our company Sunfire V490 to hook up the IBM SAN Storage DS4000. But i not sure is it got any requirement to do this, is it need any extra driver, equipment??? hope can get some advice from here.. Kindly advise. Thanks all (3 Replies)
Discussion started by: SmartAntz
3 Replies

8. UNIX for Dummies Questions & Answers

PING pros and cons

(3 Replies)
Discussion started by: lhareigh890
3 Replies

9. Shell Programming and Scripting

Sybase connection failing through shell script

Hi All, I'm trying to connect to Sybase via shell script. i'm getting the following error. Please let me know where i'm going wrong. Note that i'm not having this issue when connecting via terminal. #!/usr/bin/bash SYBASE=/usr/sybase ISQL=$SYBASE/bin/isql export SYBASE ISQL ... (6 Replies)
Discussion started by: Irishboy24
6 Replies

10. Solaris

Sun Cluster question

Hello everyone I've inherited an Oracle Solaris system holding ASE Sybase databases. The system consists of two nodes inside a Sun Cluster. Each of the nodes is hosting 2 Sybase database instances, where one of the nodes is active and other is standing by. The scenario at hand is that when any of... (3 Replies)
Discussion started by: abohmeed
3 Replies

11. Shell Programming and Scripting

Read line of files and call store procedures

Hi, I wish to write a piece of code to read lines of the flat file and cut each lines of record to a variable, then use this variable to pass as an parameter of a Sybase stored procedures, if there are 5 lines of record from the text file, then this stored procedures will be called 5 times.... (8 Replies)
Discussion started by: newbie2011
8 Replies

12. AIX

AIX - Fibre Adapter and IBM Storage

Hello, Just a quick question Usually from a PSERIES if you want to connect to IBM SAN Storage you connect the IBM SAN Storage through a SAN Switch something like this --- however my question Can you connect from Pseries directly to San Storage without SAN Switch what would be... (8 Replies)
Discussion started by: filosophizer
8 Replies

13. Programming

How to trim values in sybase ase?

HI Team I am using Sybase ASE15.7 version. Below is the sample column values . Would like to know how to Trim http:// and https:// from above list of example Remove characters after first / Include only the... (3 Replies)
Discussion started by: Perlbaby
3 Replies

14. Shell Programming and Scripting

Help with Shell Script to View Logs

Hi I'm very new to unix shell scripting. Im also new here in this forum. I'm a SQL Server DBA but I'm slowly learning Oracle and Sybase DB. Our Oracle and Sybase are on Unix platforms. Im slowly learning Linux Admin and Shell Scripting to automate tasks. I'm writing a script to view DB error... (4 Replies)
Discussion started by: Ricky777
4 Replies

15. Shell Programming and Scripting

Bcp command error in uploading data to Sybase

Hi All, I had an issue in executing bcp command to connect to Sybase from Unix script for uploading the data from file to table. I have a file called vrs_temp.txt (with two columns): 22055;20181001 21088;20181001 93840;20181001 30990;20181001 50990;20181001 50950;20181001Created a... (4 Replies)
Discussion started by: Suresh
4 Replies

Featured Tech Videos