DB2常用傻瓜问题1000问(国外英语资料).docVIP

DB2常用傻瓜问题1000问 The following is mainly based on DB27.X. The following characters are lowercase This article does not need to look at for the DB2 master All characters are lowercase 91. how do I create a summary table for DB2? The DB2 summary table function is similar to the materialized view of ORACLE! Syntax for: CREATESUMMARYTABLETABLE_NAMEAS (FULLSELECT)... Such as: Defines a refreshed summary table: CREATESUMMARYTABLETABLE_NAMEAS (SELECT*FROMTABLE_NAME1WHERECOL1=AAA) DATAINITIALLYDEFERREDREFRESHDEFERRED DATAINITIALLYDEFERRED specifies that data cannot be inserted into the table as part of the CREATETABLE statement REFRESHDEFERRED specifies that the data in the table can be refreshed when any REFRESHTABLE statement is used! 92. how do I update the profile? REFRESHTABLESUM_TABLE Where SUM_TABLE is the summary table 93. how do you modify the summary table? ALTERTABLESUM_TABLE... 94. how do I create temporary tables? Syntax: DECLAREGLOBALTEMPORARYTABLETABLE_NAME AS (FULLSELECT) DEFINITIONONLY EXCLUDINGIDENTITYCOLUMNATTRIBUTES ONCOMMITDELETEROWS NOTLOGGED The first line specifies the name of the temporary table The second line defines the columns of the temporary table The third line specifies an identity column that is not copied from the source result table definition The fourth line specifies that all rows of the table will be deleted if the WITHGOLD cursor is not turned on The fifth line provides no record of changes in the table Such as: DECLAREGLOBALTEMPORARYTABLEDEC_BSEMPMS AS (SELECT*FROMBSEMPMS) DEFINITIONONLY EXCLUDINGIDENTITYCOLUMNATTRIBUTES ONCOMMITDELETEROWS NOTLOGGED 95. view management? How to create views: CREATEVIEWVIEW_NAMEASSELECT*FROMTABLE_NAMEWHERE... Delete view: DROPVIEWVIEW_NAME 96. how do I know the content of the view definition? In the TEXT column in SELECT*FROMSYSCAT.VIEWS 97. how do I create aliases? CREATEALIASALIAS_NAMEFORPRO_NAME The following PRO_NAME can be TABLE, VIEW, ALIAS, NICKNAME, and so on 98. how to create sequences? Such as