DSXchange

In other words, the included Designer Client Guide pdf.

As to your question, no, other than to enable the "Include job status in email" option.

No, it's not possible nor would you actually want such a thing... jobs need to stop & loops need to end. What I've done for something like this is to make sure it loops for the vast majority of the day, say 23 hours and 55 minutes. Schedule it to run every day at the same time, that way it gets ...

Nobody "needs" it that way.

Otherwise it's standard things to look at for any load - commit intervals, indexes, array size, etc etc. Nothing is going to beat a native bulk loader, however.

ray.wurlod wrote:Does the comma always appear?

I certainly hope so.

Please choose more meaningful subjects for your posts, one that is actually related to the question being asked. As to your issue, spell out in words - regardless of the tool used - the process of parsing the name and rules for determining if a middle name is present or not. Once you do, how you wou...

I am trying to read XML file using the Sequential file stage. Why? An XML file is not a "sequential" file in the sense that the Sequential File stage understands reliably. Technically they are one long stream of characters with no individual records. Why not use the stage that was meant t...

So... resolved?

Yes, but I'd rather leave the discovery up to you. A simple check of the documentation for the Field() function should answer your question.

Otherwise, perhaps the judicious use of a hashed file would work or perhaps a lookup with multi-row result set enabled. It's hard for me to tell from your example since all of the numbers run sequentially. Those "10 records" you need in your output come from how many input records - 1? 10?...

You can certainly implement the SQL in DataStage.

As I've said before, any reason for this would come from your official support provider. Open a case, get them involved.

Welcome. I know it could be done in the past and I would imagine it should be possible as well in the new 8.x world. The components needed have been discussed here, for example this from an older post: There are two other DLLs that you have to install with your dsjob executable. The Server Job Devel...

To "pass variables in the shell script" doesn't necessarily mean environment variables. Regardless, you'd need to expand on this a wee bit if you want more cogent help. What script? Do you mean pass arguments to a shell script? Leverage environment variables in a shell script? All quite ea...

Or, of course, a Row Generator.