How do you specify and use a cursor in a COBOL program?

COBOL SQL Interview Questions

(Continued from previous question...)

How do you specify and use a cursor in a COBOL program?

Use DECLARE CURSOR statement either in working storage or in procedure division ( before open cursor), to specify the SELECT statement. Then use OPEN, FETCH rows in a loop and finally CLOSE.

(Continued on next question...)

Other Interview Questions

• What is the use of VALUE function?
• What RDMS objects are crested with the SQL CREATE statements?
• What is a NULL value? What are the pros and cons of using NULLS ?
• What is the result of this query if no rows are selected: SELECT SUM(SALARY) FROM EMP WHERE QUAL='MSC'; ?
• How do you eliminate duplicate values in SELECT?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• What are correlated subqueries?
• Where in a table are added column located ?
• How do you eliminate duplicate values in SELECT?
• Can you use MAX on a CHAR column?
• More...