Dear All,

I am running db2 version 8 fix pack 4 on Win2k Prof. IS there any equivalent of oracle query

select null from dual;

like select null from sysibm.sysdummy1; (though this is not working)

in db2?

Thanks

Regards,
Deepak Ajmera

Deepak,
DB2 wants to know what data types the columns of the result set are. NULL has no intrinsic data type in of itself. You need to cast it to a data type for this to work. For example:

select cast(null as integer) from sysibm.sysdummy1

HTH

Andy

Thanks a lot. It is working fine in my queries.


Regards,
Deepak Ajmera