Hey everyone,
I am having an issue with SYSTOOLS.BASE64DECODE(and encode fwiw). I am able to run it just fine in Run SQL Scripts, but as soon as I attempt the same code with adding INTO or using SET like I see everyone else, I get SQLState 57017. I've played around with Char/Varchar types and the CCSID(819, 1208, 65535) of the field being assigned the decoded data with no luck.
Any help would be appreciated and potentially stop me from crying myself to sleep each night. I've attached a picture of my script and results from Run SQL Scripts. Here's the current code from my test program.
-Ryan
I am having an issue with SYSTOOLS.BASE64DECODE(and encode fwiw). I am able to run it just fine in Run SQL Scripts, but as soon as I attempt the same code with adding INTO or using SET like I see everyone else, I get SQLState 57017. I've played around with Char/Varchar types and the CCSID(819, 1208, 65535) of the field being assigned the decoded data with no luck.
Any help would be appreciated and potentially stop me from crying myself to sleep each night. I've attached a picture of my script and results from Run SQL Scripts. Here's the current code from my test program.
Code:
DCL-S decoded VarChar(8192) CCSID(819); EXEC SQL SET :decoded = SYSTOOLS.BASE64DECODE('Hello World');
Comment