DSXchange

There is a problem with the DataStage SQL Catalog, particularly the UV_USERS file. You are probably registered as a DBA. As a test, please try the following with one of the user IDs that is giving problems (logged in as yourself or dsadm).

A DS macro is an interlude to a DS function so there is no difference between them. DS functions are written in DataStage BASIC.

Parallel routines, however, are written in C++ and therefore can not be invoked through DS macros.

Operator combination is the decision made at run time, when the score is being composed, to execute multiple adjacent operators that share the same parallelism and partitioning specifications into one process rather than using a separate process for each operator. The combined operator is called APT...

Yes, if you're going to try to select it by name from source.

No if you're going to select it as a constant from source or generate its value within the job. But this second approach can not be done in the Oracle stage - it would need to be done on the output of a Transformer stage.

Hmm. I vaguely remember that there was a bug where the DataStage clients would not accept a password longer than eight characters (but was OK with equal to eight). Check with your support provider, or Fix Central, whether there is a patch for your exact DataStage and operating system versions.

Yes, they're in the DataStage Developer's Guide.

Where did you change the password rule, and on what exact operating system and version?

That's the only capability of the FTP stage (which is why I asked about the exact version). It may be that "they" will not allow ordinary FTP due to security requirements. In that case, construct a script (invoked from a job sequence) that performs a secure FTP to a local file on the serve...

My first thought is to suggest "plz" (whatever that is) because you asked us to do that. My second thought is that, if your task was to CONVERT the sql script, then you have not done that - you have merely encapsulated it. Could it be that your requirement is to demonstrate your capability...

What exact version of DataStage are you running? (The answer may already be here on DSXchange - try a search for SFTP.)

In a before-job subroutine you could (for example) echo the header record into the file using the > redirection operator. The job appends detail records to the file. An after-job subroutine appends the trailer to the file, perhaps using echo again, this time with the >> redirection operator.

You're using port # 22, which is usually for SSH, not FTP or SFTP. Check the port number you should be using.

Search DSXchange. There is a recent (current) conversation about UNIX processes that belong to a DataStage job.

The job itself does not exist in UNIX. The job itself is stored in database tables.

1. The Merge stage really implements a "master and updates" model, but can handle differently structured Update links. I imagine it is possible to use different lookup keys on each Update link. However there's no means within the Merge stage for generating a common key - perhaps you could ...

Literally "start problems" as a single line? Or are you summarising? I've never seen "start problems" in a job log entry. If the file in &PH& contains more than two lines, it is copied to the job log as a warning. Therefore you have to figure out what's generating "s...