|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
While loop variable
Post 302770333 by zaxxon on Friday 15th of February 2013 08:43:56 AM
02-15-2013
Ok 
The problem will most probably be, that the DB client you are using, will just show a RC of 0 all the time, no matter if the SQL statement issued was successful or not.
You got the same issue, if you do something with a ftp client or any other client, that works fine in terms of itself, no matter what errors you get "inside" the client. There is usually issued a 0 back to the shell as the client says "Hey man, I am fine, not my fault the commands you issued didn't work because of <insertsomethingthatwentwrong>".
Can simply check this if you add a echo $RC after defining $RC while issuing an intentionally failing SQL statement in the line above.
I am not sure if there is any kind of option for your DB client to pass any other RC through to the shell. Could check it's documentation maybe; or grep for a pattern that shows the success/fail of the operation.
Update:
For DB2 I found that the client returns appropriate RCs:
http://publib.boulder.ibm.com/infoce...e/r0010411.htm
Just as an example that some clients do that.
The problem will most probably be, that the DB client you are using, will just show a RC of 0 all the time, no matter if the SQL statement issued was successful or not.
You got the same issue, if you do something with a ftp client or any other client, that works fine in terms of itself, no matter what errors you get "inside" the client. There is usually issued a 0 back to the shell as the client says "Hey man, I am fine, not my fault the commands you issued didn't work because of <insertsomethingthatwentwrong>".
Can simply check this if you add a echo $RC after defining $RC while issuing an intentionally failing SQL statement in the line above.
I am not sure if there is any kind of option for your DB client to pass any other RC through to the shell. Could check it's documentation maybe; or grep for a pattern that shows the success/fail of the operation.
Update:
For DB2 I found that the client returns appropriate RCs:
http://publib.boulder.ibm.com/infoce...e/r0010411.htm
Just as an example that some clients do that.
Last edited by zaxxon; 02-15-2013 at 09:56 AM.. Reason: added info
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi...
i am trying to ping my servers .The hostnames are present in a file .They are separated by spaces in the file .
i am doing the following :
a=1
for name in $(cat host2 |cut -d" " -f$a)
do
echo Pinging server $name
ping -c5 $name
a=$a+1
done
It is... (3 Replies)
Discussion started by: sars
3 Replies
2. Shell Programming and Scripting
i have these data in a variable "$test"
BUNGA TERATAI 3 5055 ITH 1 1
JADE TRADER 143W ITH 4 4
MOL SPLENDOR 0307A ITH 3 3
the red coloured are the ones that i want to take and compare
what I need to do is to take out the red coloured and then compare to another variable, if same then... (0 Replies)
Discussion started by: finalight
0 Replies
3. Shell Programming and Scripting
Hi,
Is it possible to assign one variable to other.
eg.
v1="table1"
v2="20000"
I want table1 to assign 20000
table1=20000
Is there any way?
Thanks (2 Replies)
Discussion started by: SushilM
2 Replies
4. Shell Programming and Scripting
Hi
I have webserver that I do read data from.
Data are stored like this:
Huston |1
Portland |2
Hazen |1
Minneapolis |4
Albany |1
Pittsburg |1
Albany |1
Huston |1
Portland|1
Hazen |2
Albany |2
Huston |1
Hazen |1
Script #!/bin/sh
user="admin" (1 Reply)
Discussion started by: Jotne
1 Replies
5. Shell Programming and Scripting
Hello all,
I find it hard to explain what I need so I will post the code
OVZINCLUDE="16810 16811 1689"
PLUS_16810="test"
PLUS_16811="test"
for VPS in $OVZINCLUDE
do
echo "Dumping VPSes: $OVZINCLUDE "
vzdump --compress --snapshot ${PLUS_$VPS} $VPS
done
... (2 Replies)
Discussion started by: click
2 Replies
6. Shell Programming and Scripting
Simple enough problem I think, I just can't seem to get it right.
The below doesn't work as intended, it's just a function defined in a much larger script:
CheckValues() {
for field in \
Group_ID \
Group_Title \
Rule_ID \
Rule_Severity \
... (2 Replies)
Discussion started by: Vryali
2 Replies
7. Shell Programming and Scripting
I have a group of variables myLINEcnt1 - myLINEcnt10. I'm trying to printout the values using a for loop. I am at the head banging stage since i'm sure it has to be a basic syntax issue that i can't figure out.
For myIPgrp in 1 2 3 4 5 6 7 8 9 10; do
here i want to output the value of... (4 Replies)
Discussion started by: oly_r
4 Replies
8. UNIX for Dummies Questions & Answers
Hello guys,
This truly is a newbie question. I'm trying to make a loop to execute simultaneous commands indefinitely while using variable. Here is how my mess looks like (this is just an example):
#!/bin/bash
IP=`shuf -n 1 IP.txt` # I figured this would be easier to select random lines... (4 Replies)
Discussion started by: bobylapointe
4 Replies
9. Shell Programming and Scripting
Hello All,
Maybe I'm Missing something here but I have NOOO idea what the heck is going on with this....?
I have a Variable that contains a PATTERN of what I'm considering "Illegal Characters". So what I'm doing is looping
through a string containing some of these "Illegal Characters". Now... (5 Replies)
Discussion started by: mrm5102
5 Replies
10. Shell Programming and Scripting
Hi All,
I have a file which has hundred of records with fixed number of fields. In each record there is set of 8 characters which represent the duration of that activity. I want to sum up the duration present in all the records for a report. The problem is the duration changes per record so I... (5 Replies)
Discussion started by: danish0909
5 Replies
LEARN ABOUT DEBIAN
c-icap-client
c-icap-client(8) System Manager's Manual c-icap-client(8) NAME
c-icap-client - simple ICAP client SYNOPSIS
c-icap-client [ -i icap_servername ] [ -p port ] [ -s service ] [ -f input_file ] [ -o out_file ] [ -req url ] [ -d debug level ] [ -nore- shdr ] [ -x icap-header ] [ -hx http-header ] [ -v ] DESCRIPTION
c-icap-client is a simple ICAP client. It can be used to test your icap server configuration. OPTIONS
-i icap_servername The hostname of the icap server. The default is localhost -p port The server port. The default port value is 1344 -s service The service name. The default service name is "echo" -f filename Send this file to the icap server. Default is to send an options request -o filename Save output to this file. Default is to send to stdout -req url Send a request modification instead of response modification, using as http url the url provided with this option. -d level debug level info to stdout -noreshdr Do not send reshdr headers -x icap-header Include the icap-header in icap request headers -hx http-header Include the http-header in http headers -v Print response headers SEE ALSO
c-icap(8) c-icap-stretch(8) c-icap-config(8) c-icap-libicapapi-config(8) c-icap-mkbdb(8) BUGS
Many... AUTHOR
Tsantilas Christos c_icap 0.1.6 c-icap-client(8)