var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Echoing the name of the table along with the number of records it contains
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?
Not entirely sure if this is what you mean
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.
select 'TABLENAME - ' || CHAR(COUNT(*)) from TABLENAME
Originally Posted by pgesmundo