vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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. |
| ||||
| 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. |