By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,885 Members | 1,072 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,885 IT Pros & Developers. It's quick & easy.

zos - exec sql - load

P: n/a
I'm getting this error when I submit the job:

DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = LOADSQL
DSNU005I DSNUGPRS - EXEC SQL
DSNU082I DSNUGPRS - INVALID KEYWORD - EXEC
DSNU005I DSNUGPRS - DECLARE C1 CURSOR FOR SELECT * FROM LIQ53TST.TLS_BRANCH
DSNU005I DSNUGPRS - ENDEXEC
DSNU005I DSNUGPRS - LOAD DATA
DSNU005I DSNUGPRS - INCURSOR(C1)
DSNU005I DSNUGPRS - REPLACE LOG NO
DSNU005I DSNUGPRS - INTO TABLE TEST53.TLS_BRANCH
DSNU005I DSNUGPRS - STATISTICS
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8

It doesn't recognize the keyword EXEC.
I'm definitely using Db2 v7.
Any idea what I am missing?
Thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Are you sure you use DB2 V7.1?
Re-check your JOBLIB or STEPLIB Setting.

The DB2 V7 utility output for a cross loader
job looks something like this:

DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = A979074L
DSNU050I DSNUGUTC - EXEC SQL SET CURRENT SQLID='S100447' ENDEXEC
DSNU1180I DSNUGSQL - SQLCODE = 000, SUCCESSFUL EXECUTION
DSNU050I DSNUGUTC - EXEC SQL DROP TABLESPACE DSNDB04.TSTAB ENDEXEC
DSNU1180I DSNUGSQL - SQLCODE = 000, SUCCESSFUL EXECUTION
DSNU050I DSNUGUTC - EXEC SQL COMMIT ENDEXEC
DSNU1180I DSNUGSQL - SQLCODE = 000, SUCCESSFUL EXECUTION
DSNU050I DSNUGUTC - EXEC SQL CREATE TABLESPACE TSTAB IN DSNDB04 USING STOGR
BUFFERPOOL BP0 ENDEXEC
DSNU1180I DSNUGSQL - SQLCODE = 000, SUCCESSFUL EXECUTION
DSNU050I DSNUGUTC - EXEC SQL CREATE TABLE A979074.SYSTABLES LIKE SYSIBM.SYS
DSNU1180I DSNUGSQL - SQLCODE = 000, SUCCESSFUL EXECUTION
DSNU050I DSNUGUTC - EXEC SQL DECLARE C1 CURSOR FOR SELECT * FROM SYSIBM.SYS
ENDEXEC
DSNU050I DSNUGUTC - LOAD DATA LOG NO REPLACE INCURSOR C1
DSNU650I -DAF3 DSNURWI - INTO TABLE A979074.SYSTABLES STATISTICS TABLE ALL IN
ALL ERRDDN(T#ERR) SORTDEVT DISK WORKDDN(T#SUT1, T#SOUT)
DSNU350I -DAF3 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
DSNU610I -DAF3 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR DSNDB04.TSTAB SUCC
DSNU610I -DAF3 DSNUSUTB - SYSTABLES CATALOG UPDATE FOR A979074.SYSTABLES S
DSNU610I -DAF3 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR A979074.SYSTABLE
DSNU610I -DAF3 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR DSNDB04.TSTAB SUC
DSNU620I -DAF3 DSNURDRT - RUNSTATS CATALOG TIMESTAMP = 2004-04-07-08.23.11.148
DSNU304I -DAF3 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=331 FOR
DSNU302I DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROC
DSNU300I DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:59
DSNU381I -DAF3 DSNUGSRX - TABLESPACE DSNDB04.TSTAB IS IN COPY PENDING
DSNU010I DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4
i am picking the load modules from the linklist, but see no
difference when using a STEPLIB.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.