DSXchange

Hi All,

when i modify the user defined query either to change the where clause or the selected fields the query is still not taking in the changes and some how it using the old query ...
it is weird...

please advice...

Appreciate your time and help.

you need to give a bit more info than this, like what is your actual query and what are the modifications you are doing ? Let us know.

sure i would..

in one of oraci stage i added a column and also modified the user def.query according and compiled.

In another one i changed the where condition in the user defined query
and recompiled.

In another one i dropped a column from the column list aswell as from the user defined query and save and compiled still the changes are not relflected .


Thanks all once again.

In all the 3 statements I see you compiled it but did you re-run the job after compilation ? Or you just compiled them?

of course the was rerun , that is iam saying the changes are not reflecting.

Thank you,

It is wierd.
Delete the Ora OCI stage, add a new one and try it again. Do you get the same problem again?

that is the last i should be trying...
Thanks Narsimha.

Did you recompile the job after changing the user-defined SQL?