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