What is the SQL Communications Area and what are some of
its key fields?
Answer / s
SQLCA is a collection of variables that is updated after
the execution of the SQL statment.
The values in these variables tells if the SQL completed
successfully or not and for testing specific error
conditions.
SQLCODE, SQLSTATE, SQLERRD(3)
| Is This Answer Correct ? | 1 Yes | 0 No |
What is pagespace?
What is the cascade rule and how does it relate to deletions made with a subselect?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What is the logical entity between plan and Package?
what is a trigger and types of triggers
What is declare cursor?
What is concurrency in db2?
What is the difference between Primary key and unique index?
What is the maximum number of columns in a db2 table?
What does DSNDB07 database do?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?