Execution order

[sumesh.abraham]

Hi All,

I've a job which uses a look up, stage variable, a derivation and a constraint. What would be the order of execution for these when the job is run on DataStage Server.

Thanks,
Sumesh

[chulett]

There's a Full Wurlod here on the subject that a search may turn up. Otherwise, I'm going to go with - lookups, stage variables, constraints then derivations.

Do I pass?

[ray.wurlod]

1. before-stage subroutine (if any)
2. stream input
3. reference inputs (in link execution order)
4. stage variables (in order in grid)
5. output links (in link execution order)
....(a) constraint expression
....(b) output column derivations (in order in grid)
6. after-stage subroutine (if any)

[DSguru2B]

Do I pass?

Looking at Ray's reply, I say you pass