sql reference.pdf

IBM

DB2

Universal Database

SQL Reference

Ve r s i o n 7

SC09-2974-00, SC09-2975-00

IBM

DB2

Universal Database

SQL Reference

Ve r s i o n 7

SC09-2974-00, SC09-2975-00

Before using this information and the product it supports, be sure to read the general information under

“Appendix S. Notices” on page 1447.

in Canada.

When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any

way it believes appropriate without incurring any obligation to you.

US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract

with IBM Corp.

1-800-IBM-4YOU

This document contains proprietary information of IBM. It is provided under a license agreement and is protected by

statements provided in this manual should not be interpreted as such.

Order publications through your IBM representative or the IBM branch office serving your locality or by calling

1-800-879-2755

in the United States or

Contents

Chapter 1. Introduction ........ 1

Who Should Use This Book . . . . . . . 1

How To Use This Book. . . . . . . . . 1

How This Book is Structured . . . . . . 1

How to Read the Syntax Diagrams . . . . . 3

Conventions Used in This Manual . . . . . 5

Error Conditions . . . . . . . . . . 5

Highlighting Conventions . . . . . . . 5

Related Documentation for This Book . . . . 6

so ionLev l. . . . . . . . . . . 7

Rep ab eR ad(RR). . . . . . . . 8

Read Stability (RS) . . . . . . . . . 8

Cursor Stability (CS) . . . . . . . . 9

Uncommitted Read (UR) . . . . . . . 9

Comparison of Isolation Levels . . . . 9

Distributed Relational Database . . . . . 9

Application Servers . . . . . . . . 0

CONNECT (Type 1) and CONNECT (Type

) . . . . . . . . . . . . . . 1

Remo eUn tofWork. . . . . . . . 1

Application-Directed Distributed Unit of

Work. . . . . . . . . . . . . 5

Data Representation Considerations . . . 41

DB2 Federated Systems . . . . . . . . 1

The Federated Server, Federated Database,

and Data Sources . . . . . . . . . 1

Tasks to Perform in a DB2 Federated

System . . . . . . . . . . . . . 2

Wrappers and Wrapper Modules . . . . 3

Server Definitions and Server Options . . 44

User Mappings and User Options . . . . 6

Data Type Mappings . . . . . . . . 7

Function Mappings, Function Templates,

and Function Mapping Options . . . . 8

Nicknames and Column Options . . . . 8

Index Specifications . . . . . . . . 9

Distributed Requests . . . . . . . . 0

Compen ion. . . . . . . . . . 1

Pass-Through . . . . . . . . . . 1

Character Conversion . . . . . . . . . 2

Character Sets and Code Pages. . . . . 3

Code Page Attributes . . . . . . . . 4

Authorization and Privileges . . . . . . 5

Table Spaces and Other Storage Structures . . 58

Data Partitioning Across Multiple Partitions 59

Partitioning Maps . . . . . . . . . 0

ab eCo lo ion. . . . . . . . . 1

Chapter 2. Concepts ......... 9

Relational Database . . . . . . . . . . 9

Structured Query Language (SQL) . . . . . 9

EmbeddedSQL. . . . . . . . . . . 0

cSQL. . . . . . . . . . . . 0

Dynamic SQL . . . . . . . . . . 0

DB2 Call Level Interface (CLI) & Open

Database Connectivity (ODBC). . . . . . 0

Java Database Connectivity (JDBC) and

Embedded SQL for Java (SQLJ) Programs . . 11

Interactive SQL . . . . . . . . . . . 2

chem s. . . . . . . . . . . . . 2

Controlling Use of Schemas . . . . . . 2

ab s. . . . . . . . . . . . . . 3

V ews. . . . . . . . . . . . . . 4

A s. . . . . . . . . . . . . . 5

Ind s . . . . . . . . . . . . . 5

Keys . . . . . . . . . . . . . . 5

UniqueKeys. . . . . . . . . . . 6

P im ryKeys . . . . . . . . . . 6

Fo ignKeys. . . . . . . . . . . 6

Partitioning Keys . . . . . . . . . 6

Constraints . . . . . . . . . . . . 6

Unique Constraints . . . . . . . . 7

Referential Constraints . . . . . . . 7

Table Check Constraints . . . . . . . . 1

igg s. . . . . . . . . . . . . 1

EventMon to s. . . . . . . . . . . 3

Queries . . . . . . . . . . . . . 3

Table Expressions . . . . . . . . . . 3

Common Table Expressions . . . . . . 3

Packages . . . . . . . . . . . . . 4

C logV ews. . . . . . . . . . . 4

Application Processes, Concurrency, and

R cov ry. . . . . . . . . . . . . 4

Chapter 3. Language Elements ..... 63

Characters . . . . . . . . . . . . 3

MBCSCon id ions. . . . . . . . 4

okens. . . . . . . . . . . . . . 4

MBCSCon id ions. . . . . . . . 5

Identifiers . . . . . . . . . . . . . 5

iii

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: