数据仓库服务 GaussDB(DWS)-TITLE:TITLE和CREATE VIEW

时间:2025-02-12 15:05:07

TITLE和CREATE VIEW

输入

REPLACE VIEW ${STG_VIEW}.B971_AUMSUMMARY${TABLE_SUFFIX_INC}  AS  LOCK TABLE ${STG_DATA}.B971_AUMSUMMARY${TABLE_SUFFIX_INC} FOR AC CES SSELECT   AUM_DATE (TITLE '    ')      ,CLNTCODE (TITLE '    ')      ,ACCTYPE (TITLE '    ')      ,CCY (TITLE '  ')      ,BAL_AMT (TITLE '  ')      ,MON_BAL_AMT (TITLE '    ')      ,HK_CLNTCODE (TITLE '   ')      ,MNT_DATE (TITLE '    ')FROM ${STG_DATA}.B971_AUMSUMMARY${TABLE_SUFFIX_INC};it should be migrated as below:CREATE OR REPLACE VIEW ${STG_VIEW}.B971_AUMSUMMARY${TABLE_SUFFIX_INC} AS /*LOCK TABLE ${STG_DATA}.B971_AUMSUMMARY${TABLE_SUFFIX_INC} FOR ACCESS */SELECT   AUM_DATE  /* (TITLE '    ') */      ,CLNTCODE  /* (TITLE '    ') */      ,ACCTYPE  /* (TITLE '    ') */      ,CCY  /* (TITLE '  ') */      ,BAL_AMT  /* (TITLE '  ') */      ,MON_BAL_AMT  /* (TITLE '    ') */      ,HK_CLNTCODE  /* (TITLE '   ') */      ,MNT_DATE  /* (TITLE '    ') */FROM ${STG_DATA}.B971_AUMSUMMARY${TABLE_SUFFIX_INC};

输出

CREATE OR REPLACE VIEW ${STG_VIEW}.B971_AUMSUMMARY${TABLE_SUFFIX_INC} AS /*LOCK TABLE ${STG_DATA}.B971_AUMSUMMARY${TABLE_SUFFIX_INC} FOR ACCESS */SELECT   AUM_DATE  /* (TITLE '    ') */      ,CLNTCODE  /* (TITLE '    ') */      ,ACCTYPE  /* (TITLE '    ') */      ,CCY  /* (TITLE '  ') */      ,BAL_AMT  /* (TITLE '  ') */      ,MON_BAL_AMT  /* (TITLE '    ') */      ,HK_CLNTCODE  /* (TITLE '   ') */      ,MNT_DATE  /* (TITLE '    ') */FROM ${STG_DATA}.B971_AUMSUMMARY${TABLE_SUFFIX_INC};
support.huaweicloud.com/tg-dws/dws_16_0068.html