View previous topic :: View next topic
|
Author |
Message |
dp33770
New User
Joined: 04 Jul 2007 Posts: 91 Location: Hyderabad
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Loading what into where ? |
|
Back to top |
|
|
dp33770
New User
Joined: 04 Jul 2007 Posts: 91 Location: Hyderabad
|
|
|
|
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 |
|
|
Pedro
Global Moderator
Joined: 01 Sep 2006 Posts: 2546 Location: Silicon Valley
|
|
|
|
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 |
|
|
dp33770
New User
Joined: 04 Jul 2007 Posts: 91 Location: Hyderabad
|
|
|
|
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 |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007 Posts: 1287 Location: Chennai, India
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
dp33770
New User
Joined: 04 Jul 2007 Posts: 91 Location: Hyderabad
|
|
|
|
ok ... thanks all |
|
Back to top |
|
|
|