View previous topic :: View next topic
|
Author |
Message |
Mike 1304
New User
Joined: 15 Oct 2011 Posts: 46 Location: Germany
|
|
|
|
SYSPRINT:
Code: |
********************************* TOP OF DATA *****
DSNT490I SAMPLE DATA UNLOAD PROGRAM
******************************** BOTTOM OF DATA *** |
I think you are talking about this output.
It ends after the first record! |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you look in all of the sysout datasets created by the run - including these:
JES2.JESMSGLG
JES2.JESJCL
JES2.JESYSMSG
Also if any sysout data was written to dasd, look at those files as well.
There should be diagnostic info generated |
|
Back to top |
|
|
vinaysetlur
New User
Joined: 04 Jan 2008 Posts: 13 Location: United States
|
|
Back to top |
|
|
Mike 1304
New User
Joined: 15 Oct 2011 Posts: 46 Location: Germany
|
|
|
|
can we try the another way:
Can somebody run a DSNTIAUL with a invalid select statement like SELECT ABC FORM X.Y.Z
and tell me, where he can find a detailed error message?
I think I have a error in the SELECT, but just RC=12 doesn't help me to find it. |
|
Back to top |
|
|
vinaysetlur
New User
Joined: 04 Jan 2008 Posts: 13 Location: United States
|
|
Back to top |
|
|
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! |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Good to hear it is working - thank you for letting us know
d |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
enrico-sorichetti wrote: |
IMNSHO |
I know you had not been honest! |
|
Back to top |
|
|
|