DSXchange

Dear Mr. Saundattikar, lets perhaps start by what you finaly want and not by the way you do it. You are standing on one side of the river and ask us what is the best boat to cross the river and we are sugesting boat. Why don't you want to use the bridge. So tell me what you finaly want as result and...

Theoreticly it can be done but you have to have a very deep internal knowledge of what you do. The best way to reach what you want to reach is: Write sequences or (if you prefer it the unix way) shell scripts for to start the DataStage-Jobs. There you can feed any parameter at runtime which you want...

which tool do you want to use for that?

(a) director
(b) manager
(c) Designer
(d) Administrator
(e) command-line

Each of this tools has another way.

Instead of greatly programming you can put the Hash instead of different rows into an array Lookup the array and then opening the array and proceed in the next step.

This is easy and quick.

why do you make things so complicate.

With an iconv you get any date into an integer (0= 31.12.1967) and if you calculate the one integer minus the other you get the difference in days.

Welcome, there are several ways to do that depending on the kind of sourcefile.

for example Pivot-Stage or Hash Table or or or ....

Start searching in the Forum and if you don't find an answer to your problem, please let us know

Change your first post with the actual spelling, please.

Check your spelling

NewData and NEW_DATA is not the same

Try to save job under a new Name maybe that thereafter it might be okay.

Why do you need to solve your problem the way INFORMATICA does?

Why do you worry if you have a solution which solves your problem?

Be happy and don't worry!

And if you don't believe that this solves your problem give me a scenario!

If you have only one or a few dates it may be wise to put the one date into a non-key-field (or the few dates as array into a non-keyfield) and make the compare in the next step.

Shiva,

if you fill your data into a hash-File with eno or/and ename as key, then the hash file does what you want withouth any update, because always the last wins.

That is a standard-Feature of a hash-file, in your case fine for you.

Before you start any design you have to analyze what you want.

Sometimes a Sort may help for not need to have a permanent commit.

For to use a Hashfile with commit use an Universe Stage and set commit to 1.

But what is best for your job can only be said when we know more about it.

The problem is easy to solve and the question is already often asked. So simply query here and you will find the answer.

We haven't yet fixed if the Meeting of the DataStage Veterans will be in FFM, CGN or ZRH. What Georg said so far is to wait for the end of Carneval and to make the meeting in the beginning of March. John is actually having a lot of training sessions and Georg is pretty much involved in Carneval. We ...