I have an input file with an indicator as last character. Depending on the last character, we have to either "UPDATE" or "INSERT" or "DELETE" the record of the table. Can we do this using DSNUPROC utility?
E.g., I have records as shown below.
11111 243243 4664346 U
22222 364553 3466344 M
33333 333333 8788674 D
Here "U", "M", "D" are indicators and Let's say these are at 40th position in the input file. If this indicator is "U", I want to insert the record into table; if "M", update the record and so on....
I know, we can do this using COBOL-DB2 program but can we do it using DSNUPROC utility?