What is the retriction on using UNION in embedded SQL?

COBOL SQL Interview Questions

(Continued from previous question...)

What is the retriction on using UNION in embedded SQL?

It has to be in a CURSOR.

(Continued on next question...)

Other Interview Questions

• When do you use a LINK statement ?
• How do you select a row using indexes?
• How do you eliminate duplicate values in SELECT?
• My SQL statement SELECT AVG(SALARY) FROM EMP-TABLE yields inaccurate results. why?
• What is meant by an index?
• Explain the use of the WHERE clause?
• What authority is required to create a table?
• What is the difference between static and dynamic SQL?
• What is normalization and what are the five normal forms?
• How do you specify and use a cursor in a COBOL program?
• More...