retrieve all table names from DB2

[suchismita sen]

hi..

i want to dynamically retrieve all the table names from DB2. can anyone suggest me a procedure to do that. or is there any sample code available..??

[cburnett]

Retrieving tables

Something like this is what you are after:

select rtrim(T.tabschema)||'.'||rtrim(T.tabname) as table_name
  from syscat.tables T 
  with ur