pradipta

• Sep 9th, 2005

 

you can use LOAD utility(DSNTIAUL) to load data to DB2 tables.

Azahar

• Dec 15th, 2005

 

Loading a DB2 table can be done by an utility as mentioned above or u can code a program and insert all the records data from a file by dynamic sql commands validating for all the fields.

Eg:

EXEC SQL                      
    INSERT INTO Table1(field1  ,field2  )           
    values (value1 ,value2)

END-EXEC.