Posted: Fri Nov 14, 2008 12:24 am Post subject: Multiple files using FileExtender node
Voyager
Joined: 05 Aug 2002 Posts: 79 Location: US
Hi,
I'm using MB 5 with FileExtenderNode. My requirement is to create multiple files (with different names) in the same directory using one input message. I tried setting the FileProxyNode's File Record Threshold and File close timeout to -1 and used the action node in the esql and set it to close. But still the files are getting written to the same file.
I've included the esql I'm using to test:
DECLARE iCount INTEGER 1;
WHILE iCount < 4 DO
CALL CopyEntireMessage();
SET OutputLocalEnvironment.Variables.MBFEProperties.action='close';
SET OutputLocalEnvironment.Variables.MBFEProperties.FileName = 'Test' || CAST(iCount AS CHAR) || '.dat';
SET iCount = iCount + 1;
PROPAGATE;
END WHILE;
RETURN FALSE;
My requirement is that 3 files Test1.dat, Test2.dat and Test3.dat should be created in the output directory with the same content, but one file Test1.dat is getting created with thrice the same content in it.
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