DB2 Unload with join

zapi2003 · Posted: Tue Dec 06, 2005 6:44 pm

Inside a JCL, how can I do a Join of 2 tables in a unload to a file ? is it possible ?
Like this:
SELECT myTable01.campo1,
myTable01.campo2,
myTable02.campo1,
myTable02.campo2,
from myTable01, myTable02
Thanks, Ezequiel

DavidatK · Posted: Tue Dec 06, 2005 9:12 pm

Hi Zapi2003

Have you actually tried this? I do this all the time without problems.

If you're experiencing problems, give us the exact JCL/SQL you're using.

zapi2003 · Posted: Wed Dec 07, 2005 12:56 am

DavidatK:
Thanks for your answer ! The job is this:

//PASO05 EXEC DSNTIAUL,COND=(4,LT)
//STEPLIB DD DSN=DSN710.RUNLIB.LOAD,DISP=SHR
// DD DSN=DSN710.SDSNLOAD,DISP=SHR
//SYSREC00 DD DSN=CCALD.S.C1BA1058.F051206,UNIT=SYSDA,
// DISP=(NEW,CATLG,DELETE),SPACE=(CYL,(50,285),RLSE),
// DCB=(RECFM=FB,LRECL=34,BLKSIZE=0)
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB71) PARM('SQL') -
LIB('DSN710.RUNLIB.LOAD')
//SYSPUNCH DD DUMMY
//SYSIN DD *
SELECT CLE_COD_CLI_CD,
CUE_COD_CTA_CD,
CUE_COD_EST_CD,
CLE_COD_CPT_PAG_CD,
CLE_COD_SGM_CLI_CD,
CLE_COD_SBG_CLI_CD,
CUE_COD_SGM_CTA_CD,
CUE_COD_SBG_CTA_CD,
CUE_COD_NAT_CTA_CD
FROM ATISUSDA.CCCLTEMT,
ATISUSDA.CCCUENDV;
/*

the error message is the following:

IKJ56644I NO VALID TSO USERID, DEFAULT USER ATTRIBUTES USED
READY
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB71) PARM('SQL') LIB('DSN710.RUNLIB.LOAD
IKJ56712I INVALID KEYWORD, PLAN(DSNTIB71)
IKJ56712I INVALID KEYWORD, PARM('SQL')
READY
END