IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

JCL load Utility syntax


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
dp33770

New User


Joined: 04 Jul 2007
Posts: 91
Location: Hyderabad

PostPosted: Wed Sep 17, 2008 9:54 pm
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: 8797
Location: Welsh Wales

PostPosted: Wed Sep 17, 2008 9:57 pm
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: 91
Location: Hyderabad

PostPosted: Wed Sep 17, 2008 10:08 pm
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

Global Moderator


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

PostPosted: Wed Sep 17, 2008 10:20 pm
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: 91
Location: Hyderabad

PostPosted: Wed Sep 17, 2008 10:24 pm
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: 1287
Location: Chennai, India

PostPosted: Thu Sep 18, 2008 10:44 am
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

Moderator Emeritus


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

PostPosted: Thu Sep 18, 2008 7:33 pm
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: 91
Location: Hyderabad

PostPosted: Thu Sep 18, 2008 7:48 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts PARSE Syntax for not fix length word ... JCL & VSAM 7
No new posts Load new table with Old unload - DB2 DB2 6
No new posts How to load to DB2 with column level ... DB2 6
No new posts REASON 00D70014 in load utility DB2 6
No new posts ISRSUPC search utility - using high l... TSO/ISPF 2
Search our Forums:

Back to Top