Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
What is SQLCA, What is contains

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: What is SQLCA, What is contains
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    Post subject:
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    Post subject: Re: What is SQLCA, What is contains
Reply with quote

For more details.. pls follow the link

http://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    Post subject:
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: 1452
Location: Chicago, IL

PostPosted: Mon Jun 20, 2005 12:31 pm    Post subject: Re: What is SQLCA, What is contains
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Access SQLCA fields inside a stored p... gangapd DB2 6 Thu Oct 27, 2016 10:20 am
No new posts DB2 error "SQLCA" WAS NOT D... Kalyan Padigala ABENDS & Debugging 6 Wed Mar 14, 2012 9:15 pm
No new posts Error code -911 SQLCA:SQLCA :40001 00... Sajitha S ABENDS & Debugging 4 Mon May 17, 2010 7:51 pm
No new posts SQLCA location Arun Aravind DB2 4 Sat Oct 11, 2008 10:15 am
No new posts Why we need SQLSTATE in the SQLCA pjnithin Mainframe Interview Questions 4 Wed Jun 13, 2007 11:34 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us