honeykun
New User
Joined: 16 Apr 2007 Posts: 3 Location: philippines
|
|
|
|
Hi folks,
I am having problems with my JCL that runs a DB2 Reorg with Discard option. Below is the code:
//STEP010 EXEC PGM=DSNUTILB,
// PARM=(TDB2,'REORG'),
// REGION=0M
//STEPLIB DD DISP=SHR,DSN=SYS3.DB2.BMCTOOLS.SY2.LOAD
// DD DISP=SHR,DSN=TDB2.DSNEXIT
// DD DISP=SHR,DSN=TDB2.DSNLOAD
//ABNLIGNR DD DUMMY
//DSSPRINT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
REORG TABLESPACE TSG.TSSAMP
LOG NO
SORTDATA
SORTKEYS
SORTDEVT WORK
SORTNUM 12
COPYDDN (SYSCOPY)
DISCARDDN (SYSDISC)
SHRLEVEL REFERENCE
UNLOAD CONTINUE
DISCARD FROM TABLE TSG.TBSAMP
WHEN TB_DATE < CURRENT_DATE - 2 YEAR
STATISTICS
TABLE (ALL)
INDEX (ALL)
KEYCARD
FREQVAL
NUMCOLS 4
COUNT 10
//*
I tried using
DISCARD FROM TABLE TSG.TBSAMP
WHEN TB_DATE < CURRENT_DATE - 2 YEAR
and
DISCARD FROM TABLE TSG.TBSAMP
WHEN TB_DATE < CURRENT DATE - 2 YEAR
But I am getting an error:
DSNU049I DSNUGPRS - INVALID OPERAND 'CURRENT_DATE' FOR KEYWORD 'FROM'
and
DSNU049I DSNUGPRS - INVALID OPERAND 'CURRENT' FOR KEYWORD 'FROM'
Hope you could help me sort this out! Thanks in advance! |
|