I try this statement
select schema_name , tabs_name ,
('select count(*) from' || schema_name ||'.'|| tabs_name)
from sysibm.systables
where schema_name = 'Sample'
I would like in the string type can be execute string or must be create procedure or any?
'select count(*) from' || schema_name ||'.'|| tabs_name
Thank you in advance from Thailand