DSXchange

If you are writing the value to a file, you'll need something to 'read' that file and then make a decision based on what that returns. Typically, that would be an Execute Command stage that does a cat on the file and then your triggers can check the $ReturnValue (I do believe) from the stage to deci...

Sorry, there's no Moderator here. Perhaps some super-user type like Andy will wander along, though.

Bejeebuz, people - stop quoting entire posts just to add a reply.

Use the perfectly lovely Reply to Topic button down there rather than the seemingly more convienent 'Reply with quote'. Save me from having to come in here and clean things up all the time. Please.

First question in my mind is what Update Actions are you using in your target OCI stages? You could also determine if the lookups are a bottleneck by putting an @FALSE contraint in the last transformer for all of the output links so all the prep work is done but nothing is written to the target tabl...

There should be a function that returns the 'day of the week' with zero being Sunday, from what I recall.

Use the Field() function to take the first field from a space delimited string.

... then import.

This 'log clearing', are we talking about CLEAR.FILE or from the Director? What I assume we've been discussing here is the former here and I've never seen corruption that it didn't 'correct'... maybe just got lucky.

Your mistake was going 'under the covers' to delete things, do not do that on your own. While you could do that if you knew what you were doing in earlier versions where there was a single repository, nowadays there are (technically) two and you compounded your original 'out of sync' error by doing ...

Try it without the semicolon. While Toad may like/need it, there are places in DataStage where it doesn't. Not sure this is one, but worth a shot.

Pretty much exactly like you've posted. What have you tried so far? Have you built looping Sequence jobs before or is this your first attempt at them? The checking part should be straight-forward, for a '1' return continue the loop, for a '0' branch outside the loop, bypassing the End Loop stage to ...

The last part of the post explains how the issue was resolved.

... or DBA. And yes, you recall correctly.

You should not use the Sequential File stage in either product to read XML. While it may work, it will not always work. In XML, things like line feeds and carriage returns (etc) are just 'noise' and ignored, they will however affect the Sequential File's ability to read the XML correctly. Best Pract...