DB2 Utility DSNTIAUL can be used to unload a table to a dataset.
Suppose table is defined as:
CREATE TABLE TESTTAB(
ID DECIMAL(4, 0) NOT NULL,
NAME CHAR(06) NOT NULL,
ADDRESS VARCHAR(10) NOT NULL,
EMAIL VARCHAR(06),
PHONE CHAR(04),
PRIMARY KEY(ID)
);
The DSNTIAUL JCL can be:
//UNLDTBL JOB (DSNTEP4),'UNLDTBL',REGION=0M,CLASS=2,MSGCLASS=X,
// NOTIFY=&SYSUID
//*------------------------------------------*
//* UNLOAD THE RDBMS TABLE: TESTTAB
//* INTO <UID>.TEST.UNLDTBL.DATA
//*------------------------------------------*
//* DELETE LOG, DATA AND SYSPUNCH FILES
//*------------------------------------------*
//DEL EXEC PGM=IDCAMS
//SYSPRINT DD SYSO