We recently acquired an ERP package that keeps the database on the AS/400 and the executables in AS/400's IFS.
The files in the AS/400 stored database, have NULL and variable length fields. The connectivity is through CAExpress TCP/IP connection.
The question is: How can we write an RPG program on the AS/400 which can read, change, update, add NULL and Variable length fields in the database, and then how can the PC Users execute that RPG program from IFS?
I would suggest that you consult the RPG reference manual for more info on how to deal with variable length fields and nulls.here