DSXchange

Your logic looks fine. But consider the question of array size also. You will probably need to unwind the final array because not all its rows were committed. Possibly better logic would be to flag all records into the target with a unique run ID (or last updated timestamp) and do your lookup agains...

Obviously my jobs don't generate quite the same level of waffle as thine!

Learned something new today.

I suspect the limit for Director would be 64KB - it appears to use a rich text control to display the event detail.

That's right; Orchestrate is good, but it doesn't take over from the DBA!

Or InLink.ColName[2,Len(InLink.ColName)-2]

Or Field(InLink.ColName, '"', 2, 1)

Question: which of the three methods is the most efficient?

There is probably a limit in the DataStage Director. However, this would not have any effect upon a script that was either logging or retrieving information from the job log, because the script would not be using Director. There is no actual limit on the size of a logged event apart from the limit o...

What language is that meant to be? You've mixed DataStage BASIC statements with C++ style comments. The former are not available in parallel routines.

The manual is Orchestrate 7.5 Installation and Administration (AdminGuide.pdf). The orchadmin command is documented in Chapter 12.

Alas, the answer is no, as far as I am aware. Therefore Oracle ends up using default buffer sizes, which is sub-optimal.

If the parameter is encrypted you do not need to do anything to it. Just pass it along to the relevant place (such as the Password field in a database stage). In particular, the encryption algorithm is not published so that you can not expect to decrypt it. Naturally with enough effort you could dec...

Hi, I think u wont be able to capture the reject records in Parallel job in transformer. U got to use a server job Completely wrong. The parallel Transformer supports both an Otherwise/Log output (which corresponds to the server Transformer's reject output) and a reject output (which captures any i...

Can you verify that the environment variables are picked up when the job is run? There is a logged event (second in the job run) showing all the environment variables that are used. In the interim, rather than using an echo command you could use a grep command. Call DSExecute("UNIX", &...

So is Director just a client component. They share some DLLs.

Before you even get there, did you try to install 7.5.1 in the same location that you installed 7.0?

Please post the constraint conditions for all outputs. To be passed to the Otherwise/Log output, the row must have failed to meet the constraint conditions for all prior outputs. Verify (using Output Link Execution Order tool) that your Otherwise/Log link is executed last (unless you also have a rej...

The first was my answer to narasimha's immediately prior question.