DSXchange

System(91) is specifically there to answer the Windows/UNIX question.

a) SMP, cluster and grid environments are all supported b) that's true, so what don't you understand? i) no - there is only one kind of job sequence, and it can invoke any mix of server jobs, parallel jobs and other job sequences ii) BASIC Transformer or server job or server job components in server...

The Aggregator stage has a property that allows you to specify that NULL output is permitted.

If the thread is resolved, please add a post that explains what the resolution was.

Search the forum. This technique has been explained in full at least five times.

Tip: You can treat the single character as an integer to get its ASCII code.

Question: what if NLS is enabled?

Get your DBA to trace what is happening. For example, are locks not being released, are indexes being left in an inconsistent state? Use your DB2 documentation to learn what "reason code 1" is. Do you have SELECT as well as INSERT privilege on the table in question? Are you naming the correct table ...

The word you were looking for is "would". Since sysdate - 5 is before sysdate - 1 try reversing the order in the BETWEEN constraint. Also I'm not sure that sysdate is a function. But I'm not in a position to check right now. If it's not, you need to lose the parentheses from it - that is, use SYSDAT...

Char(248) through Char(255) are reserved characters in DataStage; they are the dynamic array delimiter characters. You are wise not to use them for any other purpose in server jobs. Pre-process your source file to replace any character in this range with a suitable equivalent, perhaps from Control S...

Welcome aboard. :D

Parallel jobs do not necessarily abort if a particular stage aborts. This is different from server behaviour. You can create job sequence or after-job subroutine to detect whether any messages with Fatal serverity were logged, and deal with them accordingly.

Thanks for the responses!! I was thinking along the same line. Probably I will have to run them on a more efficient server. I was just wondering whether it had anything to do with improper job design (like too many nested calls, for example Seq calls a sequencer, which then calls another Batch, whi...

The lock tables are almost never the issue here. Don't fiddle with these parameters (nor GSEMNUM, probably the most important of all, which Nagesh failed to mention) unless you know what you are doing. You can render DataStage incapable of starting with unwise selections.

Does this hashed file exist?

If not, you will need to create it using an mkdbfile command or by validating or running a DataStage job in which it appears.

The Hashed File Calculator will generate an appropriate mkdbfile command.

You don't need a workaround - we have given the solution

What's there is there. Click on the Environment... button once in the project properties dialog. However, what you see there are the project default settings. As a general rule it is unwise to set project-wide defaults (except when setting up the project). In all cases you can override these default...