DBC.TABLES

Updated on 2023-04-03 GMT+08:00

View PDF

The DSC migrates dbc.tables to their corresponding mig_td_ext.vw_td_dbc_tables.

Example: databasename is migrated as mig_td_ext.vw_td_dbc_tables.schemaname.

Input

   
      sel databasename,tablename FROM dbc.tables
WHERE tablekind='T' and trim(databasename) = '<dbname>'
AND
( NOT(TRIM(tablename) LIKE ANY  (<excludelist>))
);

Output

   
      SELECT
         mig_td_ext.vw_td_dbc_tables.schemaname
                                , mig_td_ext.vw_td_dbc_tables.tablename

     FROM
         mig_td_ext.vw_td_dbc_tables
     WHERE
                                mig_td_ext.vw_td_dbc_tables.tablekind =  'T'
          AND TRIM(mig_td_ext.vw_td_dbc_tables.schemaname) = '<dbname>'
          AND( NOT( TRIM(mig_td_ext.vw_td_dbc_tables.tablename) LIKE ANY ( ARRAY[ < excludelist > ] ) ) )
;