I want execute a select (db2) in a JCL.
I'm using PGM=IKJEFT01 and i'm running program DSNTEP2. The result of my query is in a file toto.db2.result
All is OK but in my file i can see in the first line the query and in the others lines i see the result with border and number for each row.
I would like see only the result of my query, without the query and the borders...
Can you help me?
here is the code:
//TAB500D EXEC PGM=IKJEFT01,DYNAMNBR=20
//STEPLIB DD DSN=DDA1LIB.SDSNLOAD,DISP=SHR
//SYSPRINT DD DISP=(MOD,CATLG),SPACE=(CYL,(9,9)),
//SYSTSPRT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP71)
//SYSIN DD *
SELECT B.CLIENT, B.DBD
FROM NNDBD.DBEURO_CLIDBD_DEV A
RIGHT OUTER JOIN NNDBD.DEU02_CLIDBD_DEV B
ON CODE = CLIENT AND B.DBD = A.DBD
WHERE A.DBD IS NULL
GROUP BY B.CLIENT, B.DBD;