View previous topic :: View next topic
|
Author |
Message |
Musab Ahmed
New User
Joined: 10 Dec 2012 Posts: 37 Location: India
|
|
|
|
which is better?
Loading a cobol table using a CUSOR in DB2 embedded COBOL programe?
OR
Loading a cobol table by reading a file.
This is a generic question.. So any generic views can be told..
the table has a maximum of 1K - 5K elements. - 1 dimensional with elementary items, not group.. |
|
Back to top |
|
|
TheMFKid
New User
Joined: 20 Nov 2013 Posts: 91 Location: India
|
|
|
|
If the data required resides in DB2 table, then reading DB2 table is better. If the data required resides in file, then reading file is better.. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
First - the duplicate topic has been removed.
When loading a table, it is far more efficient to actually LOAD the table. Reading individual bits of data (wherever they are) and then INSERTing into new rows is most expensive. |
|
Back to top |
|
|
|