title: I would like to count records in all tables in the schema using SQL for DB2 z/OS v9
body: <p>I try this statement</p>
  
  <pre><code>select schema_name , tabs_name ,
  ('select count(*) from' || schema_name ||'.'|| tabs_name)
  from sysibm.systables
  where schema_name = 'Sample'
  </code></pre>
  
  <p>I would like in the string type can be execute string or must be create procedure or any?</p>
  
  <pre><code>'select count(*) from' || schema_name ||'.'|| tabs_name
  </code></pre>
  
  <p>Thank you in advance
  from Thailand</p>