Custom Routine in Generating a Sequence Number

[narayana_382]

Hi All,

Please provide me some inputs as how to write a custom routine in generating a sequence number.
This routine can be called from any job in generating a UserID.


Thanks
Naraine.

[us1aslam1us]

Hi Narayan,

I believe you mean 'generating a sequence number' then you can use key management tranforms to generate it.

Thanks
Sam

[ray.wurlod]

Don't re-invent the wheel. there are already routines supplied with DataStage for performing this task. They're part of the SDK, under the Key Management category of the Routines branch.

[narayana_382]

Hi All,

Kindly send me that routine under the Key Managament Category.


Rgds,
Naraine.

[chulett]

Umm... there's no need to send you anything.

Connect to your project with the Manager. Navigate to the Routines / sdk / Key Management category. The routines will be there.

[us1aslam1us]

Hi Narayan,

Please try to read Ascential manuals this will really help.

As far as your routine is concerned as pointed by ray it will be inbuilt routine SDK.If you using it in a transformer.

Got to column derivation>>right clck>>DSTr ansform>>sdk>KeyMgt>>KeyMgtGetNextValue


Thanks
Sam

[narayana_382]

Hi Sam,

Thank you very much for all the valuable inputs.

Please share with me the location of ascential manuals where in I can study through some sample custom routines.

At present I dont have the datastage installed at this location.

Regards,
Naraine.

[ray.wurlod]

Wherever you installed the DataStage client software go there and look in the Docs folder where you will find all the manuals. For example:
C:\Program Files\Ascential\DataStage\Docs