DSXchange

Meanwhile please take a look at the job control code generated by compiling the job sequence, particularly the DSSetParam() calls and assignment of the variables whence they get their values, to see if you can determine why the behaviour you are reporting is occurring.

Have you reported this to your official support provider, which is the correct course of action when you believe you've discovered a but in the product? It is then up to them to report it to IBM and to keep you appraised of progress in resolving it.

You could construct the current timestamp in an expression in a job sequence, even the parameter-defining expression itself.

It won't overwrite anything that's not on the installation media (for example jobs). It will "upgrade in place". Always take a backup before upgrading any software.

By "I don't have admin access" do you mean that you do not have the Administrator client installed or that you do not have a login that is credentialled as a DataStage administrator? You can open the Administrator client even though you are not a DataStage administrator, and the Command wi...

Is LEFT JOIN valid syntax under ODBC standards, or is LEFT OUTER JOIN required?

Don't be distracted by "parallel edition" - server jobs will remain server jobs.

It's definitely not a "64-bit" error. These give different errors. Write failed is usually because the key is illegal (contains mark characters or is null) or because the hashed file is internally corrupted.

Did you Search DSXchange?

You can also take IBM's Advanced DataStage (server edition) class, which explains the process in detail.

Through ODBC I don't believe so. You can, however, edit the imported table definition to remove them.

Welcome aboard.

IMPORT the table definition from Oracle, and use it unchanged.

The single approach is immaterial. You are trying to run 15 sets of jobs in parallel (whether from one project or from 15) and don't have the server resources to do so. Experiment and monitor; maybe you have the resources to run two or three simultaneously.

I am sorry, but I could not see your reply in full due to Premium membership constraint. That is easily remedied. Premium membership is not expensive, at less than 30c per day. It is one of the ways that the hosting and bandwidth costs of DataStage are met. How much per day does "official"...

Everyone KNOWS that a DataStage server can deliver an infinite supply of resources, right?

No-one can help you with the scant information you have provided. Are you monitoring your system? Do you know what the metrics of resource usage are (for example %Idle, PF/Sec)?

userasif wrote:Thanks Ray, But i am not Premium member.

That is very easily remedied.