Try using the LOAD utility.
Depending on your platform and DB2 version, the syntax may vary slightly.
E.g., have a look at http://publib.boulder.ibm.com/infoce...e/r0008305.htm
It contains the following example:
where table1 at least has the following columns:
db2 load from ascfile1 of asc
method L (1 20, 21 22, 24 27, 28 31)
null indicators (0,0,23,32)
insert into table1 (col1, col5, col2, col3)
* COL1 CHAR(20) NOT NULL
* COL2 SMALLINT
* COL3 CHAR(4)
* COL5 CHAR(2) NOT NULL
Last edited by Peter.Vanroose; 01-09-06 at 05:19.
__IBM Certified Database Administrator, DB2 9 for z/OS
__IBM Certified Application Developer
__ABIS Training and Consulting