encrypted Information in DS

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
Pavan_Yelugula
Premium Member
Premium Member
Posts: 133
Joined: Tue Nov 23, 2004 11:24 pm
Location: India

encrypted Information in DS

Post by Pavan_Yelugula »

Hi All
I have a Encrypted field in my source flat file. I need two clarifications regarding the same
1) If i don't want any processing to be done on the field can i just pass the field along from the start to end by using datatype as VARCHAR. Does DS Mess with it( DS not able to parse some values in encrypted field).

2) The field in the source flat file is encrypted by sending the file through IBM's ICSF encryption software . If i want to do some processing on this field. how exactly can i decrypt it and do my processing and how exactly can i encrypt it back. Is there some stage i can use to call this software and do my decryption and encryption.

Any suggestions will be really helpful
Thanks
Pavan
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

1) DataStage will pass the data through unchanged unless you explicitly modify it - so the contents, if encrypted, will remain so.

2) As far as I understand it, ICSF encryption software has numerous user exits, so you need to identify the appropriate routine(s) you need to use and write your own calling code in DataStage
Post Reply