Hello.
We are trying to unload the db2 table uusing file manager and creating a CSV
file, the below is the error we are getting. Could some one please help us and
let us know what could be the issue ? or is there any other way we can download
the file to a CSV format.
//FMNDB2 EXEC PGM=FMNDB2,PARM=('SSID=DBKU,SQID=P4LX13V')
//STEPLIB DD DSN=SYS1.IFM.SFMNMOD1,DISP=SHR
// DD DSN=SYS5.DBGU.SDSNEXIT,DISP=SHR
// DD DSN=SYS5.DBGU.SDSNLOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//FMNTSPRT DD SYSOUT=*
//SYSTERM DD SYSOUT=*
//FMNOUT DD DSN=USMKT.SL2P.KUSMDW01.CUSSTO.F2B23.UNL1,
// UNIT=CART,VOL=(,RETAIN,,30),LABEL=01,
// DISP=(NEW,CATLG,CATLG)
//SYSIN DD *
$$FILEM DBX OBJIN="T23MDW01"."PUS_STO",
$$FILEM OUTPUT=FMNOUT,
$$FILEM NULLIND=_,
$$FILEM CSV=YES,
$$FILEM CSVHDR=YES,
$$FILEM DATAFORMAT=CSV,
$$FILEM SEPARATOR=',',
$$FILEM ROWS=ALL
FMNBA318 Output data set FMNOUT /USMKT.SL2P.KUSMDW01.CUSSTO.F2B23.UNL1 OPEN
failed ABEND code 013-34 . FMNDB801 Export function was canceled by the user,
or error encountered while prrocessing the copybook
Thanks
Ron T
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
