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



Group memberships:
Premium Members

Joined: 26 Oct 2018
Posts: 3
Location: Tortona
Points: 22

Post Posted: Thu Jul 04, 2019 6:46 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi, i'd like to generate custom info message inside a sequence Job based on certain event. Is it possible somehow?
ecos



Group memberships:
Premium Members

Joined: 26 Oct 2018
Posts: 3
Location: Tortona
Points: 22

Post Posted: Thu Jul 04, 2019 7:11 am Reply with quote    Back to top    

i achieved this by simply using Execute_Command stage.
Thanks anyway
Abed
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: 43085
Location: Denver, CO
Points: 222463

Post Posted: Thu Jul 04, 2019 9:13 am Reply with quote    Back to top    

That was fast. Wink

There may be other ways, would you like to discuss / explore them? If so, we'd need details about the nature of the 'custom info message' (log, email, does the text need to include variables, etc) and what kind of event we're talking about.

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
Not yet rated
ecos



Group memberships:
Premium Members

Joined: 26 Oct 2018
Posts: 3
Location: Tortona
Points: 22

Post Posted: Thu Jul 11, 2019 4:59 am Reply with quote    Back to top    

Hi Craig, thanks for replying. unfortunately the reply notification service was switched off so i didn't receive an email with your reply. I am certainly interested to discuss other ways to do it. I have a Server Job with triggers configured in base of the return value of the job. When the value = x the sequence should stop executing and should show a parametrized log message to notify the user about the reasons.
As i wrote in the previous post, i've used an Execute Command Activity with the following echo command;
echo "THE REFERENCE DATE:#REFERENCE_DATE# IS MISSING IN THE SOURCE TABLE: #SOURCE_TABLE#"
Tell me if you need further details
Thanks again,
Abed
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: 54595
Location: Sydney, Australia
Points: 296053

Post Posted: Sat Jul 13, 2019 8:17 pm Reply with quote    Back to top    

I would use a Routine activity, to log an informational (or warning) message as appropriate. Some are provided (see \Routines\sdk\Utility\UtilityMessageToLog) or adapt it to return 0.

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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: 43085
Location: Denver, CO
Points: 222463

Post Posted: Tue Jul 16, 2019 8:27 am Reply with quote    Back to top    

Right, that would be a primary and the most generic mechanism, something you could pass a string to and all it would do is write it to the job's log using (off the top of my head) the DSLogInfo() ...

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
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