shekar123 Advanced
Joined: 22 Jul 2005 Posts: 528 Topics: 90 Location: Bangalore India
|
Posted: Tue Oct 25, 2005 3:23 pm Post subject: unable to LOAD data into db2 table |
|
|
Hi,
I am trying to load data into a db2 table and my jcl looks like this :
//LOAD EXEC DSNUPROC,SYSTEM=DSN,UID='',UTPROC=''
//STEPLIB DD DSN=DB2DBA.DB2.SDSNLOAD,DISP=SHR
//DSNUPROC.SYSPRINT DD SYSOUT=*
//DSNUPROC.UTPRINT DD SYSOUT=*
//DSNUPROC.SYSREC DD DSN=TECH022.DB2.LOADDATA,DISP=SHR
//DSNUPROC.SORTWK01 DD DSN=TECH022.SORTWK01,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(TRK,(1,1),,,ROUND),
// UNIT=SYSDA
//DSNUPROC.SORTWK02 DD DSN=TECH022.SORTWK02,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(TRK,(1,1),,,ROUND),
// UNIT=SYSDA
//DSNUPROC.SORTWK03 DD DSN=TECH022.SORTWK03,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(TRK,(1,1),,,ROUND),
// UNIT=SYSDA
//DSNUPROC.SORTWK04 DD DSN=TECH022.SORTWK04,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(TRK,(1,1),,,ROUND),
// UNIT=SYSDA
//DSNUPROC.SYSUT1 DD DSN=TECH022.SYSUT1,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(TRK,(1,1),,,ROUND),
// UNIT=SYSDA
//DSNUPROC.SORTOUT DD DSN=TECH022.SORTOUT,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(TRK,(1,1),,,ROUND),
// UNIT=SYSDA
//DSNUPROC.SYSERR DD DSN=TECH022.SYSERR,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(TRK,(1,1),,,ROUND),
// UNIT=SYSDA
//DSNUPROC.SYSMAP DD DSN=TECH022.SYSMAP,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(TRK,(1,1),,,ROUND),
// UNIT=SYSDA
//SYSTSPRT DD SYSOUT=*
//DSNUPROC.SYSIN DD *
LOAD DATA INDDN SYSREC
RESUME NO REPLACE LOG NO
INTO TECH022.EMP
(
EMPNO POSITION( 1) CHAR (06),
EMPNAME POSITION( 7) VARCHAR (12),
go-away-spammer-sucker POSITION( 19) CHAR (01),
BIRTHDATE POSITION( 20) DATE )
)
/*
//
I am unable to perform LOAD operation failing with RC =8 and i get this message
UNBALANCED PARENS IN CONTROL STATEMENT
I am not able to figure out any information from this .Can anyone please correct me where i am wrong ? |
|