I need to read from a sequential file and insert in a db2 table.
What is better to use in the target "DB2 Bulk Loader" or "DB2/UDB stage"
?
Regards,
Fernando
DB2 Bulk Loader or DB2/UDB stage
Moderators: chulett, rschirm, roy
-
fmartinsferreira
- Participant
- Posts: 142
- Joined: Wed Mar 24, 2004 10:51 am
- Location: Brazil
It depends upon your datasize. Also depends if your dba will be fussy about giving you load permissions. Bulk loader will be much faster. Inserts will be slow. But if data size is small use the API else use the bulk loader.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.