how to generate surrogate key through routine

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
abhishekmuradia
Participant
Posts: 6
Joined: Tue May 23, 2006 10:25 pm
Location: Bangalore

how to generate surrogate key through routine

Post by abhishekmuradia »

I wanted to know how can we call and populate the input files mentioned in the folder stage in a subroutine and also is there a way to generate surrogate key ( each time the subroutine is run we can populate a unique key in the output )
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Use the supplied routines (Routines\SDK\Key Management category). Don't re-invent the wheel!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: how to generate surrogate key through routine

Post by chulett »

As for this:
abhishekmuradia wrote:I wanted to know how can we call and populate the input files mentioned in the folder stage in a subroutine
Sorry, no clue what you mean.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply