What is the SQL Communications Area and what are

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the SQL Communications Area and what are some of its key fields?

It is a data structure that must be included in any host-language program using SQL. It is used to pass feedback about the SQL operations to the program. Fields are return codes, error messages, handling codes and warnings.

(Continued on next question...)

Other Job Interview Questions

• What should be specified along with a cursor in order to continue updating process after commit ?
• How do you retrieve the data from a nullable column?
• What is a clustering index ?
• How could one combine a set of incremental image copies into a single copy?
• How to define the data items to receive the fetch items for the SQL?
• What is an asychronous write?
• Where is the output of EXPLAN stored?
• What are the advantages of using a PACKAGE?
• Can you access the DB2 Directory table using SQL?
• In terms of DB2 indexing, what is the root page ?
• More...