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 "gobbledegook" that looks like this:
"PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiP z4KPHRyYW5zY3JpcHQ"...
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