Insert value (null or not null) into a null capable file field.

[rick baird <rick.baird@xxxxxxxxx>]

Hey all,

trying to insert (SQLRPGLE) a record into a file, several fields could
be null, could be not.

D $DueNull                       2b 0

C/exec sql
C+
C+   insert
C+     into    MYFILE
C+  values( default   ,
C+           :$DEPT     ,
C+           :$DueDate :$DueNull  ,
C+            default       )
C+           with    NC
C+
C/end-exec

Will this work?   If I set $DueNull = -1, the field will be null, if
0, not null?

Thanks,

Rick