I have a problem: migrating from BMC to IBM LOAD, I encountered a problem with a SYSIN that looks like:
LOAD .... REPLACE ...
INTO TABLE CREATOR.TBNAME
(COL1 POSITION(3:12) DATE EXTERNAL(10)
,COL2 POSITION(13:21) CHAR (9)
(COL1 POSITION(4:13) DATE EXTERNAL(10)
,COL2 POSITION(14:22) CHAR (9)
Notice that the WHEN condition is used in order to find the same data in a diferent place inside the SYSREC.
At execution, I got: INVALID OPERAND ''00'' FOR KEYWORD 'WHEN' for the second WHEN.
Is there a way to make it run with IBM LOAD V7? (It worked with BMC)I can't change the SYSREC file?
My environment is OS390 and DB2 V7.1.