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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!