View previous topic :: View next topic
|
Author |
Message |
naveensrimf
New User
Joined: 04 Oct 2005 Posts: 34
|
|
|
|
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 |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|