View previous topic :: View next topic
|
Author |
Message |
noorkh
New User
Joined: 06 Mar 2006 Posts: 76 Location: Chennai
|
|
|
|
Hi,
I would like to pass VALUE of a field through parametre by submitting jCL. Is that possible?
I am running simple insert query through JCL with insert SQL as below:
INSERT INTO TABLE
VALUES ( &PARM1, &PARM2, 123);
Is that possible for me to pass &PARM1, &PARM2 through jcl in stead of hard coding values? |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
JCL doesn't do SQL
you missed a step between JCL and SQL : JCL => program or utility => SQL |
|
Back to top |
|
|
noorkh
New User
Joined: 06 Mar 2006 Posts: 76 Location: Chennai
|
|
|
|
GuyC,
I mean JCL utility DB2 utility like DB2CPROC or any BMC utility to run SQL queries through data set.
In that case can i mention & in my sql values and pass those values through jcl. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you create your insert statement with the values resolved in a pds member and then reference this in the batch sql process. |
|
Back to top |
|
|
|