Updating Oracle_OCI_9

aakashmalu · Post by **aakashmalu** » Wed Dec 14, 2005 4:45 pm

Hi Friends

I am newbie to DataStage, so please bear with me.
I have a question regarding OracleOCI9.
I am working on a job in which i got to insert or update a table based on different conditions.
When i am doing update i need to add 1 to the count field. I did it by using Hashed file and it works fine,but is there anyother way of doing it.
Its a huge table to be loaded in to Hashed file everyday.

Plz help me folks

thanks

kcbland · Post by **kcbland** » Wed Dec 14, 2005 5:18 pm

Only put into the hashed file the rows necessary for processing on a given run. If your hashed file is coming from small table, just copy the table to the hashed file. But, if the table is huge, use meaningful information (probably from the source data being processing) to inner-join reduce the amount of rows copied to the hashed file for reference purposes.

jenkinsrob · Post by **jenkinsrob** » Wed Dec 14, 2005 5:27 pm

You can use a user-defined update statement in your OCI Stage

Update <Table>
Set <CountField> = <CountField> + 1
Where ....