user defined query

kollurianu · Post by **kollurianu** » Tue Feb 27, 2007 10:48 am

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.

urshit_1983 · Post by **urshit_1983** » Tue Feb 27, 2007 11:08 am

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.

kollurianu · Post by **kollurianu** » Tue Feb 27, 2007 11:48 am

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.

urshit_1983 · Post by **urshit_1983** » Tue Feb 27, 2007 11:54 am

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

kollurianu · Post by **kollurianu** » Tue Feb 27, 2007 11:59 am

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

Thank you,

narasimha · Post by **narasimha** » Tue Feb 27, 2007 12:01 pm

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

kollurianu · Post by **kollurianu** » Tue Feb 27, 2007 12:11 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Feb 27, 2007 3:23 pm

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