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

时间：2024-05-16 14:23:21

TITLE和CREATE VIEW

输入：

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};
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};

上一篇：数据仓库服务 GAUSSDB(DWS)-DWS-Connector版本说明

下一篇：数据仓库服务 GAUSSDB(DWS)-视图迁移:CHECK OPTION