Passing data..jcl 2 Db2



Passing data..jcl 2 Db2

Postby Naagju » Thu Mar 10, 2011 8:26 pm

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.
Naagju
 
Posts: 16
Joined: Tue Feb 22, 2011 10:45 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Passing data..jcl 2 Db2

 

Re: Passing data..jcl 2 Db2

Postby MrH » Thu Mar 10, 2011 8:31 pm

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.
MrH
 

Re: Passing data..jcl 2 Db2

Postby NicC » Thu Mar 10, 2011 10:08 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Passing data..jcl 2 Db2

Postby sunny raj » Thu Mar 24, 2011 5:55 pm

ya jcl will submit the jobs to OS..what u said was wright..
sunny raj
 
Posts: 1
Joined: Thu Mar 24, 2011 5:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Passing data..jcl 2 Db2

Postby enrico-sorichetti » Thu Mar 24, 2011 9:59 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2636
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 129 times

Re: Passing data..jcl 2 Db2

Postby sinmani » Thu Apr 05, 2012 11:15 am

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.
-----------------------------------------
As long as you think you are a student, you are doing well.
The day you consider yourself as the master of the game..........well
sinmani
 
Posts: 93
Joined: Thu Mar 22, 2012 10:02 am
Has thanked: 14 times
Been thanked: 0 time

Re: Passing data..jcl 2 Db2

Postby Akatsukami » Thu Apr 05, 2012 11:22 pm

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.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1052
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times


Return to Interview Questions

 


  • Related topics
    Replies
    Views
    Last post