Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

return DB2 SQLCODE

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting return DB2 SQLCODE
# 1  
Old 11-16-2005
return DB2 SQLCODE
Hello All,

I have 2 shell scripts.
script1.sh
script2.sh

script1.sh call script2.sh

script2 will connect to DB2 database and execute a insert statement. I am capturing the return value of insert statement in an variable called SQLCODE. I want to return this SQLCODE to the calling script script1.sh

SQLCODE can have negative values and positive values which are more than 255. There should be a way to send the SQLCODE accross the scripts. How do I return or capture the SQLCODE in script1?

exit $SQLCODE or exit $RETCODE does not help.

Thanks for the help. Appreciate it.
-Jai
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Return: can only `return' from a function or sourced script

Not sure where the problem is. I can run the script without any issue using the following command. . /opt/app/scripts/cdc_migration.sh But it fails with the below error when I try it this way /opt/app/scripts/cdc_migration.sh /opt/app/scripts/cdc_migration.sh: line 65: return: can only... (1 Reply)
Discussion started by: svajhala
1 Replies

2. Shell Programming and Scripting

DB2 in awk

Hi, I want to retrieve the base table name for a table and replace the table with the view name in the file. I was trying to retrieve the base with the below db2 command but i am getting "1" as return value. Could you anyone please assist ? Table_name=system("db2 -x... (4 Replies)
Discussion started by: Nandy
4 Replies

3. Shell Programming and Scripting

Return db2 query value to shell script

Hi, Im new to DB2. I need to connect to DB2 from shell script and return the query output back to shell script variable. this is my code #!/bin/ksh db_name=db db_user=usr db_pwd=pwd db2 <<EOSQL connect to $db_name user $db_user using "$db_pwd" select count(1) from table quit EOSQL ... (3 Replies)
Discussion started by: sup
3 Replies

4. Shell Programming and Scripting

Connect db2 using db2 connect

I want to connect to DB2 database which is mainframes using a unix script and run query and get the result set into the unix box. Is this acheivable using db2 connect? pls help me with a sample script which can perform the same. (1 Reply)
Discussion started by: midhun19
1 Replies

5. AIX

DB2 basics

Dear friends I am going to study DB2 and i dont have any experience with any DB's.. Please provide me with some links or pdf's for DB2 starters. any advice will be very usefull (2 Replies)
Discussion started by: Vit0_Corleone
2 Replies

6. Shell Programming and Scripting

db2

i want to run a db2 query though shell script but i want my where condition element to chnage everytime like class_nm='abc' next time class_nm='def' next time i want it to do by passing parameters to unix script can someone give example how can i do it (0 Replies)
Discussion started by: er_zeeshan05
0 Replies

7. UNIX for Advanced & Expert Users

how to get SQLCODE ?

Suppose I am executing a sql query thru shell script. DB : IBM DB2 If none of the rows are fetched, I will be getting the sql code as 100 If rows > 0 are fetched, I will be getting the sqlcode as 0 Can any one help me how to get this SQL code in unix shell script (in KSH) ... (1 Reply)
Discussion started by: regnumber
1 Replies

8. UNIX for Dummies Questions & Answers

Exception while loading DB2 driver Class.forName("com.ibm.db2.jcc.DB2Driver")

Hi... I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies

9. 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

10. AIX

DB2 Monitoring

Hi everyone. I am currently looking for a monitor to monitor my DB2 UDB database, which runs on AIX 5.3. Does anyone here use any good ones or has anyone heard of any good ones? I especially need to monitor which applications run at any given time, so that I am able to ballance the workload... (0 Replies)
Discussion started by: sprellari
0 Replies
Login or Register to Ask a Question

LEARN ABOUT PHP

db2_stmt_error

DB2_STMT_ERROR(3)							 1							 DB2_STMT_ERROR(3)

db2_stmt_error - Returns a string containing the SQLSTATE returned by an SQL statement

SYNOPSIS

       string db2_stmt_error ([resource  $stmt])

DESCRIPTION

	Returns a string containing the SQLSTATE value returned by an SQL statement.

	If  you  do  not  pass a statement resource as an argument to db2_stmt_error(3), the driver returns the SQLSTATE value associated with the
       last attempt to return a statement resource, for example, from db2_prepare(3) or db2_exec(3).

	To learn what the SQLSTATE value means, you can issue the following command at a DB2 Command Line  Processor  prompt:  db2  '?	$sqlstate-
       value'. You can also call db2_stmt_errormsg(3) to retrieve an explicit error message and the associated SQLCODE value.

PARAMETERS

	      o $stmt
		- A valid statement resource.

RETURN VALUES

	Returns a string containing an SQLSTATE value.

SEE ALSO

       db2_conn_error(3), db2_conn_errormsg(3), db2_stmt_errormsg(3).

PHP Documentation Group 													 DB2_STMT_ERROR(3)