Wednesday, June 25, 2008

Mainframe--Sqlca Components

-------------------Components of sqlca-------------------
sqlcaid - This string component is initialized to "SQLCA" to identify the SQL Communications Area.
sqlabc - This integer component holds the length, in bytes, of the SQLCA structure
sqlcode - This integer component holds the status code of the most recently executed SQL statement
sqlerrm -
sqlerrm contains sqlerrml and sqlerrmc
---------------------------------------
sqlerrml- This integer component holds the length of the message text stored in sqlerrmc.
sqlerrmc- This string component holds the message text corresponding to the error code stored in sqlcode.
sqlerrp - This string component is reserved for future use.
sqlerrd -
sqlerrd[0] -component is reserved for future use.
sqlerrd[1] - This component is reserved for future use.
sqlerrd [2] - This component holds the number of rows processed by the most recently executed SQL statement.
sqlerrd[3] - This component is reserved for future use.
sqlerrd[4] - This component holds an offset that specifies the character position at which a parse error begins in the most recently executed SQL statement. The first character occupies position zero.
sqlerrd[5]- This component is reserved for future use.
sqlwarn - This has eight elements.
sqlext - This string component is reserved for future use.

No comments:

Post a Comment