07-03-2009
Assuming you've read the DBI man pages and the Sybase-DBD driver notes, can you get the output of a regular query to work?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Good Morning everybody.
I need to write a perl script which will get some data from DB2 table and then put it into Sybase table. I have the experience in Oracle and Unix but new to these perl, DB2 and Sybase technologies.
Appreciate if any one can suggest with a sample code.
Thanks... (1 Reply)
Discussion started by: rajus19
1 Replies
2. Shell Programming and Scripting
How to get the data from the sybase database and append the data obtained into the file.
For example,
I will get the filename 'temp' from the database. This filename is associated with the number 1.6... This number 1.6 needs to be copied into the file that matches the filename in the... (1 Reply)
Discussion started by: vinay123
1 Replies
3. Shell Programming and Scripting
How I can get the logs that are getting stored in specific location in unix server
through an Apache web server installed in unix server?
Requirement is to access the logs through the URL in windows browser without any access. (1 Reply)
Discussion started by: alvida
1 Replies
4. Programming
Currently my Pro*c program is fetching a cloumn which is defined as LONG in oracle db. The data in the column is around 65k. But when I am FETCHing it to a varchar variable, I am only getting 22751 bytes of data using cursor.
Is there any limitation on the data which is fetched by a cursor in... (2 Replies)
Discussion started by: manbt
2 Replies
5. Shell Programming and Scripting
Hi Experts,
I have created a table with columns as empname,empid,phone,shiftname. Now I am having a .csv file format which contains the shift datas of the employees. I have to fetch this file and compare with the table I created to send an alert to the specified user. (2 Replies)
Discussion started by: micky3112
2 Replies
6. Shell Programming and Scripting
Data
I was trying to write shell script which will be return the output in the below format
First i was trying to do these using sed.
sed -n '/.ksh/p' mainksh.ksh
sed -e 's/*\(.*\)/\1/g' mainksh.ksh
$RUN_DIR, $SUB_DIR and the variables which will be defined in the profile file.
when i am... (0 Replies)
Discussion started by: rameshds
0 Replies
7. Shell Programming and Scripting
Here's a database query which looks up the NAME column of PRODUCT table
SELECT NAME FROM PRODUCT ;
And this query retrieves me the following output
SUGAR
COCOA
HONEY
WHEAT
CABBAGE
CAULI FLOWER
Please note the last record CAULI FLOWER contains TWO blank spaces between the two words.
... (4 Replies)
Discussion started by: kumarjt
4 Replies
8. Shell Programming and Scripting
Hi All,
I'm facing issue while using script.
Chk_Etl_Status=`cat /dstage/questnet/qnetdv/input/Etl_Status.dat|cut -d"," -f1`
echo Chk_Etl_Status=$Chk_Etl_Status
above result is giving me sometime value as 1 and sometime error message as
Chk_Etl_Status=
dsjoblaunch.sh: test: Specify a... (5 Replies)
Discussion started by: Amit786
5 Replies
9. Shell Programming and Scripting
Hi All,
I have one fine which contaning the record as below, I need to fetch the number which is in Bold and from second line only URL need to pick.
:ABCD C7QyzBXIs58k 1 fdmlksdlkfn
... (4 Replies)
Discussion started by: Riverstone
4 Replies
10. Shell Programming and Scripting
Hello Gurus,
I am trying to fetch a required number of lines from an output of a command which is in tabular form.
Below is the command for reference along with how the result is being shown on UNIX shell.
/usr/openv/volmgr/bin/vmquery -b -p 5
The result of the above command is as... (6 Replies)
Discussion started by: Ali Sarwar
6 Replies
LEARN ABOUT OSX
dbix::class::storage::dbi::nobindvars
DBIx::Class::Storage::DBI::NoBindVars(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::NoBindVars(3)
NAME
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
See "CONTRIBUTORS" in DBIx::Class
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.16.2 2012-08-16 DBIx::Class::Storage::DBI::NoBindVars(3)