Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Error while running the DB2 query using JCL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ashok_uddaraju

New User


Joined: 21 Feb 2007
Posts: 72
Location: bangalore

PostPosted: Tue Mar 01, 2011 7:01 pm    Post subject: Error while running the DB2 query using JCL
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: 662
Location: Pennsylvania

PostPosted: Tue Mar 01, 2011 7:15 pm    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Tue Mar 01, 2011 7:18 pm    Post subject: Reply to: Error while running the DB2 query using JCL
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: 662
Location: Pennsylvania

PostPosted: Tue Mar 01, 2011 7:22 pm    Post subject:
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: 6967
Location: porcelain throne

PostPosted: Tue Mar 01, 2011 7:34 pm    Post subject:
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

Site Director


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

PostPosted: Tue Mar 01, 2011 9:07 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Running an REXX EXEC implicitly sho7hills CLIST & REXX 3 Thu Apr 20, 2017 8:14 am
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us