Oracle connector

sheema · Post by **sheema** » Mon Jul 18, 2011 12:49 pm

I am reading from a flat file and loading data into a oracle table.below is my job design in datastage 8.5

Sequential File----->Transformer----------->Oracle Connector

I am trying to commit all the rows at once in oracle connector stage.
In order to do that I have set up the below properties in connector

Transaction
Isolation level Read Committed
record count 0
Array size 1

Still i see that all the records are not being inserted at once.
Can you please help me in this regard.

Rob4732 · Post by **Rob4732** » Mon Jul 18, 2011 1:40 pm

Try write mode = 'Bulk Load'

thx

sheema · Post by **sheema** » Mon Jul 18, 2011 2:02 pm

I am using Write Mode ------Insert, as i would like to insert my own insert statement, so cannot go with Bulk load.

JJayadeep · Post by **JJayadeep** » Wed Jul 20, 2011 4:58 am

You can use the AFTER SQL to commit the data at once that has been inserted into Oracle table

chulett · Post by **chulett** » Wed Jul 20, 2011 7:15 am

After SQL would be too late.

You need to look into the following APT variables:

$APT_ORAUPSERT_COMMIT_TIME_INTERVAL
$APT_ORAUPSERT_COMMIT_ROW_INTERVAL