Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Need help with return code 1...

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help with return code 1...
# 1  
Old 11-26-2008
Need help with return code 1...
Hi Guys,,

I am having a unix script which is running the DB2 Insert command.
For the insert command, there were no records to be updated.

SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a
query is an empty table. SQLSTATE=02000
+ + echo 1
STAGE_RC=1
+ [[ 1 != 0 ]]

Because of this, it is returning return code as 1.
My script will work, only if this part of the script is successful as u can see the in the code above.

all 1 in the codes are return code.

is it because of the DB2 insert statement or is it due to something else..When will the return code be 1??
# 2  
Old 12-05-2008
I found your post confusing. What command do you run that gives you the exit code of 1? The output you showed above is an unsuccessful fetch/update/delete because the table was empty. I would expect a 1 returned from such a script.
# 3  
Old 12-11-2008
sorry guys i inserted the script but somehow the log file got pasted..
# 4  
Old 12-11-2008
thanks otheus,, so in the case of no rows found for update or insert,, the return code willl be 1.. rite??

But the same script is running fine, for the other family codes which also shares the same scenario.. (No rows found for update or insert)

could you please explain me that?
# 5  
Old 12-11-2008
Like I said, I would expect the return code from such a command to be 1. But since you did not post the command, I cannot possibly know. I probably wouldn't know anyway, since I have very little experience with DB2. I recommend you repost in the "Database" or "AIX" forums with "such-and-such command sometimes returns 1 on failure".
# 6  
Old 12-11-2008
This is the piece of code causing trouble.. otheus..

db2 "insert into table \
(col,,,,\
) \
select * from tab1 a, tab2 b where\
a.id=b.id \
with ur"

STAGESUM_RC=`echo $?`
if [[ $STAGESUM_RC != "0" ]] ; then
ReturntoParent $STAGESUM_RC "Error in Insert Fact Stage_Sum"
fi
db2 "commit"
# 7  
Old 12-11-2008
I doubt this will change anything, but it's better to change the first line to:
Code:
STAGESUM_RC=$?

Still, the db2 error indicates that your select * is failing. Is it possible that select sometimes returns an empty result?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Expect return code

Hello everyone Can some help me with understand return code in expect #!/usr/bin/expect set timeout 1 set SRV set user set pw spawn ssh $user@$SRV expect { "(yes/no)? " { send "yes\r" ; exp_continue } "assword: " { send "$pw\r" ; exp_continue } eof }... (2 Replies)
Discussion started by: vikus
2 Replies

2. Shell Programming and Scripting

How could I use the value of return code

Hello, I am woring on a script where I am getting strange situation.This script actually fetch the source code and tar that code and send to NAS location.This code resides in MKS tool...and we are fetching the source code on checkpoint label basis and script is working fine.First it synch the... (0 Replies)
Discussion started by: anuragpgtgerman
0 Replies

3. Shell Programming and Scripting

Getting error return code

I need to try and get the error return code from the tar command when being used as follows: tar tvf tarfile 2>logfile | tee -f outputfile ErrorStat="$?" I would like to save the error return code from the tar command in a variable, howver, the example above it is saving the 'tee' error... (7 Replies)
Discussion started by: nck
7 Replies

4. Shell Programming and Scripting

return code help

Hello folks, I have a question that if i type ls command and type echo $? it always show "0", how i could do this change that when i type ls it will show me 1, actually i want to change the return code of commands from 0 to 1. Thanks Bash (5 Replies)
Discussion started by: learnbash
5 Replies

5. UNIX for Dummies Questions & Answers

to pick up the Return Code ( RC) from the mailx command and return it to SAS uisng 's

Hi All, Can anyone please let me know the syntax / how to pick up the Return Code ( RC) from the mailx command and return it to SAS uisng 'system()' function and '${?}'. I am in a process to send the mail automatically with an attachment to bulk users. I have used 'Mailx' and 'Unencode'... (0 Replies)
Discussion started by: manas6
0 Replies

6. Shell Programming and Scripting

how to get return code in one line

I know how to get the returning code of a function but wonder if I can combine the follwoing two lines into one: e.g.: #!/bin/shell ... #line 1 MyFunction arg1 arg 2 #line 2 rec=$? #this will be evaluated later .... like in c/c++, we'd write one line: rec=MyFunction(arg1, arg 2) ... (6 Replies)
Discussion started by: bluemoon1
6 Replies

7. Shell Programming and Scripting

asking about return code

hi all my system is linux red hat i have a script that runs some object . the object return some code to the system i see the code by writing echo $? i want to ask in the script if $? equals 14 how shell is do that in the script thanks (3 Replies)
Discussion started by: naamas03
3 Replies

8. Programming

Return code from system()

Hi, Can any one help me in knowing how can I get the return codes/Error codes when using the system() command to fork a command? Regards, MK (1 Reply)
Discussion started by: mradulkaushik
1 Replies

9. Shell Programming and Scripting

how to get error return code

I have a unix AIX script that ftps some files (mput, mget). How can I check (in the script) to see if the ftp failed? After the ftp I move the files out of the directory but do not want to move files that have not been sent. The script will run as a cron job. (2 Replies)
Discussion started by: rayg50
2 Replies

10. UNIX for Advanced & Expert Users

Return code from PL/SQL Code

Hi Guys, I was just wondering if anybody can help me with this problem. OK, how we can get a value back from PL/SQL Script (not stored procedure/function) See the below example: (for example aaa.sh) #!/bin/ksh VALUE=`sqlplus -s user/password@test_id <<EOF @xxx.sq EOF` echo $VALUE ... (7 Replies)
Discussion started by: Shaz
7 Replies
Login or Register to Ask a Question