After Job query in PX
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 136
- Joined: Wed May 07, 2008 11:26 am
- Location: Sydney, Australia
- Contact:
After Job query in PX
hi,
In a load job i read a file and then load it to oracle table using Oracle Enterprise stage. but in the same job i need to update one column of the table after the job finishes. this is same as after job query in server eddition. how can i acieve this in PX.
In a load job i read a file and then load it to oracle table using Oracle Enterprise stage. but in the same job i need to update one column of the table after the job finishes. this is same as after job query in server eddition. how can i acieve this in PX.
Vinay
Hello Vintipa,
In oracle enterprise stage we have options call Open Command and Close Command in stage propertise tab.
in your case you can use Closed Command options and can write the use defined sql query to update the table based on required condition.
In oracle enterprise stage we have options call Open Command and Close Command in stage propertise tab.
in your case you can use Closed Command options and can write the use defined sql query to update the table based on required condition.
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Re: After Job query in PX
Hi
Have a look at this post .... Might help u
viewtopic.php?t=90162&highlight=Sql+in+Oracle+stage
Thanks
Deepti
Have a look at this post .... Might help u
viewtopic.php?t=90162&highlight=Sql+in+Oracle+stage
Thanks
Deepti
-
- Participant
- Posts: 136
- Joined: Wed May 07, 2008 11:26 am
- Location: Sydney, Australia
- Contact:
Hi,
i am trying the close Command option now. i placed the foll query : update erec_pa9028 set ZZRLVLDT = '99991231' where ZZRLVLDT is null
but i get the following error : EREC_9028,2: Fatal Error: Invalid close command : update erec_pa9028 set ZZRLVLDT = '99991231' where ZZRLVLDT is null.
this runs fine in TOAD. may be there are some things to follow when writing a command in close command option!
please throw some light on this.
i am trying the close Command option now. i placed the foll query : update erec_pa9028 set ZZRLVLDT = '99991231' where ZZRLVLDT is null
but i get the following error : EREC_9028,2: Fatal Error: Invalid close command : update erec_pa9028 set ZZRLVLDT = '99991231' where ZZRLVLDT is null.
this runs fine in TOAD. may be there are some things to follow when writing a command in close command option!
please throw some light on this.
Vinay
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am