View previous topic :: View next topic
|
Author |
Message |
saideepu
New User
Joined: 30 Jan 2013 Posts: 9 Location: india
|
|
|
|
HI,
i want to unload data from table using JCL with dynamic input values,so i tried like below but am facing problem(INVALID OPERAND '' FOR KEYWORD 'ID'),if any one know please suggest me.
//JOB123U JOB (ACCT),'UNLOAD',CLASS=A,MSGCLASS=A,NOTIFY=&SYSUID
// SET MINVAL=0
// SET MAXVAL=5000
****
//SYSIN DD *
UNLOAD DATA FROM TABLE SIMOTIME.DATA.SUB998D1
(
ID INTEGER EXTERNAL,
ATSN,
)
WHEN (ATSN <> '' AND ID >= &MINVAL AND ID <= &MAXVAL)
Thanks |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Well, your keyword ID is not a JCL keyword - it is in your program control cards but you do not mention which program you are using. Probably something to do with DB2? In which case probably posting in DB2 would be a better idea in future. |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
Incidentally, Deepa-chan, you should be aware that JCL and control cards blindly copied from Simotime will almost certainly not work on your machine. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
JCL Symbol Substitution is not done for data cards. You'll need to pre-process your JCL and cards and then SUBmit the output., or kick into the INTRDR (if you are able) depending on how you do your own substitution. |
|
Back to top |
|
|
|