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. Here are my code:
However, I keep on hit the error as below:
I cannot have the procedures call within the for loop?
Please advise.
Thanks in advanced
Last edited by Scott; 08-31-2013 at 03:02 AM..
Reason: Code tags, please...
Hi all,
I'm quite new to unix and hope that someone can help me on this.
I'm using csh.
Below is what i intend to do.
1. I stored some data in a file.
2. I intend to read the file line by line and store each line of data into a variable, so that i can used it later.
Anyone have any... (4 Replies)
Hi,
I am new to the Unix shell scripting world. It would be great if some body can help me with my requirement
1) Script (say script1.sh) which will take set of files from one folder (say input folder).
2) Take the first file from the folder and execute another script (script2.sh).Pass 2... (3 Replies)
Hi,
I am new to the Unix shell scripting world. It would be great if some body can help me with my requirement
1) Script (say script1.sh) which will take set of files from one folder (say input folder).
2) Take the first file from the folder and execute another script (script2.sh).Pass 2... (1 Reply)
hello
i have two files
temp.txt
and temp_unique.text
the second file consists the unique fields from the temp.txt file
the strings stored are in the following form
4,4
17,12
15,65
4,4
14,41
15,65
65,89
1254,1298i'm able to run the following script to get the total count of a... (3 Replies)
Hello, I am quite new in shell scripting and I would like to write a little scritp to run a program on some parameters files.
all my parameters files are in the same directory, so pick them up with
ls *.para >>dirafter that I have a dir file like that:
param1.para
param2.para
etc...
I... (2 Replies)
Hi All,
I'm trying to figure out which are the trusted-ips and which are not using a script file.. I have a file named 'ip-list.txt' which contains some ip addresses and another file named 'trusted-ip-list.txt' which also contains some ip addresses. I want to read a line from... (4 Replies)
Hi Experts,
I am having a requirement like this;
Input file
EIM_ACCT.ifb|1001|1005
EIM_ADDR.ifb|1002|1004
EIM_ABD.ifb|1009|1007
I want to read each line of this file and pass each line,one at a time,as an argument to another script.
eg;
1.read first line->store it to a file->call... (2 Replies)
Hi,
I would like to read a file line by line and then store the whole line word by word in array so that I can do specific manipulation on each word.
$ cat test.txt
hello how are you
i am good
I would like to have an array created dynamically so that first time , the... (4 Replies)
I am trying read all the files from list into a variable line using bash. After there are read into the variable they are passed to a delete call. The files appear to be read line (as I can see them with the echo) by line into the variable, but the delete call is not removing them and I do not... (1 Reply)
DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars(3)NAME
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
See "CONTRIBUTORS" in DBIx::Class.
LICENSE
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)