A program that includes SQL statements needs to have an area
set apart for communication with DB2an SQL communication area (SQLCA).
When it processes an SQL
statement in a program, DB2 places return codes in the SQLCODE and
SQLSTATE host variables or corresponding fields of the SQLCA.
The return codes indicate whether the executed statement
succeeded or failed.
Because the SQLCA is a valuable problem-diagnosis tool, it
is a good idea to include instructions to display some of the information
contained in the SQLCA in your application programs.
For example, the contents
of SQLERRD(3), which indicates the number of rows that DB2 updates,
inserts, or deletes, could be useful. If SQLWARN0 contains W,
DB2 has set at least one of the SQL warning flags (SQLWARN1 through
SQLWARNA).
No comments:
Post a Comment