Skip to content

Instantly share code, notes, and snippets.

@akovac35

akovac35/ExceptionListToCHAR.esql

Last active July 27, 2023 17:15
Show Gist options
  • Save akovac35/033dfe88915e3af8fc42bb70dee2a858 to your computer and use it in GitHub Desktop.
Save akovac35/033dfe88915e3af8fc42bb70dee2a858 to your computer and use it in GitHub Desktop.
Download ZIP
ESQL for converting IIB / App Connect ExceptionList to CHAR
Raw
ExceptionListToCHAR.esql
DECLARE tmp ROW;
CREATE LASTCHILD OF tmp DOMAIN('XMLNSC') NAME 'XMLNSC';
SET tmp.XMLNSC.ExceptionList = InputExceptionList;
SET tmp.BLOB = ASBITSTREAM(tmp.XMLNSC.ExceptionList OPTIONS FolderBitStream CCSID 1208);
-- CAST(tmp.BLOB AS CHAR CCSID 1208) to get the exception CHAR
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment