IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Error while running the DB2 query using JCL


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ashok_uddaraju

New User


Joined: 21 Feb 2007
Posts: 72
Location: US

PostPosted: Tue Mar 01, 2011 7:01 pm
Reply with quote

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
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania

PostPosted: Tue Mar 01, 2011 7:15 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Tue Mar 01, 2011 7:18 pm
Reply with quote

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
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania

PostPosted: Tue Mar 01, 2011 7:22 pm
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Mar 01, 2011 7:34 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Mar 01, 2011 9:07 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Running REXX through JOB CLIST & REXX 13
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts RC query -Time column CA Products 3
Search our Forums:

Back to Top