Hi all,

I am faily new to DB2

in Oracle I can do something like:

select 'TABLENAME - ' || count(*) from TABLENAME

DB2 does not seem to support this and throws an SQL0104N error.

Is there a way to write this for DB2?

Thanks
PAolo

But,
select 'tablename - '||cast(count(*) as char(10)) from tablename;

I didn't get the sql0104 error when I typed in what you specified, hence my confusion.


jdey@macehill.co.uk

select 'TABLENAME - ' || CHAR(COUNT(*)) from TABLENAME