Can i values be passed as parametre in INSERT through JCL?

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?

GuyC · Posted: Fri Aug 27, 2010 1:25 pm

JCL doesn't do SQL
you missed a step between JCL and SQL : JCL => program or utility => SQL

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.

dick scherrer · Posted: Mon Aug 30, 2010 10:26 am

Hello,

Suggest you create your insert statement with the values resolved in a pds member and then reference this in the batch sql process.