Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 4650
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 Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us