Design Studio - Rule - VALID GET

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
sbalaji9
Participant
Posts: 2
Joined: Sat Apr 07, 2007 3:36 pm

Design Studio - Rule - VALID GET

Post by sbalaji9 »

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
Posts: 3
Joined: Wed Aug 06, 2014 6:22 am
Location: Cambridgeshire

Post by paul.brett »

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
paul.brett
Participant
Posts: 3
Joined: Wed Aug 06, 2014 6:22 am
Location: Cambridgeshire

Post by paul.brett »

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
Post Reply