SQL query to convert CLOB to standard string

Discussion created by Michael_Coxson_5769 on Feb 17, 2017
Latest reply on Feb 18, 2017 by Michael_Coxson_5769
Hi all,

I am trying to write a subquery for a larger VSQLI that returns the value of a specific JOBS Variable, but I'm not sure how to cast a CLOB into a readable format within my current statement.  Could someone please provide me the method of returning the OV_VALUE value as a column result?

Here's what I have currently:
select distinct OH_NAME,OV_VNAME from OH,OV where OH_NAME like 'DRE.JU.TASKSPAWN_JOB.P3' and OH_IDNR = OV_OH_IDNR and OH_CLIENT = &$CLIENT#

(the static OH_NAME will eventually be variablized to &$NAME#)

I appreciate any help with this!