How do you select a row using indexes?

COBOL SQL Interview Questions

(Continued from previous question...)

How do you select a row using indexes?

Specify the indexed column in the WHERE clause.

(Continued on next question...)

Other Interview Questions

• Can one add columns to a table after it has been defined?
• What is the meaning of underscore ...
• Where in a table are added column located ?
• When do you use a LINK statement ?
• Why SELECT * is not preferred in embedded SQL programs ?
• Explain the use of the WHERE clause?
• How do you specify and use a cursor in a COBOL program?
• How do you retrieve the first 5 characters of FIRSTNAME column of EMP table?
• When do you use a LINK statement ?
• Can you use MAX on a CHAR column?
• More...