Hi friends,

Can we able to see SQLCA components after executing a query in QMF...?
I am using DB2 Version 8.1 on Z/OS...

You should be able to use the SHOW GLOBALS command and the SQLCA is at the end of the list of globals. If, I remember correctly a +100 will show up with a SQLRC of 0, something QMF does, not sure the reason behind that.
Dave Nance

Hi Dave,

I tried using SHOW GLOBALS.....It is listing SQLCODE and SQLSTATE values...But it is not showing up other components suchas SQLERRD, SQLERRP, SQLERRM...

Thanks for your reply....
Saidulu