How would you retrieve rows from a DB2 table in

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

(Continued from previous question...)

How would you retrieve rows from a DB2 table in embedded SQL? –

Either by using the single row SELECT statements, or by using the CURSOR.
Apart from cursor, what other ways are available to you to retrieve a row from a table in embedded SQL? -
Single row SELECTs.

(Continued on next question...)

Other Job Interview Questions

• How do you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP ?
• How do you insert a record with a nullable column?
• A VARCHAR column REMARKS would be defined as follows:
• What is the result of this query if no rows are selected:
• What is a clustered index?
• Why SELECT * is not preferred in embedded SQL programs?
• Is DECLARE TABLE in DCLGEN necessary? Why it used?
• How do you do the EXPLAIN of a dynamic SQL statement?
• What is difference between 911 and 913 error code in DB2 ?
• What is ALTER ?
• More...