DSXchange

This is the current code from the CompareFiles routine. (NOTE: I am no longer using the OPENSEQ to test for existence since the DSExecute() successfully returns a 2 when a file is missing -- at least, when I run via the [Test] button. :? Also, I added an explicit path to the cmd in case that was a f...

If I had a place to do so, I could post images of these results and it would demonstrate these results. :idea: You could upload them to any file sharing site, places like ImageShack and MediaFire (amongst others) are still free AFAIK. Then you can include a link to the images in your post and the s...

OK, without explicit triggers a job sequence will interpret a Routine activity as having failed if its return value is anything other than zero. Add an explicit Failure trigger so that "failures" are handled, even though the trigger goes to exactly the same place as the Success trigger (t...

It may be moot but can you post the full log entry from executing this from (I assume) a Routine Activity stage? And just for grins, what exact O/S and Service Pack are you running? This is Windows 2003 Server SP2, running DS 7.5 Unfortunately, the log doesn't show much. I've included the pertinent...

I was under the impression that what you really wanted was a success/otherwise result from the routine. On that basis I have been recommending returning any other information by other means, so that Ans contains only the success/otherwise value. Oh, then I understand your recommendation and general...

Then use DSLogInfo() to put the result into a log entry, rather than returning it through Ans. If you must return the result, use one of the user system variables (@USER0 through @USER4) rather than Ans. This is really a sidebar from the actual issue but I am curious: Would you explain the reason f...

ray.wurlod wrote:Don't assign the third argument to Ans; assign the fourth argument.

Actually, you can see that I am grabbing both result and cmdout because (for now) I want to see the output as well. Once I am confident that it is working correctly, I will only return the result.

ray.wurlod wrote:If you do use OpenSeq please take the trouble to use CloseSeq. OpenSeq sets a lock on the file which CloseSeq releases.

Oh, correct! Thanks for pointing that out.

ray.wurlod wrote:You don't need to open the files to use FC.

The opens only used for checking whether the files exist --which FC doesn't check for.

But I'll try the other Call to see how it works.

At the least, I appreciate you confirming it doesn't appear to be something simple. :? I'll try the other call. I'm not hopeful given that executing my batch file in a command stage also differs from the results when run at the command-line. BTW: I have read that the FC command isn't always reliable...

Unfortunately, no; it doesn't. In [Test], it dutifully reports: -1 if either of the files are missing 1 if the match fails (the files are different) 0 if the match succeeds (the files are the same) But when I run it in a stage, it is returning: -1 if either of the files are missing 1 if the match fa...

I suspect this is something simple I am just not seeing. :roll: I have a routine I built that compares two files: result = 0 OPENSEQ Filename1 TO FV1 THEN OPENSEQ Filename2 TO FV2 THEN Call DSU.ExecDOS("FC /B ": Filename1 :" ": Filename2, result) END ELSE result = -1 END END ELSE...

An attempt to "telnet <hostname> 2300" failed with the "Could not open connection..." message. I don't think the port is the issue since it is prompting for username/password. I believe that it is only after the port is obtained that it prompts for credentials. It is clearly acce...

I do not see a DSHOME env variable. I have no additional security installed beyond normal Windows stuff. I administer DataStage on this box and do general administration, and I've not made any changes recently that I could associate with this. General maintenance (e.g., monthly OS updates, backup sc...

This message occurs before it even gets to prompting for the project. The Project folders are all still there and if it was a permissions-related thing then logging into the client and trying to access the project wouldn't work. But I can use the clients fine without any issue. This seems to be some...