DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
abyss



Group memberships:
Premium Members

Joined: 22 May 2014
Posts: 155

Points: 1615

Post Posted: Thu Aug 24, 2017 4:07 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi,
How can i do selective compile?
I mean, if i have a transform stage, and two identical output link one link to database stage and another link to peek stage.
I want to compile both links in development and only compile one link in test/production.

can someone tell me how to do it? i know it is do able.

thanks
Abyss
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2623
Location: USA
Points: 19433

Post Posted: Thu Aug 24, 2017 6:46 am Reply with quote    Back to top    

Just curious because I have not heard of this before...

How do you know it is doable?

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42163
Location: Denver, CO
Points: 216469

Post Posted: Thu Aug 24, 2017 6:49 am Reply with quote    Back to top    

Yeah, not sure what makes you think you can selectively compile only part of the job. Why don't we start with why you want to do that - is it to "disable" or otherwise not use (I assume) the peek stage target outside of dev?

_________________
-craig

Walked down by the bathing pond to try and catch some sun
Saw at least a hundred schoolgirls sobbing into handkerchiefs as one
Rate this response:  
Not yet rated
abyss



Group memberships:
Premium Members

Joined: 22 May 2014
Posts: 155

Points: 1615

Post Posted: Thu Aug 24, 2017 11:04 pm Reply with quote    Back to top    

sorry guy, i must wrong then...
you let me reconstruct my question:
Craig is right: my question should be: How to disable peek stage (so it doesn't print into log) outside of Dev.
Rate this response:  
Not yet rated
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2623
Location: USA
Points: 19433

Post Posted: Fri Aug 25, 2017 6:26 am Reply with quote    Back to top    

That is a much better question. Smile Unfortunately I am not sure of the best answer. Here is one idea...

You could define it as a standard to set the Peek stage Output Mode to Output, such as to a Sequential File stage rather than to the default setting of Job Log. Then, assuming you have a code review step in your promotion process, someone can verify it is correct before promoting the job past Dev.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42163
Location: Denver, CO
Points: 216469

Post Posted: Fri Aug 25, 2017 6:40 am Reply with quote    Back to top    

Another thought, a job parameter that can be leveraged to "turn it on" in dev and off in other environments. Basically via a filter in the link to the peek stage that either lets everything or nothing through based on the parameter.

_________________
-craig

Walked down by the bathing pond to try and catch some sun
Saw at least a hundred schoolgirls sobbing into handkerchiefs as one
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54007
Location: Sydney, Australia
Points: 293017

Post Posted: Sun Aug 27, 2017 9:30 pm Reply with quote    Back to top    

What you seek to do cannot be done using the compiler alone. Craig's solution - to include job logic - is appropriate. I recall once trying to set the "Rows" property in the Peek stage to 0, ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours