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

Explain abt Load utility


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mvkumar22
Warnings : 1

New User


Joined: 26 Dec 2007
Posts: 8
Location: Chennai

PostPosted: Sat Jan 26, 2008 10:30 pm
Reply with quote

Can anyone please explain to me about Load utility in Cobol with Sample code?

Regards,
Vijay

Note: Please skip to bottom
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Sat Jan 26, 2008 11:13 pm
Reply with quote

mvkumar22 wrote:
Can anyone please explain to me about Load utility in Cobol with Sample code?

Regards,
Vijay


If you are asking about the DB2 Load Utility it doesn't have anything to do with COBOL.
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2501
Location: Atlanta, Georgia, USA

PostPosted: Sat Jan 26, 2008 11:30 pm
Reply with quote

Are you attempting to dynamically LOAD an external module, such as a Static Assembler Table?

If your compiler version/release is COBOL/370 or greater (circa early 1990's), then review PROCEDURE POINTER.

PROCEDURE POINTER can be used as a substitute for a dynamically called Assembler sub-program which issues an MVS LOAD Macro.

However, PROCEDURE POINTER < C A N N O T > be used in CICS. Instead, use the CICS LOAD PROGRAM API.

HTH....

Regards,

Bill
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: Sun Jan 27, 2008 2:12 am
Reply with quote

Hello Vijay,

As you have seen from the replies, your question is not clear.

If you explain what you actually need to do (rather than just mentioning LOAD and COBOL), we should be able to offer suggestions.

Some thoughts (including those above) - DB2 load, vsam load, load an array, load an executable, some other database load. . .

The more info you can provide, the better.
Back to top
View user's profile Send private message
mvkumar22
Warnings : 1

New User


Joined: 26 Dec 2007
Posts: 8
Location: Chennai

PostPosted: Mon Jan 28, 2008 8:48 am
Reply with quote

Hi,
How to load from a flat file to table?

Thanx,
Vijay
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: Mon Jan 28, 2008 8:50 am
Reply with quote

Hello,

If you want to use COBOL to load data from a flat file to a table, write code to read the flat file, format the data apropriately, and INSERT rows into the table from the records read.
Back to top
View user's profile Send private message
rag swain

New User


Joined: 17 Dec 2007
Posts: 33
Location: pune,INDIA

PostPosted: Mon Jan 28, 2008 11:15 pm
Reply with quote

I hope this is regarding loading of table in COBOL not DB2. As Dick, suggests, you have to read the flat file and format/process data according to your need, then put those into tables in a loop using index for that table. But Before all these, don't forget to initialize the table.
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: Tue Jan 29, 2008 12:44 am
Reply with quote

Hello,

Quote:
How to load from a flat file to table?

Yet more clarification needed. . .

Would this be a database table or an in-core table (array) that is part of your program?

Keep in mind that until "most" understand the requirement, it is nearly impossible to offer implementation suggestions/alternatives.
Back to top
View user's profile Send private message
acevedo

Active User


Joined: 11 May 2005
Posts: 344
Location: Spain

PostPosted: Tue Jan 29, 2008 3:37 am
Reply with quote

mvkumar22 wrote:
Hi,
How to load from a flat file to table?

Thanx,
Vijay


the doubt is... what do you mean by table?
a db2 table or an internal cobol table (=occurs)?
Back to top
View user's profile Send private message
mvkumar22
Warnings : 1

New User


Joined: 26 Dec 2007
Posts: 8
Location: Chennai

PostPosted: Tue Jan 29, 2008 6:32 pm
Reply with quote

Hi,
I would like to load data into DB2 table from a flat file using Load utility and not using INSERT. Plz send me sample code for uitility.......

Thanx in Advance
Vijay
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2358
Location: Israel

PostPosted: Tue Jan 29, 2008 6:36 pm
Reply with quote

What's wrong with the fine manual? (Guess what, there are even examples in there...)

O.
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: Tue Jan 29, 2008 9:01 pm
Reply with quote

Hello,

If you had more clearly posted your requirement days ago, you would already have your answer. Mentioning load and COBOL led most of us to believe you were working with COBOL. Now you mention that you don't want to use INSERT.

If you want to use db2's load, there are multiple examples n the DB2 forum.

I'll also move your topic to that forum as you will probably get more and better responses.
Back to top
View user's profile Send private message
mvkumar22
Warnings : 1

New User


Joined: 26 Dec 2007
Posts: 8
Location: Chennai

PostPosted: Thu Jan 31, 2008 11:00 am
Reply with quote

Hi,
Thanq...........
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 Jan 31, 2008 9:02 pm
Reply with quote

You're welcome icon_smile.gif

Have you been able to find an exaple that will work for you?
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 -> DB2

 


Similar Topics
Topic Forum Replies
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 DB2 Statistics - Using EXPLAIN and qu... DB2 1
No new posts ISRSUPC search utility - using high l... TSO/ISPF 2
Search our Forums:

Back to Top