What is the syntax required for the creation of

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

(Continued from previous question...)

What is the syntax required for the creation of a cursor ?

EXEC SQL
DECLARE cur_name CURSOR for 
  SELECT col1,col2    
  FROM table1
  WHERE col1=search_condition
END_EXEC

(Continued on next question...)

Other Job Interview Questions

• Explain what a plan?
• What is the equivalent COBOL DATA Type for Decimal(x,y) in DB2 ?
• What is auditing
• What is the syntax of SELECT statement when embedded in a COBOL program ?
• What is the difference between join and union ?
• What is the size of a data page ?
• What is an asychronous write?
• What is the difference between group by and order by ?
• What is the COBOL picture clause for a DB2 column defined
• What are the levels of isolation available with DB2V4?
• More...