OCI "Rows per transaction" is being overridden
Posted: Mon Oct 24, 2005 9:15 pm
I have a shared container with two outputs. In one job that uses the shared container, one of the outputs goes straight to an OCI stage. The OCI is set to "Insert Rows Without Clearing", array size=250, rows per transaction=0. I want it to commit regularly, so I change the Rows Per Transaction to 250 (it lets me do this) and hit OKon the Dialog box (saves OK; no error). When I open up the OCI stage again, Rows Per Transaction is back to 0.
I have another job using the same container (one output direct to OCI) and it does the same.
I can output the Shared Container to a Transformer stage and propogate cols through to the OCI (ie. dummy transformer) and the problem is solved. I am concerned that there may be greater problems involving Shared Containers of which I should be aware.
Any ideas what is going on? I cannot find this discussed elsewhere in the forum.
I have another job using the same container (one output direct to OCI) and it does the same.
I can output the Shared Container to a Transformer stage and propogate cols through to the OCI (ie. dummy transformer) and the problem is solved. I am concerned that there may be greater problems involving Shared Containers of which I should be aware.
Any ideas what is going on? I cannot find this discussed elsewhere in the forum.