DB2 Version 9.1 for z/OS SQL Reference手册：全面详尽的开发指南

5星 · 超过95%的资源需积分: 13 51 浏览量更新于2024-07-29 收藏 7.36MB PDF 举报

"DB2官方SQL_reference文档是针对DB2 Version 9.1 for z/OS的一个详细指南，该文档由SC18-9854-08版本发布，适用于June 2010年发布的第九版。这份参考手册包含了丰富的内容，涵盖了SQL语言的语法、函数、控制语句以及示例，旨在作为开发人员的工具参考。在使用这份文档前，务必先阅读末尾的"注意事项"部分，了解可能存在的限制条件、适用范围和更新信息，确保与所使用的DB2 Version 9.1 for z/OS产品版本相匹配。每个更改都通过左侧的垂直线标记，而对图表的改动则会在图例旁注明。非技术性编辑修改未被特别标注。版权方面，此文档受IBM Corporation于1982年和2010年的版权保护，同时美国政府用户受限于GSA ADP Schedule合同中的规定，对于使用、复制或披露有所限制。 "About this information"章节提供了关于文档的目的、结构和预期读者的信息，可能包括如何有效地利用这些内容，以及文档的组织方式，例如按主题分类或按功能模块划分。"Whoshould read this information"部分可能介绍了哪些角色或级别的用户最适合阅读这份SQL Reference，比如开发人员、管理员、维护人员或技术支持人员。此外，文档还专门关注了DB2 Utilities Suite，这部分内容涵盖了与DB2数据库管理相关的实用工具和技术，如数据备份、恢复、性能监控、数据导入导出等功能的SQL操作指南。这些工具对日常数据库管理和优化至关重要。 DB2官方SQL_reference是DB2 Version 9.1 for z/OS用户的宝贵参考资料，它提供了全面且深入的SQL语法和功能指导，是提升数据库管理效率和理解的关键资源。无论你是初次接触DB2的开发者，还是经验丰富的数据库管理员，这个文档都能为你提供所需的知识支持。"

SYSIBM.SYSDATABASE table ...........................1747

SYSIBM.SYSDATATYPES table ...........................1749

SYSIBM.SYSDBAUTH table ............................1751

SYSIBM.SYSDBRM table .............................1754

SYSIBM.SYSDEPENDENCIES table..........................1756

SYSIBM.SYSDUMMY1 table ............................1758

SYSIBM.SYSENVIRONMENT table..........................1759

SYSIBM.SYSFIELDS table .............................1761

SYSIBM.SYSFOREIGNKEYS table ..........................1763

SYSIBM.SYSINDEXES table ............................1764

SYSIBM.SYSINDEXES_HIST table ..........................1769

SYSIBM.SYSINDEXPART table ...........................1771

SYSIBM.SYSINDEXPART_HIST table .........................1775

SYSIBM.SYSINDEXSPACESTATS table ........................1777

SYSIBM.SYSINDEXSTATS table ...........................1782

SYSIBM.SYSINDEXSTATS_HIST table .........................1784

SYSIBM.SYSJARCLASS_SOURCE table ........................1785

SYSIBM.SYSJARCONTENTS table ..........................1786

SYSIBM.SYSJARDATA table ............................1787

SYSIBM.SYSJAROBJECTS table ...........................1788

SYSIBM.SYSJAVAOPTS table ............................1789

SYSIBM.SYSJAVAPATHS table ...........................1790

SYSIBM.SYSKEYCOLUSE table ...........................1791

SYSIBM.SYSKEYS table .............................1792

SYSIBM.SYSKEYTARGETS table...........................1793

SYSIBM.SYSKEYTARGETSTATS table .........................1796

SYSIBM.SYSKEYTARGETS_HIST table ........................1798

SYSIBM.SYSKEYTGTDIST table ...........................1801

SYSIBM.SYSKEYTGTDISTSTATS table.........................1803

SYSIBM.SYSKEYTGTDIST_HIST table .........................1805

SYSIBM.SYSLOBSTATS table ............................1807

SYSIBM.SYSLOBSTATS_HIST table ..........................1808

SYSIBM.SYSOBJROLEDEP table ...........................1809

SYSIBM.SYSPACKAGE table

............................1810

SYSIBM.SYSPACKAUTH table ...........................1818

SYSIBM.SYSPACKDEP table ............................1820

SYSIBM.SYSPACKLIST table ............................1822

SYSIBM.SYSPACKSTMT table ...........................1823

SYSIBM.SYSPARMS table .............................1826

SYSIBM.SYSPKSYSTEM table ...........................1830

SYSIBM.SYSPLAN table .............................1832

SYSIBM.SYSPLANAUTH table ...........................1837

SYSIBM.SYSPLANDEP table ............................1839

SYSIBM.SYSPLSYSTEM table............................1840

SYSIBM.SYSRELS table..............................1841

SYSIBM.SYSRESAUTH table ............................1843

SYSIBM.SYSROLES table .............................1845

SYSIBM.SYSROUTINEAUTH table ..........................1846

SYSIBM.SYSROUTINES table............................1848

SYSIBM.SYSROUTINESTEXT table ..........................1858

SYSIBM.SYSROUTINES_OPTS table .........................1859

SYSIBM.SYSROUTINES_SRC table ..........................1861

SYSIBM.SYSSCHEMAAUTH table ..........................1862

SYSIBM.SYSSEQUENCEAUTH table .........................1863

SYSIBM.SYSSEQUENCES table ...........................1865

SYSIBM.SYSSEQUENCESDEP table .........................1867

SYSIBM.SYSSTMT table .............................1868

SYSIBM.SYSSTOGROUP table ...........................1872

SYSIBM.SYSSTRINGS table ............................1874

SYSIBM.SYSSYNONYMS table ...........................1876

SYSIBM.SYSTABAUTH table ............................1877

xiv SQL Reference

SYSIBM.SYSTABCONST table ...........................1880

SYSIBM.SYSTABLEPART table ...........................1881

SYSIBM.SYSTABLEPART_HIST table .........................1886

SYSIBM.SYSTABLES table .............................1889

SYSIBM.SYSTABLESPACE table ...........................1895

SYSIBM.SYSTABLESPACESTATS table.........................1900

SYSIBM.SYSTABLES_HIST table...........................1904

SYSIBM.SYSTABSTATS table ............................1906

SYSIBM.SYSTABSTATS_HIST table ..........................1907

SYSIBM.SYSTRIGGERS table ............................1908

SYSIBM.SYSUSERAUTH table ...........................1910

SYSIBM.SYSVIEWDEP table ............................1913

SYSIBM.SYSVIEWS table .............................1914

SYSIBM.SYSVOLUMES table ............................1916

SYSIBM.SYSXMLRELS table ............................1917

SYSIBM.SYSXMLSTRINGS table...........................1918

SYSIBM.USERNAMES table ............................1919

SYSIBM.XSRCOMPONENT table ..........................1920

SYSIBM.XSROBJECTS table ............................1921

SYSIBM.XSROBJECTCOMPONENTS table .......................1923

SYSIBM.XSROBJECTGRAMMAR table ........................1924

SYSIBM.XSROBJECTHIERARCHIES table .......................1925

SYSIBM.XSROBJECTPROPERTY table .........................1926

SYSIBM.XSRPROPERTY table ...........................1927

Using the catalog in database design ..........................1927

Retrieving catalog information about DB2 storage groups ..................1927

Retrieving catalog information about a table.......................1928

Retrieving catalog information about partition order ....................1928

Retrieving catalog information about aliases.......................1928

Retrieving catalog information about columns ......................1929

Retrieving catalog information about indexes ......................1930

Retrieving catalog information about views .......................1930

Retrieving catalog information about authorizations ....................1931

Retrieving catalog information about primary keys ....................

1931

Retrieving catalog information about foreign keys .....................1932

Retrieving catalog information about check pending ....................1932

Retrieving catalog information about check constraints ...................1933

Retrieving catalog information about LOBs .......................1933

Retrieving catalog information about user-defined functions and stored procedures .........1934

Retrieving catalog information about triggers ......................1934

Retrieving catalog information about sequences .....................1935

Adding and retrieving comments ..........................1935

Verifying the accuracy of the database definition .....................1936

Sample user-defined functions ............................1936

ALTDATE..................................1938

ALTTIME ..................................1941

CURRENCY .................................1943

DAYNAME .................................1945

MONTHNAME ................................1946

TABLE_LOCATION ...............................1947

TABLE_NAME ................................1949

TABLE_SCHEMA ...............................1951

WEATHER ..................................1953

Information resources for DB2 for z/OS and related products ...........1955

How to obtain DB2 information ........................1961

How to use the DB2 library ..........................1965

Contents xv

About this information

This book is a reference for Structured Query Language (SQL) for DB2 Universal

Database

™

for z/OS

. Unless otherwise stated, references to SQL in this book

imply SQL for DB2

UDB for z/OS, and all objects described in this book are

objects of DB2 UDB for z/OS.

This information assumes that your DB2 subsystem is running in Version 9.1

new-function mode. Generally, new functions that are described, including changes

to existing functions, statements, and limits, are available only in new-function

mode. Two exceptions to this general statement are new and changed utilities and

optimization enhancements, which are also available in conversion mode unless

stated otherwise.

The syntax and semantics of most SQL statements are essentially the same in all

IBM

relational database products, and the language elements common to the

products provide a base for the definition of IBM SQL. Consult IBM DB2 Universal

Database SQL Reference for Cross-Platform Development if you intend to develop

applications that adhere to IBM SQL.

Who should read this information

This information is intended for end users, application programmers, system and

database administrators, and for persons involved in error detection and diagnosis.

This information is a reference rather than a tutorial. It assumes that you are

already familiar with SQL programming concepts.

When you first use this information, consider reading Chapters 1 and 2

sequentially. These chapters describe the basic concepts of relational databases and

SQL, the basic syntax of SQL, and the language elements that are common to

many SQL statements. The rest of the chapters and appendixes are designed for

the quick location of answers to specific SQL questions. They provide you with

query forms, SQL statements, SQL procedure statements, DB2 limits, SQLCA,

SQLDA, catalog tables, and SQL reserved words.

DB2 Utilities Suite

Important: In this version of DB2 for z/OS, the DB2 Utilities Suite is available as

an optional product. You must separately order and purchase a license to such

utilities, and discussion of those utility functions in this publication is not intended

to otherwise imply that you have a license to them.

The DB2 Utilities Suite is designed to work with the DFSORT program, which you

are licensed to use in support of the DB2 utilities even if you do not otherwise

license DFSORT for general use. If your primary sort product is not DFSORT,

consider the following informational APARs mandatory reading:

v II14047/II14213: USE OF DFSORT BY DB2 UTILITIES

v II13495: HOW DFSORT TAKES ADVANTAGE OF 64-BIT REAL

ARCHITECTURE

These informational APARs are periodically updated.

Related information

DB2 utilities packaging (Utility Guide)

Terminology and citations

In this information, DB2 Version 9.1 for z/OS is referred to as "DB2 for z/OS." In

cases where the context makes the meaning clear, DB2 for z/OS is referred to as

"DB2." When this information refers to titles of DB2 for z/OS books, a short title is

used. (For example, "See DB2 SQL Reference" is a citation to IBM DB2 Version 9.1 for

z/OS SQL Reference.)

When referring to a DB2 product other than DB2 for z/OS, this information uses

the product's full name to avoid ambiguity.

The following terms are used as indicated:

DB2 Represents either the DB2 licensed program or a particular DB2 subsystem.

OMEGAMON

Refers to any of the following products:

v IBM Tivoli

OMEGAMON XE for DB2 Performance Expert on z/OS

v IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS

v IBM DB2 Performance Expert for Multiplatforms and Workgroups

v IBM DB2 Buffer Pool Analyzer for z/OS

C, C++, and C language

Represent the C or C++ programming language.

CICS

Represents CICS Transaction Server for z/OS.

IMS

™

Represents the IMS Database Manager or IMS Transaction Manager.

MVS

™

Represents the MVS element of the z/OS operating system, which is

equivalent to the Base Control Program (BCP) component of the z/OS

operating system.

RACF

Represents the functions that are provided by the RACF component of the

z/OS Security Server.

Accessibility features for DB2 Version 9.1 for z/OS

Accessibility features help a user who has a physical disability, such as restricted

mobility or limited vision, to use information technology products successfully.

Accessibility features

The following list includes the major accessibility features in z/OS products,

including DB2 Version 9.1 for z/OS. These features support:

v Keyboard-only operation.

v Interfaces that are commonly used by screen readers and screen magnifiers.

v Customization of display attributes such as color, contrast, and font size

Tip: The Information Management Software for z/OS Solutions Information

Center (which includes information for DB2 Version 9.1 for z/OS) and its related

publications are accessibility-enabled for the IBM Home Page Reader. You can

operate all features using the keyboard instead of the mouse.

xviii SQL Reference

剩余2100页未读，继续阅读

lujinwenqust

粉丝: 0
资源: 5

DB2 Version 9.1 for z/OS SQL Reference手册：全面详尽的开发指南

TPC-H标准SQL参考手册介绍

Oracle数据库SQL速查指南

Oracle Database 11g SQL Language Reference Manual

SQL_reference.rar_SQL reference_reference sql

Oracle_SQL_Reference

db2SQL_Reference_1_950

db2SQL_Reference_2_950

SAP_HANA_SQL_Reference_Guide_en.pdf

HP_Vertica_7.1.x_SQL_Reference_Manual

Oracle10g_SQL_Reference.pdf

最新资源