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



Joined: 07 Apr 2007
Posts: 2

Points: 20

Post Posted: Thu Jul 12, 2012 8:27 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: TX
OS: Windows
Additional info: Trying to use GET command with Retry option
Hi, Does anybody knows how to use the GET command in the RULE with Retry option , I am trying to get filename and data in to a variable as below. Due to timing issue the map is failing. I know we can use the Retry command but not sure about the syntax. Would be greatly appreciated somebody can tell me. Thanks.

=VALID(GET("FILE",File1:record derived:834Control),"FILE NOT FOUND"+TEXT(LASTERRORCODE())+LASTERRORMSG())
paul.brett
Participant



Joined: 06 Aug 2014
Posts: 3
Location: Cambridgeshire
Points: 18

Post Posted: Wed Aug 06, 2014 6:36 am Reply with quote    Back to top    

Perhaps try:

=EITHER(GET("FILE",File1:record derived:834Control),GET("FILE",File1:record derived:834Control),GET("FILE",File1:record derived:834Control),"FILE NOT FOUND"+TEXT(LASTERRORCODE())+LASTERRORMSG())

or

=EITHER(GET("FILE",File1:record derived:834Control),GET("BAT","Sleep2.cmd")+GET("FILE",File1:record derived:834Control),GET("BAT","Sleep2.cmd")+GET("FILE",File1:record derived:834Control),"FILE NOT FOUND"+TEXT(LASTERRORCODE())+LASTERRORMSG())

...to introduce a pause between attempts.

Sleep2.cmd contains only the command:

@sleep 2


It seems to work

_________________
Paul Brett
IBM WebSphere Transformation Extender (WTX) Client Support
IBM Software Services, Support and Success
Industry Cloud Solutions
IBM UK
Rate this response:  
Not yet rated
paul.brett
Participant



Joined: 06 Aug 2014
Posts: 3
Location: Cambridgeshire
Points: 18

Post Posted: Wed Aug 06, 2014 6:38 am Reply with quote    Back to top    

Follow my Twitter feed for more hints and tips using IBM WebSphere TX

http://twitter.com/PaulBrettIBM

_________________
Paul Brett
IBM WebSphere Transformation Extender (WTX) Client Support
IBM Software Services, Support and Success
Industry Cloud Solutions
IBM UK
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