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
 

 

loading into db2 table thru jcl

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
elansamy

New User


Joined: 07 Dec 2005
Posts: 6

PostPosted: Wed Mar 08, 2006 5:27 pm    Post subject: loading into db2 table thru jcl
Reply with quote

My JCL is like this:

//STEPNAME EXEC PGM=IKJEFT01,DYNAMNBR=1
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM (DB2D)
RUN PROGRAM (DSNTEP2) PLAN(DSNTEP2) -
PARM('SQL') LIB('SYSM.DB2.DB2D.SDSNEXIT')
END
/*
//SYSIN DD DSN=AVE4234.LOADJCL.DATASET,DISP=SHR

Inside the dataset AVE4234.LOADJCL.DATASET I doded the below query.

INSERT INTO NW1YE.TBL_CNTL
(CNTL_ID,CNTL_TMST)
VALUES
('PYEDD341',CURRENT TIMESTAMP);

when i tried to run the job, i am getting the error message:

DSNT499I ERROR IN INPUT PARAMETER LIST

Can anyone help me in fixing this bug?
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Wed Mar 08, 2006 7:02 pm    Post subject: Re: loading into db2 table thru jcl
Reply with quote

Try Jamming your JCL Code... I hope you will get the error...

JEM at command prompt...or !JCK... These are shop specific to check syntax error in a job.

Regards,
Priyesh.
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Wed Mar 08, 2006 7:58 pm    Post subject: Re: loading into db2 table thru jcl
Reply with quote

Did you even attempt to review the error message description:
Quote:

2.15.216 DSNT499I

--------------------------------------------------------------------------------

DSNT499I ERROR IN INPUT PARAMETER LIST


Explanation: The parameter list specified when DSNTIAUL or DSNTEP2 was invoked contains one or more invalid values.
System Action: The application program is terminated.

User Response: Notify the system programmer.

System Programmer Response: Check the parameter values entered when DSNTIAUL or DSNTEP2 was invoked. For DSNTIAUL, the correct parameter value is 'SQL'. This parameter indicates that DSNTIAUL input is in complete SQL statements terminated by a semicolon. For DSNTEP2, the correct parameter values are either 'ALIGN(LHS)', 'ALIGN(MID)', 'MIXED', or 'NOMIXED'. The first two parameter values represent the two output alignment options available in DSNTEP2 where 'ALIGN(LHS)' will align the output on the left margin and 'ALIGN(MID)' will center the output. The remaining two parameter values designate whether or not DSNTEP2 will recognize mixed character data where 'MIXED' means that it will and 'NOMIXED' means that it will not recognize mixed character data.
Back to top
View user's profile Send private message
Ayyappan

New User


Joined: 05 Jul 2005
Posts: 31
Location: India

PostPosted: Wed Mar 08, 2006 9:00 pm    Post subject: Re: loading into db2 table thru jcl
Reply with quote

Hi,

Try your JCL after removing the PARM('SQL') parameter.

Thanks.
Ayyappan
Back to top
View user's profile Send private message
elansamy

New User


Joined: 07 Dec 2005
Posts: 6

PostPosted: Thu Mar 09, 2006 12:38 pm    Post subject: Re: loading into db2 table thru jcl
Reply with quote

Thansk everyone for your inputs. I removed the PARM('SQL') from the control cards, and it worked.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Command UNIQUE CONSTRAINT on any tabl... rohanthengal DB2 2 Thu Aug 18, 2016 3:48 pm
No new posts Updating online Db2 table kishpra DB2 3 Fri Aug 12, 2016 2:44 pm
No new posts Getting soc4 on internal table in cobol abdulrafi COBOL Programming 13 Fri May 06, 2016 3:39 pm


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