vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/tool/dws_16_0080.html
Lu, Huayi 27019c2991 DWS TOOL 830.201 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:35:25 +00:00

6.0 KiB
Raw Permalink Blame History

DBC.TABLES

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

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

Output

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
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 > ] ) ) )
;