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.
Passing data..jcl 2 Db2
Re: Passing data..jcl 2 Db2
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.
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.
-
- 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
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.
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
Regards
Nic
Re: Passing data..jcl 2 Db2
ya jcl will submit the jobs to OS..what u said was wright..
-
- 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
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
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
-
- 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
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 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
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
- 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
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
-
- 3
- 6844
-
by socker_dad
View the latest post
Wed May 04, 2022 12:59 am
-
-
eliminate duplicates with different data
by cobol_dev » Fri Jun 03, 2022 3:47 am » in DFSORT/ICETOOL/ICEGENER - 7
- 1875
-
by cobol_dev
View the latest post
Wed Jun 15, 2022 10:44 pm
-
-
- 4
- 3273
-
by socker_dad
View the latest post
Fri Dec 31, 2021 5:28 am
-
-
Copying All Data Off An Old Mainframe
by zunebuggy » Wed Sep 25, 2024 1:10 am » in Mainframe Security - 0
- 1599
-
by zunebuggy
View the latest post
Wed Sep 25, 2024 1:10 am
-
-
- 4
- 2239
-
by sergeyken
View the latest post
Mon Jun 26, 2023 12:56 am