IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Viewing the content of SQLCA and its need


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Rupesh Gupta

New User


Joined: 10 Jan 2007
Posts: 13
Location: Chennai

PostPosted: Thu Apr 12, 2007 12:50 pm
Reply with quote

hi can anyone tell me how can i view contents of SQLCA.. and wht is the need of this
Back to top
View user's profile Send private message
Shobana Bhaskar

New User


Joined: 02 Mar 2007
Posts: 35
Location: Pennsylvania, US

PostPosted: Thu Apr 12, 2007 1:43 pm
Reply with quote

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
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Sun Apr 15, 2007 12:00 pm
Reply with quote

Hi rupesh,


For more information on SQLCA viit the link


publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0001741.htm
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Reformat and relocate content DFSORT/ICETOOL 4
No new posts Setting CA7 user variable from data s... CA Products 7
No new posts REXX table content on panel will be r... CLIST & REXX 6
No new posts How to modify file content using REXX CLIST & REXX 3
No new posts I need help with SQLCA DB2 8
Search our Forums:

Back to Top