DB2常用SQL(DB2 commonly used SQL).docVIP

  • 6
  • 0
  • 约2.12万字
  • 约 24页
  • 2017-07-16 发布于河南
  • 举报
DB2常用SQL(DB2 commonly used SQL)

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

您可能关注的文档

文档评论(0)

1亿VIP精品文档

相关文档