Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

JCL load Utility syntax

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
dp33770

New User


Joined: 04 Jul 2007
Posts: 92
Location: Hyderabad

PostPosted: Wed Sep 17, 2008 9:54 pm    Post subject: JCL load Utility syntax
Reply with quote

I have faced this question in one of my recent interview.
Can anyone briefly describe the syntax and use of LOAD utility in JCL with help of one simple example.
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Sep 17, 2008 9:57 pm    Post subject:
Reply with quote

Loading what into where ?
Back to top
View user's profile Send private message
dp33770

New User


Joined: 04 Jul 2007
Posts: 92
Location: Hyderabad

PostPosted: Wed Sep 17, 2008 10:08 pm    Post subject:
Reply with quote

I am not aware of how LOAD utility works.
But the question was can we perform the below tasks using LOAD utility and if yes then how ?
1.Loading from a Table to a File
2.Loading from a File to a table
Back to top
View user's profile Send private message
Pedro

Senior Member


Joined: 01 Sep 2006
Posts: 2033
Location: Silicon Valley

PostPosted: Wed Sep 17, 2008 10:20 pm    Post subject: Reply to: JCL load Utility
Reply with quote

Sorry, I am not a DB2'er, but the use of 'table' make it sound like a DB2 question.

And I think:
- load is from file to table
- unload is from table to file.

So the question itself was not clear.
Back to top
View user's profile Send private message
dp33770

New User


Joined: 04 Jul 2007
Posts: 92
Location: Hyderabad

PostPosted: Wed Sep 17, 2008 10:24 pm    Post subject:
Reply with quote

In JCL we have something called LOAD Utility . Whats the Use of this utility.
I hope this Utility is used for Load/Unload when huge number of records are involved.
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Thu Sep 18, 2008 10:44 am    Post subject: Reply to: JCL load Utility syntax
Reply with quote

Deep,

Quote:
JCL we have something called LOAD Utility . Whats the Use of this utility.
I hope this Utility is used for Load/Unload when huge number of records are involved.


The name says it all. Load utilility is used to load a table with data and unload utility is for unloading a table into a flat file.

There are many utilities available BMC is one among them.

To know more about this utility

- Refer to DB2 manual
- Search in the DB2 forum with the search keyword as "BMC"
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Sep 18, 2008 7:33 pm    Post subject:
Reply with quote

Hello,

Quote:
- Refer to DB2 manual
- Search in the DB2 forum with the search keyword as "BMC"
Along with these, i would also suggest you search the forum SEARCH with keyword LOAD (and another possibly for UNLOAD).

There are many site-specific tools - BMC is one of them.

Every system has the db2 tools that are part of the product. At the top of the page ia s link to "IBM Manuals". Among them is DB2/UDB Vx Utility Guide for your release of db2. There should be all of the info you need. If you read something that is not clear, post what you read and your question about it.
Back to top
View user's profile Send private message
dp33770

New User


Joined: 04 Jul 2007
Posts: 92
Location: Hyderabad

PostPosted: Thu Sep 18, 2008 7:48 pm    Post subject:
Reply with quote

ok ... thanks all
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
No new posts TAPE VERIFY utility?? MrExtraordinare JCL & VSAM 3 Fri Dec 09, 2016 10:57 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us