DSXchange

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.

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".