Db2 Connector Stage

[nansekar]

Hello

I have a DB2 connector stage as my target , its a simple Dataset to table load,
and i have the options as
Write mode: BulkLoad
Table Action : Append
Before/AfterSQL: No
Load Control :
LoadMode:Insert
Bulk Load with LOB or XML Columns : Yes
But for each run the table is getting truncated and loaded.

I have tried the other options also, For these options also its getting truncated and load
Write mode: BulkLoad
Table Action : Append
Before/AfterSQL: No
Load Control :
LoadMode:Replace
Bulk Load with LOB or XML Columns : Yes


Does Bulkload option in DB2 connector always Truncates and Load even if table action is Append and Load method is Insert ?

[soumya5891]

Here table action you mentioned as Append. So the new records will be loaded into the table. No truncation will be occurred here.

If you mention table action is truncate then it will truncate the table then load

[nansekar]

Yeah, But for the scenario where table action is append , write mode is Bulk Load and Load mode is replace, performs the similar opertaion as truncate and Load .
Why it happens like this.. what are the advantages of using this method instaed of truncate and load.

[chulett]

If things are working as you are saying, seems to me you should contact your official support provider and ask them the why of that.