How do you display the Current SQLSTATE or SQLCODE

[APP1MVF]

Question:
I come from a COBOL/DB2 environment so I am use to being able to display the current SQLSTATE or SQLCODE following the issuing of a DB2 command, now I have move over to a LINUX/DB2 shell scripting environment and I am looking to see if it is possible for me to do the same in a shell script.

So is it possible to display the current sqlcode or sqlstate and only the sqlcode or sqlstate?
Could someone please give me an example?

Thank You

[APP1MVF]

Question:
I come from a COBOL/DB2 environment so I am use to being able to display the current SQLSTATE or SQLCODE following the issuing of a DB2 command, now I have move over to a LINUX/DB2 shell scripting environment and I am looking to see if it is possible for me to do the same in a shell script.

So is it possible to display the current sqlcode or sqlstate and only the sqlcode or sqlstate?
Could someone please give me an example?

Thank You

I will answer my own question:

sqlcode=`db2 -ec +o "Enter your db2 statement here"`

The –ec switch is interpreted as display sqlcode; to display sqlstate use –es.

I hope this helps other people out there.

[docdiesel]

Hi,

first, I reformatted your last post slightly for better readability. Second, thanks a lot for posting your solution and sharing with us! Third, the shell is saving the return code of the last command in the variable "$?" which could be useful for you, too. If everything was OK, DB2 (and most unix/linux commands) return 0 (which means true). Error returns false which is something different than 0 (usually 1) and the value may be giving you additional hints what went wrong.

OUT=` db2 -es +o "your sql statement" `
echo DB2 return code is ${?}
echo DB2 sqlstate is ${OUT}

Regards,

Bernd