What is the syntax of SELECT statement when embe

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

(Continued from previous question...)

What is the syntax of SELECT statement when embedded in a COBOL program ?

EXEC  SQL 
   SELECT col_name,col_name2,col_name3
   INTO hos_var1,hos_var2,hos_var3
   FROM owner.tablename
   WHERE condition
END_EXEC  

(Continued on next question...)

Other Job Interview Questions

• Which command is issued to establish the Boot Strap Data Set after an I/O failure?
• Why might full image copies be faster to implement than an incremental image copy?
• What is a LIKE table and how is it created?
• Which DB2 command is used to retireve environmental information?
• Can ALl Users Have The Privilege To Use The SQL Statement Select * (DML) ?
• What types of copies can be made with the COPY Utility?
• Where is the output of EXPLAN stored?
• Why use RUNSTAT Utility?
• Explain transactions, commits and rollbacks in DB2?
• What is the difference between TYPE 1 index and TYPE 2 index?
• More...