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 |
Normalization in DB2 – first normal form, second normal form
What is dclgen (declaration generator)?
What is the picture clause of the null indicator variable?
what is SMP/E? and what are the major steps of it? thanks...
How does DB2 store NULL physically?
What are the contents of a dclmgen?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
why we go for SPUFI for creating tables or for sql queries?
What does the REORG Utility do?
What is DCLGEN ?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What's The Percentage Free Space ?