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
 

 

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: 2502
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 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
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


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