DSXchange

Ho can i can overcome the ora-155 error while updating the database. should i reduce the number of rows to be comitted after the update? please help. Is it possible to do from datastage side, or it should be done on the database level?

thanks in advance

UPDATE SR_SALES_NOC SET DSO_CIRCUIT_ID_1 = ORCHESTRATE.DSO_CIRCUIT_ID_1, DSO_CIRCUIT_ID_2 = ORCHESTRATE.DSO_CIRCUIT_ID_2, DSO_CIRCUIT_ID_3 = ORCHESTRATE.DSO_CIRCUIT_ID_3, DSO_CIRCUIT_ID_4 = ORCHESTRATE.DSO_CIRCUIT_ID_4 WHERE (SR_ID = ORCHESTRATE.SR_ID) this is the update sequel iam using, if the sr_...

sometimes in the tables, the key column has duplicates, and when updating the first value is getting updated and second(duplicate ) is not getting updated.

ho can i update a column without using a key column in the oracle stage. for example there are around 150 columns in my table and i want to to transform only one column and update the table. i have no primary key column in the table to use the update mode in the oracle stage. what is the the best wa...

the issue is resolved. only thing i did is i rebooted the server. i dont what happened to it. thanks for your advice.

there is no NLS applied to parallel jobs in our datastage server....all i have till now is only for server jobs. All these days iam doing parallel jobs and iam always getting the warning : main_program: An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU ...

i have created many jobs with the same database lastweek and i dont have anyproblem. Only difference is iam pulling data from different schemas.

these are the warnings iam getting. I have searched for this already on dsxchange, but i hardly found 10 posts for it and neither one i helping. iam using oracle stage as input and output. iam updating the same table at the o/p which is at the i/p and also tried writing to a file at the o/p, but sti...

I have informix file definitions in a text file. Is there a way to import it into the datastage. I have tried it but it is not working

the key is 'decimal' filed when i see in the table definitions which i imported from database. But when i load the columns in the oracle stage it is becoming as integer. Why is it happpeing? will it cause problems for update?

Is it Ok if only the key matches........or it should be all the columns to be updated should match?

the key is an integer...but i have changed it to varchar. Will it not work like that?

when i load the columns in the oracle stage, all the varchar columns are showing as length 19...but that should not be the case. why it is happening like this annd how i can get rid of that unicode field.

iam using the oracle stage. the sql code is -1400. i dont know what it is. the rejected values are exactly what i needed to update...but it is rejecting.

workphone is transformed to another value and should overwrite the original value with the transformed onw with the same job.