I am trying to create a Load card while doing BMC Unload of my table. I am using the below unload card.
//SYSIN DD *
UNLOAD
FORMAT CSV TERMINATEDBY ';' ENCLOSEDBY ''
NULLSTRING ''
UNICODE
TSFMT('YYYY-MM-DD HH:MM:SS.NNNNNN')
UNLOADDN SYSREC ACTIVE NO
SHRLEVEL CHANGE
SORTDEVT SYSDA
SORTNUM 4
SELECT *,X'0A'
FROM WCC12.XLOCATIONPREF;
//SYSREC DD DSN=MBTT.UNLOAD.XLOCPREF.TAPE.WCC12.OCT05,
// UNIT=CARTG00,VOL=(,,,10),
// DISP=(NEW,CATLG,DELETE)
//*
//SYSCNTL DD DSN=MBTT.UNLOAD.XLOCPREF.CNTL.WCC12.OCT05,
// DISP=(NEW,CATLG,CATLG),
// SPACE=(TRK,(1,1),RLSE),
// UNIT=SYSDA
UNLOAD
FORMAT CSV TERMINATEDBY ';' ENCLOSEDBY ''
NULLSTRING ''
UNICODE
TSFMT('YYYY-MM-DD HH:MM:SS.NNNNNN')
UNLOADDN SYSREC ACTIVE NO
SHRLEVEL CHANGE
SORTDEVT SYSDA
SORTNUM 4
SELECT *,X'0A'
FROM WCC12.XLOCATIONPREF;
//SYSREC DD DSN=MBTT.UNLOAD.XLOCPREF.TAPE.WCC12.OCT05,
// UNIT=CARTG00,VOL=(,,,10),
// DISP=(NEW,CATLG,DELETE)
//*
//SYSCNTL DD DSN=MBTT.UNLOAD.XLOCPREF.CNTL.WCC12.OCT05,
// DISP=(NEW,CATLG,CATLG),
// SPACE=(TRK,(1,1),RLSE),
// UNIT=SYSDA
But the control card data set is created with Invalid block size and I am not able to use the same for load purpose. Can someone please let me know how to create a load card to load data back to DB2 using BMC?
Thanks
Prasanna G.
