Load/Truncate behaviour in DB2
Posted: Fri Oct 17, 2008 4:04 am
I have created a parallel job which loads data from a sequential file to a DB2 table. My Question is regarding "Write method = Truncate" option in target DB2 enterprise stage.
When we use "Write method = Load" and "Write mode = truncate", what happens to the table in DB2 database. Does it execute delete command or does it use truncate command to empty the table before loading new data.
Note : I am using DB2 version 9.1.0.3 and DataStage version is 7.5.2
Thanks
When we use "Write method = Load" and "Write mode = truncate", what happens to the table in DB2 database. Does it execute delete command or does it use truncate command to empty the table before loading new data.
Note : I am using DB2 version 9.1.0.3 and DataStage version is 7.5.2
Thanks