64 bit encoding in CLOB

[peteh]

Hi All;
Platform is DB2 LUW (AIX) v8.2.

I have a vendor package that stores chat transcripts in a CLOB column.
When queried, I see "gobbledego ok" that looks like this:
"PD94bWwgdmVyc2 lvbj0iMS4wIiBlb mNvZGluZz0iVVRG LTgiPz4KPHRyYW5 zY3JpcHQ"...
and so on for thousands of characters.

The vendor states that the column is "64bit encoded". Is there a
standard function to "decode" this using column functions? Any help or
similar experience MUCH appreciated.

Pete H

[Mark A]

Re: 64 bit encoding in CLOB

"peteh" <phazzard@intel licare.comwrote in message
news:214e289d-858c-459c-91e9-a7c9c2d7f627@r3 6g2000prf.googl egroups.com...

Hi All;
Platform is DB2 LUW (AIX) v8.2.
>
I have a vendor package that stores chat transcripts in a CLOB column.
When queried, I see "gobbledego ok" that looks like this:
"PD94bWwgdmVyc2 lvbj0iMS4wIiBlb mNvZGluZz0iVVRG LTgiPz4KPHRyYW5 zY3JpcHQ"...
and so on for thousands of characters.
>
The vendor states that the column is "64bit encoded". Is there a
standard function to "decode" this using column functions? Any help or
similar experience MUCH appreciated.
>
Pete H

The encoding is some sort of encryption, either done with DB2 encryption, or
done outside of DB2 (in the application) before the data is inserted. You
need to get more information from the vendor on how to decode it.

[Ian]

Re: 64 bit encoding in CLOB

peteh wrote:

Hi All;
Platform is DB2 LUW (AIX) v8.2.
>
I have a vendor package that stores chat transcripts in a CLOB column.
When queried, I see "gobbledego ok" that looks like this:
"PD94bWwgdmVyc2 lvbj0iMS4wIiBlb mNvZGluZz0iVVRG LTgiPz4KPHRyYW5 zY3JpcHQ"...
and so on for thousands of characters.
>
The vendor states that the column is "64bit encoded". Is there a
standard function to "decode" this using column functions? Any help or
similar experience MUCH appreciated.

My bet is that they mean "base64" encoded, as in a MIME encoding.

http://en.wikipedia.org/wiki/Base64

There are plenty of tools that can decode this (including perl's
MIME::Base64 routines).


But you should confirm with your vendor.

[peteh]

Re: 64 bit encoding in CLOB

On Nov 7, 10:07 am, Ian <ianb...@mobile audio.comwrote:

peteh wrote:

Hi All;
Platform is DB2 LUW (AIX) v8.2.

>

I have a vendor package that stores chat transcripts in a CLOB column.
When queried, I see "gobbledego ok" that looks like this:
"PD94bWwgdmVyc2 lvbj0iMS4wIiBlb mNvZGluZz0iVVRG LTgiPz4KPHRyYW5 zY3JpcHQ"....
and so on for thousands of characters.

>

The vendor states that the column is "64bit encoded". Is there a
standard function to "decode" this using column functions? Any help or
similar experience MUCH appreciated.

>
My bet is that they mean "base64" encoded, as in a MIME encoding.
>

http://en.wikipedia.org/wiki/Base64

>
There are plenty of tools that can decode this (including perl's
MIME::Base64 routines).
>
But you should confirm with your vendor.

Bingo! Exactly what I was looking for. Thanks very much to you and to
Mark.

Pete H