View previous topic :: View next topic
|
Author |
Message |
Rupesh Gupta
New User
Joined: 10 Jan 2007 Posts: 13 Location: Chennai
|
|
|
|
hi can anyone tell me how can i view contents of SQLCA.. and wht is the need of this |
|
Back to top |
|
|
Shobana Bhaskar
New User
Joined: 02 Mar 2007 Posts: 35 Location: Pennsylvania, US
|
|
|
|
Hi Rupesh,
SQLCA is a collection of SQL variables(Copybook for SQL variables) .
For eg. after excuting your SQL statement in program, you would check for SQLCODE. This SQLCODE is a 05 level variable of SQLCA. All the variables that are used/to be updated after SQL statement execution are defind under SQLCA. |
|
Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
Back to top |
|
|
|