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

sql_reference

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

身份认证购VIP最低享 7 折!

30元优惠券

资源详情

资源推荐

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手册：全面详尽的开发指南

SQL Reference

SQL_reference.rar_SQL reference_reference sql

sql_referenceSQL 参考手册

SELECT count(dictinct `id`) FROM `baidubaike_article_reference` > 1064 - You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 26 near "`id`) FROM `baidubaike_article_reference`" 修改为正确的写法

SQL报错sql_mode=only_full_group_by

sql_mode=only_full_group_by不兼容

本地数据库this is incompatible with sql_mode=only_full_group_by

coe_xfr_sql_profile

java报错sql_mode=only_full_group_by

sql_mode=only_full_group_by

mysql报错sql_mode=only_full_group_by

SQL_INVALID_HANDLE

mysql5.7 this is incompatible with sql_mode=only_full_group_by

sql_mode=only_full_group_by mysql 8.0

sql_exporter

mysql 8.0 this is incompatible with sql_mode=only_full_group_by

on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

; this is incompatible with sql_mode=only_full_group_by

ubuntu with sql_mode=only_full_group_by

最新资源