473,396 Members | 1,924 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

zos - exec sql - load

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
1 5017
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: j vickroy | last post by:
Could someone help me understand the following Python 2.3 error message: SyntaxError: unqualified exec is not allowed in function 'load' it contains a nested function with free variables in...
1
by: Adonis | last post by:
I wrote a small webserver and a small html parser to parse some elements, in which contain python code, now before I go any further your thinking "not another web application server" and before...
1
by: Andr? Roberge | last post by:
I have the following two files: #--testexec.py-- def exec_code(co): try: exec co except: print "error" #-- test.py--
0
by: Jan | last post by:
I store sql-commands in a database table. In the first step I get the sql command out of the database table with embedded sql. In the second step I try to execute the command, which i got from the...
1
by: john | last post by:
I am trying to set up a shtml page that will take 10 seconds for it to load to slow down some annoying spiders I have on my website. The shtml looks like below: <html> <head> <title>You are...
0
by: boomertoo55 | last post by:
Trying to exec DTS task involving load of MS Access table to SQL Server 2000 table using Data Pump task via remote exec of xp_cmdshell command of dtsrun. That is, on client, connect to database...
2
by: DragSta | last post by:
Hello everyone, im slowly learning PHP and im strarting to kinda get the hang of the basics. Basically, i am making a control panel for a Game Server, that can start and stop the server by running...
2
by: Danny Shevitz | last post by:
Howdy, In my app I need to exec user text that defines a function. I want this function to unpickle an object. Pickle breaks because it is looking for the object definition that isn't in the...
3
by: Shayco | last post by:
hey, in my code i'm using Runtime.getRuntime().exec() in order to run a .bat file that calls another java program (they communicate with each other using RMI). when i call: Process process =...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.