The IRD issues SQL insert and update calls.
EXEC SQL
INSERT INTO TB_MYFILE (
MYFILE_KEY,
MYFILE_COL1,
MYFILE_COL1,
MYFILE_COL3)
VALUES (
:HV-KEY,
:HV-COL1,
:HV-COL2,
:HV-COL3:HVNULL-IND)
The column MYFILE_COL3
is nullable. The working storage variable HVNULL-IND
is the null indicator field. A value less than 0 will result in a
null value for this insert.