Decripting information

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
yaminids
Premium Member
Premium Member
Posts: 387
Joined: Mon Oct 18, 2004 1:04 pm

Decripting information

Post by yaminids »

Hello there,

I am trying to decript some information from my source table, based on an algorithm, and load it ito my taget tables. Can anyone explain to me how to use the decripting algorithm in DataStage.

Thanks in advance.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Very easy.

There is NO decrypting algorithm in DataStage.

You must use whatever functions are available in the source database to perform decryption.

If you must, you can write your algorithm as a build op or in DataStage BASIC as a routine, and invoke that routine from a Transformer or BASIC Transformer stage. This is not guaranteed to work, however. For example, if your encrypted data contains a \000 character, this may be treated by a stage type written in C as "end of string".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply