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

What is SQLCA, What is contains


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

New User


Joined: 29 Mar 2005
Posts: 62

PostPosted: Tue Jun 14, 2005 10:13 am
Reply with quote

hi,

wat is SQLCA?wat are the values it contains.whether in sqlca only sqlcode only exists (or) even the file status,even the cobol error also defined on that sqlca.any one explain me cleasrly.

regards,
kumar.
Back to top
View user's profile Send private message
manjunathbhosale

New User


Joined: 18 Mar 2005
Posts: 6
Location: bangalore

PostPosted: Tue Jun 14, 2005 2:14 pm
Reply with quote

hi

The SQL communications area (SQLCA) structure is used by the database manager to return error information to an application program. This structure is updated after every SQL statement issued.

some of SQLCA are
SQLERRM (sql error messages)
SQLWARN (sql warning messages)
SQLSTATE
SQLCODE
SQLCABC (Lenght of sqlca)
etc..
Back to top
View user's profile Send private message
sangiah

New User


Joined: 10 Jun 2005
Posts: 62

PostPosted: Wed Jun 15, 2005 9:08 am
Reply with quote

For more details.. pls follow the link

publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0002212.htm
Back to top
View user's profile Send private message
dsbhati

New User


Joined: 13 Jun 2005
Posts: 10
Location: india

PostPosted: Mon Jun 20, 2005 12:08 pm
Reply with quote

CAN ANYBODY TELL ME WHAT IS DIFFERENCE B/W SQLCODE AND SQLSTATE??
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Mon Jun 20, 2005 12:31 pm
Reply with quote

Did you check the link given here....

sqlstate CHAR(5) A return code that indicates the outcome of the most recently executed SQL statement

One more thing....SQLSTATE is a standard set of error messages and warnings in which the first two characters defines the class and the last three defines the subclass of the error.

Regards,

Priyesh.
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 I need help with SQLCA DB2 8
No new posts Confusion regarding length of SQLCA v... DB2 4
No new posts Access SQLCA fields inside a stored p... DB2 6
No new posts DB2 error "SQLCA" WAS NOT D... ABENDS & Debugging 6
No new posts Error code -911 SQLCA:SQLCA :40001 00... ABENDS & Debugging 4
Search our Forums:

Back to Top