Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to load flat files in DB2 tables?
- Thread starter viperrt10
- Start date
gregsimpson
Programmer
- Apr 18, 2002
- 521
See if you have the BMC utilities installed on your box.
Hi There
Db2 has tools to import and export to flat file in several formats.
Db2 import from d:\temp.del of del insert into table1
The other format is ixf.
There is also a load function which is much faster than an import as it doesn't log so for big files use load but it might put you tablespace into backup pending mode so you will have to do a backup afterwards.
Hope this helps
Db2 has tools to import and export to flat file in several formats.
Db2 import from d:\temp.del of del insert into table1
The other format is ixf.
There is also a load function which is much faster than an import as it doesn't log so for big files use load but it might put you tablespace into backup pending mode so you will have to do a backup afterwards.
Hope this helps
I know DB2 on IBM mainframe has a load utility called DB2LOAD (or something like that) which takes flat csv files and puts them straight into tables. You just need to remember to format the individual values correctly for the insert e.g. strings in 'quotes' etc.
- Status
Similar threads
- Locked
- Question