Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Explain abt Load utility

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Explain abt Load utility
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    Post subject: Re: Plz explain abt Load utility using Cobol
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: 2504
Location: Atlanta, Georgia, USA

PostPosted: Sat Jan 26, 2008 11:30 pm    Post subject: Plz explain abt Load utility using Cobol
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

Site Director


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

PostPosted: Sun Jan 27, 2008 2:12 am    Post subject:
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    Post subject: Reply to: Plz explain abt Load utility using Cobol
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

Site Director


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

PostPosted: Mon Jan 28, 2008 8:50 am    Post subject:
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    Post subject: Reply to: Plz explain abt Load utility using Cobol
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

Site Director


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

PostPosted: Tue Jan 29, 2008 12:44 am    Post subject:
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    Post subject: Re: Reply to: Plz explain abt Load utility using Cobol
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    Post subject: Reply to: Plz explain abt Load utility using Cobol
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: 2360
Location: Israel

PostPosted: Tue Jan 29, 2008 6:36 pm    Post subject:
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

Site Director


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

PostPosted: Tue Jan 29, 2008 9:01 pm    Post subject:
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    Post subject: Reply to: Explain abt Load utility
Reply with quote

Hi,
Thanq...........
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 Jan 31, 2008 9:02 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us