My problem is that I’m basically doing an interactive update/create file (similar to DFU).
The user is able to maintain a file in the screen, so how do I go about updating the ENTIRE File without having to manually update every record?
I have a datastructure (cpRec) to put in the info from the file using SQL
D cpRec e ds Extname(CUSPRF) Prefix(cp)
If my screen fields are the exact same fields as the file (except with a sc prefix), how can I update the file with the screen fields without doing
CustNo = :scCustNo,
OrderNo = :scOrderNo,
Locations = :scLocation…and so on…
I thought I could just use another DS for the screen fields
D scRec e ds Extname(CUSPRF) Prefix(sc)
and then somehow move that into the file:
Set Row = :scRec
but when I run it I get a data decimal error on the dspf.