how to base 64 (Base64) an ASCII string

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
marshie68
Participant
Posts: 4
Joined: Mon Jul 13, 2009 11:07 pm

how to base 64 (Base64) an ASCII string

Post by marshie68 »

I have an ASCII string which is an encrypted credit card number and it has many non-printable characters in it.

This string causes issues with our flat file interface file as you can imagine.

I want to perform a base 64 on this ASCII string so I can get the ASCII hex representation of this encrypted value.
Thanks
Marshall
IBM Australia
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

How "bad" would it be to put a BASIC transform stage in your parallel job or do this particular job as a server one? The function "OCONV(In.BinaryCCNumber,'MX0C')" does this for you, but doesn't exist in PX jobs.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

for future needs

Post by roy »

I've posted a Base64Decode executable export file in the FAQ forum
Hoping it will help someone in the future
Click here for the post
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply