.export report file=SR.sql SELECT 'SHOW ' || CASE WHEN  ta.tablekind='t' then 'TABLE ' WHEN ta.tablekind='V' then 'VIEW ' END  || TRIM(t.db_name) || '.' || TRIM(t.tbl_name) || ';'  (TITLE'') from da_views.da_mb_tbl t LEFT JOIN dbc.tables ta ON t.db_name=ta.databasename AND t.tbl_name=ta.tablename where t.tbl_status_code='val' and t.mgmt_sa_code='SR'; .export reset  .export report file=SR_ddl.sql .run file=SR.sql .export reset
.export report file=TRADERA.sql SELECT 'SHOW ' || CASE WHEN  ta.tablekind='t' then 'TABLE ' WHEN ta.tablekind='V' then 'VIEW ' END  || TRIM(t.db_name) || '.' || TRIM(t.tbl_name) || ';'  (TITLE'') from da_views.da_mb_tbl t LEFT JOIN dbc.tables ta ON t.db_name=ta.databasename AND t.tbl_name=ta.tablename where t.tbl_status_code='val' and t.mgmt_sa_code='TRADERA'; .export reset  .export report file=TRADERA_ddl.sql .run file=TRADERA.sql .export reset
.export report file=VCRU.sql SELECT 'SHOW ' || CASE WHEN  ta.tablekind='t' then 'TABLE ' WHEN ta.tablekind='V' then 'VIEW ' END  || TRIM(t.db_name) || '.' || TRIM(t.tbl_name) || ';'  (TITLE'') from da_views.da_mb_tbl t LEFT JOIN dbc.tables ta ON t.db_name=ta.databasename AND t.tbl_name=ta.tablename where t.tbl_status_code='val' and t.mgmt_sa_code='VCRU'; .export reset  .export report file=VCRU_ddl.sql .run file=VCRU.sql .export reset
.export report file=LINK.sql SELECT 'SHOW ' || CASE WHEN  ta.tablekind='t' then 'TABLE ' WHEN ta.tablekind='V' then 'VIEW ' END  || TRIM(t.db_name) || '.' || TRIM(t.tbl_name) || ';'  (TITLE'') from da_views.da_mb_tbl t LEFT JOIN dbc.tables ta ON t.db_name=ta.databasename AND t.tbl_name=ta.tablename where t.tbl_status_code='val' and t.mgmt_sa_code='LINK'; .export reset  .export report file=LINK_ddl.sql .run file=LINK.sql .export reset
.export report file=TBAR.sql SELECT 'SHOW ' || CASE WHEN  ta.tablekind='t' then 'TABLE ' WHEN ta.tablekind='V' then 'VIEW ' END  || TRIM(t.db_name) || '.' || TRIM(t.tbl_name) || ';'  (TITLE'') from da_views.da_mb_tbl t LEFT JOIN dbc.tables ta ON t.db_name=ta.databasename AND t.tbl_name=ta.tablename where t.tbl_status_code='val' and t.mgmt_sa_code='TBAR'; .export reset  .export report file=TBAR_ddl.sql .run file=TBAR.sql .export reset