Hi all,

I have a field with BLOB SUB_TYPE TEXT SEGMENT SIZE 80,
i want to union this field with a string 'Received to-date'.
I have to cast both of the field to BLOB rite?
How to do so?

I tried
SELECT
FIELDA AS A
...
UNION
SELECT
'Received to-date' AS A
....

it gives me error data type unknown

I tried
SELECT
CAST(FIELDA AS BLOB SUB_TYPE TEXT SEGMENT SIZE 80)AS A
...
UNION
SELECT
CAST('Received to-date' AS BLOB SUB_TYPE TEXT SEGMENT SIZE 80) AS A
....

it gives me error
Statement failed, SQLCODE = -104

invalid request BLR at offset 285
-data operation not supported

any suggestion?

Thanks!

eLita