Load a BLOB text field from Oracle into QlikView 12.10 SR7

marychen — Wed, 23 Aug 2017 18:07:25 GMT

I am trying to load a blob filed from Oracle into QlikView 12.10 SR7. The following is the script I created based on Qlik article "How to store binary image SQL server and load it into QlikView". The GDTXFT field is the blog field which holds the text notes up to 3000 characters. After reload, all I got for the GDTXFT is either a "S" or a "{". When I use INFO(ACTIVITY_ID) it displays a string like this: "qmem://<6>/<60148><b43ee1c1914df022acef91dc7edb2d15>" . Does anyone know how I can turn the INFO(ACTIVITY_ID) into a readable text notes in QliKView?

ODBC CONNECT TO [JDEDEV;DBQ=JDEDEV ] (XUserId is ABC, XPassword is XXX);

SQL SELECT ZGAVID as ACTIVITY_ID, GDTXFT
FROM CHDTA.F03B31 LEFT JOIN CHDTA.F00165
ON ZGAVID = GDTXKY AND ZGAIT = 30 AND GDOBNM = 'GT03B31' and DBMS_LOB.GETCHUNKSIZE(GDTXFT)<=32767;

INFO SELECT ZGAVID as ACTIVITY_ID, GDTXFT
FROM CHDTA.F03B31 LEFT JOIN CHDTA.F00165
ON ZGAVID = GDTXKY AND ZGAIT = 30 AND GDOBNM = 'GT03B31' and DBMS_LOB.GETCHUNKSIZE(GDTXFT)<=32767;

Re: Load a BLOB text field from Oracle into QlikView 12.10 SR7

devarasu07 — Thu, 24 Aug 2017 01:30:17 GMT

Hi,

Chick this,

GET A BLOB INTO YOUR QV SUCCESFULLY! | Qlik Community

Re: Load a BLOB text field from Oracle into QlikView 12.10 SR7

marychen — Thu, 24 Aug 2017 16:36:58 GMT

Tested this approach as suggested before. I guess it should work fine with MS SQL database, but not with Oracle database. Thanks for sending me the link.

topic Re: Load a BLOB text field from Oracle into QlikView 12.10 SR7 in QlikView

Load a BLOB text field from Oracle into QlikView 12.10 SR7

Re: Load a BLOB text field from Oracle into QlikView 12.10 SR7

Re: Load a BLOB text field from Oracle into QlikView 12.10 SR7