Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
Sridhar Sivakoti
- Participant
- Posts: 35
- Joined: Tue Feb 13, 2007 5:30 am
Post
by Sridhar Sivakoti »
Hi,
I want to implement a query(A), Before this query(A) I want to implement another query(B) and After query(A), I want to implement one more query(C).
In simple, like MSOLEDB stage(it consists Before and After tabs), I want to implement above logic in ODBC stage.
Please suggest me.
Regards
Sridhar
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
Three jobs in a job sequence. Job1 executes query A and has two triggers to Job2 (which executes query B) and to Job3 (which executes query C).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
DSguru2B
- Charter Member
- Posts: 6854
- Joined: Wed Feb 09, 2005 3:44 pm
- Location: Houston, TX
Post
by DSguru2B »
You can also use the OPEN and CLOSE commands in the enterprise stage. These properties are present under 'Options'.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
baigdw
- Participant
- Posts: 15
- Joined: Tue Jan 31, 2006 3:56 pm
Post
by baigdw »
Just a thought .. Can't we use a custom sql with seperators for the 3 queries to be executed one after the other.
Baig
Nothing is Impossible in this world. TRY ..try till you Succeed.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
Try it. Let us know.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.