You might also want to post this on the DB2 List. If you have not joined, you can do so at IDUG.ORG
Lizette > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > On Behalf Of Ron Thomas > Sent: Monday, February 23, 2015 6:55 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Unload DB2 table in CSV format > > 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 lists...@listserv.ua.edu with the message: INFO IBM-MAIN
