RPGLE Embedded SQL is getting a SQL0305 (SQLcid-305, sqlstate 22002) when fetching the next record from a view. This is pointing to null values encountered.
/free exec sql fetch next from C1 into :wtclaims ; /end-free
Wtclaims is an Externally Described Data structure.
There could be null values in any field in the ds over the files.
What are mt options to handle null values?
Ihave noted code where 'not null' is used. Do I have to do this for each field? Can something be done for the whole DS or as a compile option?
AS400 RPGLE SQL
June 20, 2011 3:33 PM
June 24, 2011 1:32 PM