Passing data..jcl 2 Db2

Naagju
Posts: 16
Joined: Tue Feb 22, 2011 10:45 pm
Skillset: JCL,COBOL,CICS,VSAM,DB2
Referer: SEARCH

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.

MrH

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.

NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

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

sunny raj
Posts: 1
Joined: Thu Mar 24, 2011 5:44 pm
Skillset: jcl,cobol,db2
Referer: google.com

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

enrico-sorichetti
Global moderator
Posts: 3006
Joined: Fri Apr 18, 2008 11:25 pm
Skillset: tso,rexx,assembler,pl/i,storage,mvs,os/390,z/os,
Referer: www.ibmmainframes.com

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

sinmani
Posts: 93
Joined: Thu Mar 22, 2012 10:02 am
Skillset: COBOL
CICS
JCL
DB2
VSAM
IMS
Referer: INTERNET

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

User avatar
Akatsukami
Global moderator
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Skillset: Rexx, JCL, DB2/SQL, TSO/ISPF, PL/I
Referer: ibmmainframes
Location: Bloomington, IL
Contact:

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


  • Similar Topics
    Replies
    Views
    Last post