Create Table SAMP_TAB SN CHAR (10) SNAME CHAR (10) STATUS CHAR (2) NOT NULL BY DEFAULT CITY CHAR (10) NOT NULL
02 SNAME-INDNULL S9(4) comp 05 SN-IN S9(4) comp
-1 : Field is having NULL value 0 : Field is Not NULL value -2 : Field value is truncated
MOVE -1 to SNAME-INDNULL EXEC SQL INSERT INTO SAMP_TAB (SN,SNAME,STATUS,CITY) VALUE (:SN,:SNAME:SNAME-INDNULL,:STATUS,:CITY) END-EXEC
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!