SOLVED: Consider an EMPLOYEE table with the below structure: ID Decimal(5,0) NAME ...

Consider an EMPLOYEE table with the below structure:
ID Decimal(5,0)
NAME Char(10)

Assume there are no syntax errors in the below snippet and there are no rows in the table.
PROCEDURE DIVISION.
MAIN-PARA.
EXEC SQL
SELECT MAX(ID) INTO :WS-ID FROM EMPLOYEE
END-EXEC
DISPLAY ' ID: ' WS-ID
STOP RUN.

Which of the following is correct?

ID: will be displayed

there will be a compilation error

ID: 00000 will be displayed and an error stating that null values cannot be assigned to a host variable

A bind error for missing null value INDICATOR Variable

Verified Answer

Correct Option - c

To get all Infosys Certified Mainframe COBOL-DB2 Programmer Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Important Links

Privacy Policy

Refund Policy

Terms & Conditions

About Us

Contact Us