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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DB2/Excel
- Thread starter ann26ar
- Start date
BrianTyler
IS-IT--Management
The simplest approach is to export the data to a comma-seperated file and then use eithr LOAD or IMPORT to populate DB2
- Thread starter
- #3
BrianTyler
IS-IT--Management
IMPORT FROM filename OF DEL
INSERT INTO tablename ( col1,
col2,
col3,
col4,
col5);
COMMIT;
This 'script' can be run from the DB2 command line
(or a terminal window etc).
The keyword DEL means a comma seperated file.
INSERT INTO tablename ( col1,
col2,
col3,
col4,
col5);
COMMIT;
This 'script' can be run from the DB2 command line
(or a terminal window etc).
The keyword DEL means a comma seperated file.
- Status
Similar threads
- Locked
- Question