DSXchange

hi,
pls send anwer for the follwing questions

1 .how to refresh the hased files?
2. which will execute first routine or transform?
3.what is the difference between routine and transform?

thanks and regards
raj

Hello Rajima,

(1) .how to refresh the hased files?
Since your DataStage jobs read from and write to Hashed files you take care of refreshing their contents yourself. They are no different in that aspect than other database tables.

(2) which will execute first routine or transform?
Neither - you have to explicitly call both routines and transforms, so whichever one you call first will get executed first.

(3) .what is the difference between routine and transform?
Routines are declared as either Subroutines or Functions; they can contain large amounts of code and complex logic. Transforms are much simpler single-line constructs.

Sigh. Another newbie post that smells like interview questions.

Arnd, I think you've got number two a little wrong. The question is perhaps poorly stated, I'm wondering if they specifically mean if both a routine and a transform have the same name - which one is executed 'first'? First is the wrong word to use.

And there's a little bit more to number three.

Craig - I see what you mean about question number two, I just looked at the question (along with the others) from another angle. At first I thought I would be tongue-in-cheek (hash files are, from time to time, refreshed by the blood of overworked consultants) but then decided a terse answer would suffice.

Yah, I was considering answering the next batch of questions like this completely wrong, just to be a poopie head. If it was one of those Poopie Head Days, that is.

Don't forget Kim's word of the day "serks". As in "newbie question serks".

rajima wrote:hi,
pls send anwer for the follwing questions

1 .how to refresh the hased files?
2. which will execute first routine or transform?
3.what is the difference between routine and transform?

thanks and regards
raj

Can you be a little more specific with the questions? For example, in what context are you refreshing the hashed files? What is it that has made a refresh necessary? As others have noted, "first" is irrelevant: if you invoke a routine then a routine will execute; if you invoke a transform then a transform's definition expression will execute. It's not driven by a clock, it's driven by design.

Tell them Ray man.