DSXchange

To get list of tables, you need to access your system tables. But you need not write it.

Did you search this forum for julian and iconv?

Try that and if you find any difficulty, do let us know.

You can use link-partitioner. But that will not be the best solution. As mentioned before, you are better-off using a transformer with 2 output links and constraints to dirvert the traffic.

No. You get CDC as an add-on in earlier versions.

Are there only 2 values?

Is it a user-defined SQL. Check the data type of second column in the link.

You can convert your date into DataStage internal date and add (or subtract) the difference between julian and datastage date.

How did you verify that the dsenv entries were not set?

You can use universe stage.

But can you explain your logic a bit more as what you wish to achieve.

By permissions, I meant that of the library and corresponding objects within DataStage and not in Oracle.

Did you try to run as a root user or something similar?

You can reinstall the plugin and retry.

One option is to remove few columns from the target load and rerun the job. I assume it is some datatype of load problem into the target.

you need to isolate to the columns that cause the error by process of elimination.

The contenders could be your date or numeric values.

By-the-way, did you check the read-speed of the source as a separate entity? Also check whether writing into the target has any difficulty.

Also check whether you have any constraints on the rows that restricts the flow.

Try writing a simple job that will pass a constant and reference it from the hash file. This will confirm the working of your lookup. Next is to write a sequential file in your job linked to the central transformer. Have the source column linked to lookup as a new column in the output. This will ver...

What is the stage on which the 'abnormal termination' is reported?

Before loading to memory, make sure that you are not writing into the file in the same job.

Secondly, try using hash-file calculator to identify the best spread and creation options. You can try to create a static hash-file.

Also delete the old one and recreate it if you can.