Hmm, it seems to be working when I echo now, but not issuing to db2
Code:
while read SQLStatement
do
echo "Running : $SQLStatement" |tee -a $LogFile
db2 "$SQLStatement" >> $LogFile
if [ $? -ne 0 ] ; then
echo "Error: Problem encountered in running: " $SQLStatement
exit 1
fi
done < $InputSQLFile
Last edited by zazzybob; 11-01-2005 at 09:25 PM..
Reason: fixed up code tag
Dears,
I've written a script which allows me to send mails in different formats with different attaches. Now I still want to add a feature to this script. My users would like to be able to receive a "read" or "delivered" receipt for their mails.
The script send mails on behalve of an specific... (1 Reply)
Not sure if I am using the correct terminology:
I have a user setup in a menu. I want to let the user browse a file using the pg.
I want to prevent the person from doing <ctrl>c and being able to exit the script to the command line.
How do I do this? (6 Replies)
Hallo,
i need a Prompting read in my script:
read -p "Enter your command: " command
But i always get this Error:
-p: is not an identifier
When I run these in c-shell i get this error
/usr/bin/read: read: bad option(s)
How can I use a Prompt in the read command? (9 Replies)
Hi,
I have line in input file as below:
3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL
My expected output for line in the file must be :
"1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL"
Can someone... (7 Replies)
In previous releases of AIX (<5.3) the "more" command didn't redraw the screen upon exit. This helped when searching in a text document or man page because one could look for the relevant part of it, exit and use the left-over at the screen as reference for typing the next command.
Alas, this... (2 Replies)
Hi,
Could anyone please shed some light on the following script lines and what is it doing as it was written by an ex-administrator?
cat $AMS/version|read a b verno d
DBVer=$(/usr/bin/printf "%7s" $verno)
I checked that the cat $AMS/version command returns following output:
... (10 Replies)
I want to print any matching IP addresse in List1 with List 2;
List 1
List of IP addresses;
161.85.58.210
250.57.15.129
217.23.162.249
74.76.129.101
30.221.177.237
3.147.200.59
170.58.142.64
127.65.109.33
150.167.242.146
223.3.20.186
25.181.180.99
2.55.199.32 (3 Replies)
How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address
and column 3 contains “cc” e-mail address to include with same email.
Sample input file, email.txt
Below is an sample code where... (2 Replies)
Hi All
I am using GNU/Linux
This is regarding the get command to retrieve files (filename with wild card characters) from remote server.
I thought Get command can retrieve only 1 file irrespective of the files it has on the remote server And it is the function of mget to retrieve all... (7 Replies)
Hi everybody,
I am new at Unix/Bourne shell scripting and with my youngest experiences, I will not become very old with it :o
My code:
#!/bin/sh
set -e
set -u
export IFS=
optl="Optl"
LOCSTORCLI="/opt/lsi/storcli/storcli"
($LOCSTORCLI /c0 /vall show | grep RAID | cut -d " "... (5 Replies)
Discussion started by: Subsonic66
5 Replies
LEARN ABOUT DEBIAN
sql::translator::parser
SQL::Translator::Parser(3pm) User Contributed Perl Documentation SQL::Translator::Parser(3pm)NAME
SQL::Translator::Parser - describes how to write a parser
DESCRIPTION
Parser modules that get invoked by SQL::Translator need to implement a single function: parse. This function will be called by the
SQL::Translator instance as $class::parse($tr, $data_as_string), where $tr is a SQL::Translator instance. Other than that, the classes are
free to define any helper functions, or use any design pattern internally that make the most sense.
When the parser has determined what exists, it will communicate the structure to the producer through the SQL::Translator::Schema object.
This object can be retrieved from the translator (the first argument pass to parse) by calling the schema method:
my $schema = $tr->schema;
The Schema object has methods for adding tables, fields, indices, etc. For more information, consult the docs for SQL::Translator::Schema
and its related modules. For examples of how this works, examine the source code for existing SQL::Translator::Parser::* modules.
AUTHORS
Ken Youens-Clark, <kclark@cpan.org<gt>, darren chamberlain <darren@cpan.org>.
SEE ALSO perl(1), SQL::Translator, SQL::Translator::Schema.
perl v5.14.2 2012-01-18 SQL::Translator::Parser(3pm)