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

COBOL SQL Interview Questions

(Continued from previous question...)

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

Either by using the single row SELECT statements, or by using the CURSOR.

(Continued on next question...)

Other Interview Questions

• How do you retrieve the first 5 characters of FIRSTNAME column of EMP table?
• When is it necessary to create a table index?
• When is it necessary to create a table index?
• What is a tuple?
• What is a cursor?
• Any SQL implementation covers data types in couple of main categories. Which of the following are those data types?
• Explain the use of the WHERE clause?
• What is the difference between group by and order by ?
• What is an index key?
• What is UNION, UNION ALL?
• More...