我尝试了这句话
select schema_name , tabs_name ,
('select count(*) from' || schema_name ||'.'|| tabs_name)
from sysibm.systables
where schema_name = 'Sample'
我想在字符串类型中可以是execute字符串还是必须是create procedure或any?
'select count(*) from' || schema_name ||'.'|| tabs_name
从泰国提前感谢您
发布于 2018-06-09 01:01:38
试试这个:
Select TABLE_SCHEMA, TABLE_NAME, NUMBER_ROWS from qsys2.systablestat
Where TABLE_NAME = 'Sample'
https://stackoverflow.com/questions/29303469
复制相似问题