But i want order of the loaded data in the table to look exactly like CASE-1. Could anyone please help me out in this case?
columns 1 & 2 are Primary keys. I have tried load this data using a load job like below:
LOAD DATA RESUME YES
INDDN(SYSREC) LOG NO
SORTDEVT SYSDA SORTNUM 96
INTO table name
But the ouput looks as like in CASE-2.Even i have written one cobol program for loading the data in DB2 table. But the output looks like CASE-2. Can any body suggest something for this issue?