|
View previous topic :: View next topic
|
| Author |
Message |
elansamy
New User
Joined: 07 Dec 2005
Posts: 6
|
|
|
|
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 |
|
 |
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL
|
|
|
|
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 |
|
|
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
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 |
|
|
Ayyappan
New User
Joined: 05 Jul 2005
Posts: 31
Location: India
|
|
|
|
Hi,
Try your JCL after removing the PARM('SQL') parameter.
Thanks.
Ayyappan |
|
| Back to top |
|
|
elansamy
New User
Joined: 07 Dec 2005
Posts: 6
|
|
|
|
| Thansk everyone for your inputs. I removed the PARM('SQL') from the control cards, and it worked. |
|
| Back to top |
|
|
|
|
