DSXchange

Treat the full row as a single column.

Disable inter process comm and retry.

Define the key cols in DataStage using which you can to control the action.

You can use dsjob to call a sequencer which inturn performs the actions you wish.

The action type you selected will work. Ensure that there are records with the same key already present in the db so that new records can act as update.

I do not think we will still be having the same systems in 1000 years from now. So there may not be the requirement to include 10 centuries in the date format.

I think the requirement takes care of that as 2 digits are given for the year

CYYDDD

Simplest will be to create a new project and transfer the codes.

Otherwise you may have to modify VOC entires and needs experience.

Hash files are form of tables.

That depends on your complexity and management.

The simplest way is via DS Admin.

You can achieve it by including @OUTROWNUM in your derivation.

Doh!! Correct proverb.

Give a person a fish and you feed him for today. Teach him fishing and he will feed himself for lifetime.

Need more information and example.

You can do it using job control.

I completely agree with you. As a Chinese proverb goes, Give a person a fish and you feed him for today. Teach him finishing and he will feed himself for lifetime. Also it is good for people who really have the requirement to find the answer than those who only need it for an interview. By-the-way, ...