sql - Blobs are not allowed in this expression -

sql - Blobs are not allowed in this expression -

i face next problem:

-615: blobs not allowed in expression.

select ser ,task_code ,trans_serial ,trans_year ,case when nvl(length(signed_content), 0) <> '' signed_content else attach_content end signed_content ,case when nvl(length(signed_content), 0) <> '' 'signed_content' else 'attach_content' end comes_from attach_detail serial = 5 , task_code = 88 , trans_year = 2012 , trans_serial = 23728

note: signed_content, attach_content of type byte; other columns of type int.

your problem appears informix not allow blobs within case expressions.

to work around this, transform case 2 subqueries:

select ser ,task_code ,trans_serial ,trans_year ,signed_content signed_content ,'signed_content' comes_from attach_detail nvl(length(signed_content), 0) <> '' , serial = 5 , task_code = 88 , trans_year = 2012 , trans_serial = 23728 union select ser ,task_code ,trans_serial ,trans_year ,attach_content signed_content ,'attach_content' comes_from attach_detail nvl(length(signed_content), 0) = '' , serial = 5 , task_code = 88 , trans_year = 2012 , trans_serial = 23728

sql blob informix ibm