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
 

 

Sample Cobol-Db2 program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
naveensrimf

New User


Joined: 04 Oct 2005
Posts: 31

PostPosted: Wed Sep 04, 2013 12:02 pm    Post subject: Sample Cobol-Db2 program
Reply with quote

Need a Sample Cobo-DB2 program.

1. Read the input file. Input file have a 10 millions of records.
2. Search each input record into database(Employee Table and Departnment table) by using the Key Employee Location and Departnment number.

Employee location is in Employee Table.
Departnment Number is Department Table.

If records are found fetch all the records from Employee table and Department table by using the filed Employee location and Department Number and write into a output file.

3. Produce the control report input record count and output file record count.

4. Mainly performance should be Good.
Back to top
View user's profile Send private message

Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1534
Location: Andromeda Galaxy

PostPosted: Wed Sep 04, 2013 12:15 pm    Post subject:
Reply with quote

Dear Naveen,

Did you "SEARCH forum or GOOGLE" ??

1. You should be able to do it urself else please read the manual


2.What if the numbers in both the table doesnt match for a record in input file ( You might have thought about that ?? )

3. You should be able to do it urself else please read the manual
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Sep 04, 2013 1:38 pm    Post subject:
Reply with quote

naveensrimf

Please DO NOT ask for sample code without being prepared to pay the going daily rate for the skills required, usually around 750 euro per day.

You also need to show what research you have done, or as it looks in this case, haven't done
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: Wed Sep 04, 2013 7:12 pm    Post subject:
Reply with quote

Hello,

Siggest you consider creating a "load" file and the loading the data in bulk.

Individuakl INSERTs for millions of rows will NOT perform so well.
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 -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Cobol GUI (like Editor) Kala Mainframe COBOL Programming 14 Wed May 10, 2017 12:30 pm
No new posts IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm


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