What is SQLCA, What is contains

karthikuma · Active User Joined: 29 Mar 2005 Posts: 65

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.

manjunathbhosale · New User Joined: 18 Mar 2005 Posts: 7 Location: bangalore

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..

sangiah · Active User Joined: 10 Jun 2005 Posts: 64

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

dsbhati · New User Joined: 13 Jun 2005 Posts: 10 Location: india

CAN ANYBODY TELL ME WHAT IS DIFFERENCE B/W SQLCODE AND SQLSTATE??

priyesh.agrawal

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.