DSXchange

Unless your requirements are more complicated than you've listed, that's as simple as enabling the Include job status in email option in the Notification Activity stage.

Same place you got everything else from - the manual or the online help.

What you need is the numeric value that represents FINFO$TYPE.

There's no need to 'find' the phantom, you've got what you need to know from the log already. However, your -exec syntax should look like this: -exec grep -l "DataStage Job 2288" {} \; The curly braces mark where each found filename should go in the command. Also wanted to add to...

Well, I did give an alternative way to handle it as one job with a 'before job' script. Your approach with the Sequencer is perfectly valid as well, one that skips running the job unless there are rows to process. One thing to keep in mind is that any routine that has a 'non-zero' return will be con...

Yeesh, go home. Is there a upper limit for the T30, for example, if I put the kernels per process open file limit to 2008, does T30 = 2000 makes sense ? There's an upper limit to everything, I would think, but I'm afraid I don't know what that one is. Is it documented in the uvconfig file? (still lo...

You can't use the 'truncate' option if you don't want it to truncate on every run, regardless of how many records are in your source. From what I recall, it truncates the table when the stage starts up and connects to the target, before it starts to process any rows. You could write a small 'before ...

So the in terms of Datastage there was a lot of work going on but in terms of the machine, it was working hard but not 100% loaded (about 80-90% idle and 2G memory free) I'm not sure I'd call 80-90% idle "working hard". Did you mean 10-20% idle? You'll probably need to cut back on the number of job...

That's an... interesting... and rather limiting... directive. I'm not even going to ask why that would be a 'requirement'. What's supposed to happen once they go over the 100MB limit? ps. The BASIC manual states that SYSCOM line only works with "PI/Open flavor accounts". Try removing it and using th...

Ah. Something for the OP to make note of.

You might want to post what you've tried so far. It's just a simple Iconv to get it into a Internal date, subtract 7 from that and then Oconv it back out in the format you want to see it - all doable in one 'line' provided you don't need to do any error checking.

Not only do the Americans generally not understand what NLS actually is but they have very little understanding of foreign characters and even what such things as collation and locales are. [raises hand] Guilty as charged, Your Honor... not having had a need to use it as of yet. Mon ami, I probably...

Interesting. Maybe it's a 7.5.1 thing...

Anyone else have that experience?

What? Don't think so. I've got 7.5 installed on a test machine without NLS and have no such issue.

What makes you say that? Under what circumstances?

Why do you 'need' this? Rather than tell us what you think you need, you're better off explaining what it is you are trying to accomplish. It goes beyond just asking "Is there way to know hash file size (include its directories created by DS) from DS DEsigner or Manager or Director or Administartor ...

Back to the VB approach, eh?

You're better off posting a request like that on some sort of a VB related site, or possibly one for Sql Server. That's really not a DataStage problem, in spite of the fact where you plan to leverage it.

And before you ask - nope, sorry, don't know of any.