|
View previous topic :: View next topic
|
| Author |
Message |
ashok_uddaraju
New User
Joined: 21 Feb 2007
Posts: 72
Location: US
|
|
|
|
Hi,
Here is the JCL which I have been using
| Code: |
//STEP80 EXEC PGM=IKJEFT01
//STEPLIB DD DSN=DB2PRD03.SUBSYS.LOADLIB,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSREC00 DD DSN=ECNS.USER.MANUAL.DATA,DISP=(NEW,CATLG,DELETE),
// SPACE=(CYL,(1,20),RLSE),
// DCB=(DSORG=PS,RECFM=FB,LRECL=80,BLKSIZE=8000)
//SYSTSIN DD *
DSN SYSTEM(ZP03)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB71) PARM('SQL') -
LIB('IRDBTST.DSN710.RUNLIB.LOAD')
END
/*
//SYSTSPRT DD SYSOUT=*
//SYSPUNCH DD DUMMY
//SYSIN DD DSN=ECNS.USER.CACHH.QUERY,DISP=SHR
//* |
My input file has an sql query with 5000 records repeated twice i.e total 10000 records. I had coded a COBOL program to include 6 accounts in single line in an attempt to reduce the number of lines. When I run the above mentioned step it fails with the error message as
DSNT408I SQLCODE = -010, ERROR: THE STRING CONSTANT BEGINNING '442@@@@@@ IS NOT
DSNT418I SQLSTATE = 42603 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHTOKR SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 805 0 0 -1 32762 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000325' X'00000000' X'00000000' X'FFFFFFFF' X'0000
INFORMATION
This error message suggests that the error could be becuase of ' . But when I run the input file manually using SPUFI, the query runs.
So I guess the DB2 error is misleading as the main issue is that the JCL is not able to accommodate this 10000 records data while running the query using the JCL.
Please suggest if me on how to make this JCL run successfully. |
|
| Back to top |
|
 |
daveporcelan
Active Member
Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania
|
|
|
|
This is a branch off of your previous thread.
The last response in that thread told you what to look for.
Moderator, please lock this one. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
| Quote: |
| So I guess the DB2 error is misleading as the main issue is that the JCL is not able to accommodate this 10000 records data while running the query using the JCL. |
Your guess is plain wrong! but ... if You are happy we are happy!
We will not certainly waste time explaining how to read the manuals and follow the manuals' suggestions! |
|
| Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania
|
|
|
|
You say your mainframe skills are 'reading books'
Read the manual for a sql code of -010.
Look in your input file for: 442@@@@@@
Is this a joke or are you for real? |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
1. we have seen this post already, why a second thread?
2. the problem lies in your sql,
WHICH YOU DID NOT BOTHER TO SHOW US
you already received an answer in the othe thread, |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
Which problem now has you "stuck"?
The "fix" for the -010 is given in your other topic.
Even though you have posted the JCL in this new topic (as someone requested in the other topic), you have not posted the error(s) encountered. Why do you believe there is a space problem?
If the space problem happens on thie ddname (SYSREC00) simply allocate more space on the dd statement. . . |
|
| Back to top |
|
|
|
|
