DB2常用SQL（DB2 commonly used SQL）.docVIP

DB2常用SQL（DB2 commonly used SQL） DB2 commonly used SQL statements and string functions 1, combination statement execution BEGIN ATOMIC Expression 1 semicolon space / carriage return Expression 2 semicolon space / carriage return END 2, tables that should restrict access rights (should revoke these tables, PUBLIC, SELECT access) SYSCAT.DBAUTH SYSCAT.TABAUTH SYSCAT.PACKAGEAUTH SYSCAT.INDEXAUTH SYSCAT.COLAUTH SYSCAT.PASSTHRUAUTH SYSCAT.SCHEMAAUTH Useful directory tables SYSCAT.COLUMNS: contains each row corresponding to the columns defined in the table or view SYSCAT.INDEXCOLUSE: contains all colu