Mike 1304
New User
Joined: 15 Oct 2011 Posts: 46 Location: Germany
|
|
|
|
My fault was to copy an example from IBM manual.
It was not the right one to use with SELECT.
Code: |
//UNLOAD EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB91) -
LIB('DSN910.RUNLIB.LOAD')
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSREC00 DD DSN=DSN8UNLD.SYSREC00,
// UNIT=SYSDA,SPACE=(32760,(1000,500)),DISP=(,CATLG),
// VOL=SER=SCR03
//SYSPUNCH DD DSN=DSN8UNLD.SYSPUNCH,
// UNIT=SYSDA,SPACE=(800,(15,15)),DISP=(,CATLG),
// VOL=SER=SCR03,RECFM=FB,LRECL=120,BLKSIZE=1200
//SYSIN DD *DSN8910
.PROJ WHERE DEPTNO='D01' |
Now I changed to
RUN PROGRAM(DSNTIAUL) PARM('SQL')
and get no error any more (and if an error occurs it is described in SYSPRINT as expected).
Summary:
SPUFI has no feature to produce a CSV file.
But with DSNTIAUL I can produce a file without headings and with delimiters, inserting the delimiters in the SELECT.
So my Question is answered now,
thread could be closed,
many thanks! |
|