Cast CLOB

Posted in 2015

Topics: Stored Procedures & SPL, Data Types & Schema Design, Versions, Editions & End-of-Life

ULF ÃKERBERG — Fri, 10 Jul 2015 07:05:28 — source: IIUG Forums & Mailing Lists

Hi! Version 11.70.FC8. I am trying to cast a CLOB to a LVARCHAR. The engine allows the cast but the result is strange. I have a column in a table that displays as "0005" (using Server Studio for retrivial) when it is a CLOB, when I cast it to a LVARCHAR it displays as "01000000d9c8b7a60a0000000a00000064040000814af7540000000001000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000" My need is to be able to use a condition on a CLOB directly in SQL, does anybody has any ideas? Regards Ulf

↪ replying to ULF ÃKERBERG

David Williams — Fri, 10 Jul 2015 08:16:24 — source: IIUG Forums & Mailing Lists

Select the length of the clob.=20 Select hex of the clob Use oncheck to dump the page -----Original Message----- From: "ULF =C3=85KERBERG" <ulf.akerberg@migrationsverket.se> Sent: =E2=80=8E10/=E2=80=8E07/=E2=80=8E2015 08:06 To: "ids@iiug.org" <ids@iiug.org> Subject: Cast CLOB [35427] Hi!=20 Version 11.70.FC8.=20 I am trying to cast a CLOB to a LVARCHAR. The engine allows the cast but th= e=20 result is strange.=20 I have a column in a table that displays as "0005" (using Server Studio for= =20 retrivial) when it is a CLOB, when I cast it to a LVARCHAR it displays as=20 "01000000d9c8b7a60a0000000a00000064040000814af75400000000010000000000000000= 0000000000000000000000000000000000000000000000000000000000000000000000"=20 My need is to be able to use a condition on a CLOB directly in SQL, does=20 anybody has any ideas?=20 Regards=20 Ulf=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20