급합니당.
db2에도 oralce의 sqlldr이나 ms-sql의 bcp와 같은 기능이 있는지요
자바에서 배치파일을 돌리려고 하거든요.
import 요.
> cat 1.csv a,1 a,1 a,1 a,1 a,1 a,1 a,1 a,1
> cat 1 create table t1(c1 char(5), c2 int);
import from 1.csv of del insert into t1;
> db2 -vtf 1 create table t1(c1 char(5), c2 int) DB20000I The SQL command completed successfully. import from 1.csv of del insert into t1
SQL3110N The utility has completed processing. "8" rows were read from the input file.
SQL3221W ...Begin COMMIT WORK. Input Record Count = "8".
SQL3222W ...COMMIT of any database changes was successful.
SQL3149N "8" rows were processed from the input file. "8" rows were successfully inserted into the table. "0" rows were rejected.
Number of rows read = 8 Number of rows skipped = 0 Number of rows inserted = 8 Number of rows updated = 0 Number of rows rejected = 0 Number of rows committed = 8
> db2 "select * from t1"
C1 C2 ----- ----------- a 1 a 1 a 1 a 1 a 1 a 1 a 1 a 1