View previous topic :: View next topic
|
Author |
Message |
karthikuma
New User
Joined: 29 Mar 2005 Posts: 62
|
|
|
|
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 |
|
|
manjunathbhosale
New User
Joined: 18 Mar 2005 Posts: 6 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.. |
|
Back to top |
|
|
sangiah
New User
Joined: 10 Jun 2005 Posts: 62
|
|
Back to top |
|
|
dsbhati
New User
Joined: 13 Jun 2005 Posts: 10 Location: india
|
|
|
|
CAN ANYBODY TELL ME WHAT IS DIFFERENCE B/W SQLCODE AND SQLSTATE?? |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
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 |
|
|
|