Page 1 of 1

Passing data..jcl 2 Db2

PostPosted: Thu Mar 10, 2011 8:26 pm
by Naagju
Hi..

my Question is

how can we pass data from JCL to DB2...without any program..

if possible..wt ll be job structure..

it s asked by interviewer..

Advance appreciation..


Regards!!
Naagju.

Re: Passing data..jcl 2 Db2

PostPosted: Thu Mar 10, 2011 8:31 pm
by MrH
Answer: You can't.

If you run a job with JCL, you're executing a program. In the case of "passing data to DB2," then the program in question would be a DB2 program.

Re: Passing data..jcl 2 Db2

PostPosted: Thu Mar 10, 2011 10:08 pm
by NicC
If it was asked by an interviewer why is this not in the Interview Questions section?

And you need to understand what JCL is/does (and possibly the interviewer needs to do the same!) - JCL just tells the OS what programs to run and in what sequence and what resources those programs need. And also, through condition codes, whether to bypass the execution of a program.

Re: Passing data..jcl 2 Db2

PostPosted: Thu Mar 24, 2011 5:55 pm
by sunny raj
ya jcl will submit the jobs to OS..what u said was wright..

Re: Passing data..jcl 2 Db2

PostPosted: Thu Mar 24, 2011 9:59 pm
by enrico-sorichetti
ya jcl will submit the jobs to OS..what u said was wright..


please use a language understandable by human beings, not some script kiddie SMS nonlanguage

Re: Passing data..jcl 2 Db2

PostPosted: Thu Apr 05, 2012 11:15 am
by sinmani
We can pass data to DB2 using JCL load utilities like DSNUTILB , HP32 etc.

As suggested by others it can be used to run a COBOL - DB2 program as well which updates DB2.

Re: Passing data..jcl 2 Db2

PostPosted: Thu Apr 05, 2012 11:22 pm
by Akatsukami
naagju wrote:how can we pass data from JCL to DB2...without any program.

sinmani wrote:We can pass data to DB2 using JCL load utilities like DSNUTILB , HP32 etc.

IOW, it is as MrH and NicC said; it can't be done without executing a program.