Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DB2 UNLOAD With WHEN clause

69 views
Skip to first unread message

sri

unread,
Oct 2, 2009, 7:32:26 PM10/2/09
to
Hello

I tried to unload from a table or tabspace using BMC or IBM both are
not working with ROWID.
I wanted to have that tableapce with shrlevel change
//UNLOAD EXEC DSNUPROC,UID='IBMULLOB',UTPROC='',SYSTEM='DXXA'
//STEPLIB DD DISP=SHR,
// DSN='DSNDXXA.SDSNEXIT'
// DD DISP=SHR,
// DSN='DSNDXXAX.SDSNLOAD'
// DD DISP=SHR,
// DSN='DSNDXXA.LOADLIB'
//SYSPUNCH DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSREC DD DUMMY
//SYSIN DD *
UNLOAD TABLESPACE DBNAME.TSNAME SHRLEVEL CHANGE ISOLATION UR
FROM TABLE XAAA.ENTRP_XML_TRNSL
WHEN (EORG_ROWID <>
ROWID(X'C85E68A15072364429040179FFC00100010000000202'))

Any one knows why pgm dsnutilb does not support rowid.
getting message

DSNU082I DSNUGPRW - INVALID KEYWORD -
X'C85E68A15072364429040179FFC0010001000
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN
CODE=8

Thanks
Ravi

0 new messages