What is the SQL Communications Area and what are some of
its key fields?
Answer / s
SQL CA is a collection of variables that is updated after
the execution of an SQL statement.
SQLCODE - SQL return code indicates if the execution was
successful or not and no data found conditions.
SQLSTATE - SQL return codes that can be used to test
specific error conditions.
SQLERRD(3)-Contains the no. of rows updated/inserted/deleted
| Is This Answer Correct ? | 2 Yes | 0 No |
What type of database is db2?
How to design maps
How could one combine a set of incremental image copies into a single copy?
When is the authorization check on DB2 objects done - at BIND time or run time?
How can you classify the locks in db2?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is db2 plan table?
what is SPUFI ?
what is the name of the default db2 catalog database?
What is the clustering index in the db2 database?
If I have a view which is a join of two or more tables, can this view be updateable?
When will you chose to run RUNSTATS?