I am using TABLE per concrete class with the Hibernate Entity Manager for DB2.
One of the tables contains a CLOB. A select statement is off the form:

select person0_.clobAttr as clobAttr1 from ( select nullif(0,0) as clobAttr from TPerson union all select clobAttr from TMechanic union all select clobAttr from TEmployee union all select nullif(0,0) as clobAttr from TCustomer ) person0_ where LASTNAME='RelsTest'

Generates the DB2 exception:

DB2 SQL error: SQLCODE: -415, SQLSTATE: 42825, SQLERRMC: null

Any ideas what I am doing wrong?
Cheers

Some update on this problem:
I m using DB2 version 8, I am using the dialect: org.hibernate.dialect.DB2Dialect.

It would appear that the syntax hibernate is generating is wrong. More specifically, DB2 does not like the syntax, nullif(0,0) as clobAttr, it should be cast(null as Clob) as clobAttr.

I am open to correction here, any ideas or comments appreciated.
cheers

Can you open a JIRA issue with a minimal test case, that will help. (if possible do it with hbm.xml files)