Db2 Connector Stage
Posted: Tue Aug 07, 2012 9:46 am
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 ?
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 ?