I have some SQLRPGLE problems with reading a tabel (with null capable fields)
The program reads a record in a DS , change 2 fields and write it to a remote (identical) table.
But I have to add a null "check field" per field
exec sql fetch next from cIMPH INTO
In this example it's not a problem, but I need to do this for a file with round 100 fields.
So I prefer to use the SQL
exec sql fetch next from cIMPH INTO :DS;
On top of that, if I use the null-check field, the original field contains a space or a zero.
the remote table expect null values.
How can I solve this?