DSXchange

And Ray is the Road Runner.

Not here one second and then - with a whoosh and a 'Meep Meep!' - he's here, answered 20 questions and then gone.

I don't believe that expressions are allowed, perhaps in 7.5 (I'll have to take a ride through the docs). I was wondering about a macro, but a quick search in the 7.0.1 docs that we have installed right now didn't turn one up, so I didn't mention it. Mike's right, that would be the easiest way to do...

Which specific version of 7 are you planning on upgrading to? It would help to target any answers you get.

Also note that there is always a list of 'Known Issues' in the readme that ships with the product. If you have the media in hand, check it out.

There's no method that I'm aware of to automatically pass a parent invocation id downstream to child jobs. You could put your code into a routine and then executing that routine (via the Routine Actitivy stage) as one of the first things in your job sequence. Pass out the invocation id as the 'answe...

It's the "stream editor", available on any UNIX box. Try typing "man sed" at the command line and check it out!

Actually, updates on "missing rows" - DMLs that update zero records - are not considered to be an error by Oracle. For that matter, neither are delete statements that delete zero records. Perfectly fine and happy statements that didn't actually accomplish anything. Nothing to reject. So, as noted by...

Oh, well... I've worked with Prime systems in the distant past, and DataStage since 3.1. Close but no cigar.

Actually, I think you need to end up with a filename like: "X:\xxx\Temp Storage\filename.txt" Ken and I had similar suggestions for how to accomplish that. Either way involves a script that executes the 'AT' command and executing the script rather than the command directly. Give one of them a shot.

Don't know exactly for NT, but (under some circumstances) don't pathnames with embedded spaces need to be quoted to work? When you say you 'looked at' sQuote and dQuote, what does that mean? You may be running into the issue where DataStage removes the quotes from commands it is being asked to execu...

So my goal is to automatically delete the instances of JobName.* from Director. Are you implying that DS does NOT have the smarts inbuilt to remove these multi instance entries from the Status view in Director? Wait... so you are not so much worried about the contents of the logs? You are trying to...

I can't see any option in DS to automatically remove these logs. Note that I'm not trying to "purge" the logs but to have the last n days worth of log files deleted without manual intervention. Well, that is a purge... it's just not an Immediate / Clear All Entries type of purge. You can set the jo...

Microseconds.

Two lookups to the same hash file - one with a '1' and the other with a '2'. Then check the results in the proper order.

No, I think all the -8 means is that it is a warning.

I'd start with whatever JOB NAME is logging the message and dig down from there.

I know that Activity.$UserStatus is available in trigger expressions, but it's not available in job parameter expressions in Job Activities. (This is 7.1; I believe expressions are possible in 7.5.) Actually - it is! I do this "all the time". It's just slightly "broken" in the releases you mention ...