topic UTL_RAW.CAST_TO_VARCHAR2 in QlikView

UTL_RAW.CAST_TO_VARCHAR2

sifatnabil — Wed, 28 Oct 2015 03:49:01 GMT

Hi all,

Oracle SQL has this function UTL_RAW.CAST_TO_VARCHAR2 which converts from RAW to varchar. Is there a function on the QV script side which can do the same for RAWs?

Re: UTL_RAW.CAST_TO_VARCHAR2

PrashantSangle — Wed, 28 Oct 2015 04:14:50 GMT

Hi,

Basically this function is used to converts RAW datatype to Varchar datatype.

So depend on your data present in that field you can use QlikView functions.

Can you share what kind of data present in that field?

If possible, also share some data of it.

Regards

Re: UTL_RAW.CAST_TO_VARCHAR2

sifatnabil — Wed, 28 Oct 2015 04:51:16 GMT

Hi dreamer4‌, the data consists of values with a comma delimiter like this:

EXEC_IDS

48:06001671363043A0,52:280016530006C576

70:0600167E363084A7,71:0600167E363084AA

I want to use QV's subfield function to extract the values in BOLD, but they are in RAW format. I want to convert them to varchar. The varchar equivalent looks like this 16 digit number: 32383030313635333030303643353736

I'm using subfield like this: trim(subfield(subfield(EXEC_IDS,','),':',2)) as EXEC_ID

Re: UTL_RAW.CAST_TO_VARCHAR2

PrashantSangle — Wed, 28 Oct 2015 06:09:07 GMT

Hi,

It is difficult to know what kind of alogorithm use behind that function.

But if you want that converted 16 digit number in your report.

then you can use that field using same function while fetching data from database.

and using evaluate() you can load that 16 digit number in QlikView Report

Regards,