没有合适的资源?快使用搜索试试~ 我知道了~
DB2 V9 sql Reference
4星 · 超过85%的资源 需积分: 10 7 下载量 22 浏览量
2012-07-24
16:27:24
上传
评论
收藏 7.1MB PDF 举报
温馨提示
试读
883页
DB2 SQL语句参考卷2,主要讲述DB2中SQL语句的DDL,DML,DCL语句的具体用法
资源推荐
资源详情
资源评论
DB2
®
SQL Reference Volume 2
DB2 Version 9
for Linux, UNIX, and Windows
SC10-4250-00
DB2
®
SQL Reference Volume 2
DB2 Version 9
for Linux, UNIX, and Windows
SC10-4250-00
Before using this information and the product it supports, be sure to read the general information under Notices.
Edition Notice
This document contains proprietary information of IBM. It is provided under a license agreement and is protected
by copyright law. The information contained in this publication does not include any product warranties, and any
statements provided in this manual should not be interpreted as such.
You can order IBM publications online or through your local IBM representative.
v To order publications online, go to the IBM Publications Center at www.ibm.com/shop/publications/order
v To find your local IBM representative, go to the IBM Directory of Worldwide Contacts at www.ibm.com/
planetwide
To
order DB2 publications from DB2 Marketing and Sales in the United States or Canada, call 1-800-IBM-4YOU
(426-4968).
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.
© Copyright International Business Machines Corporation 1993, 2006. All rights reserved.
US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract
with IBM Corp.
Contents
About this book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
Who should use this book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
How this book is structured . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
A brief overview of Volume 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
How to read the syntax diagrams . . . . . . . . . . . . . . . . . . . . . . . . . . . viii
Conventions used in this manual . . . . . . . . . . . . . . . . . . . . . . . . . . . .x
Error conditions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .x
Highlighting conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .x
Related documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .x
Statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1
Supported SQL statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1
How SQL statements are invoked . . . . . . . . . . . . . . . . . . . . . . . . . . . .8
Embedding a statement in an application program . . . . . . . . . . . . . . . . . . . . .8
Dynamic preparation and execution . . . . . . . . . . . . . . . . . . . . . . . . . .9
Static invocation of a select-statement . . . . . . . . . . . . . . . . . . . . . . . . . .9
Dynamic invocation of a select-statement . . . . . . . . . . . . . . . . . . . . . . . . .9
Interactive invocation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10
SQL use with other host systems . . . . . . . . . . . . . . . . . . . . . . . . . . .10
SQL return codes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10
SQL comments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .11
About SQL control statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . .13
Function, method, and procedure designators . . . . . . . . . . . . . . . . . . . . . . . .16
Function designator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16
Method designator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17
Procedure designator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .18
ALLOCATE CURSOR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .20
ALTER BUFFERPOOL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .22
ALTER DATABASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .25
ALTER DATABASE PARTITION GROUP . . . . . . . . . . . . . . . . . . . . . . . . .29
ALTER FUNCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .33
ALTER METHOD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .36
ALTER NICKNAME . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .38
ALTER PROCEDURE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .46
ALTER SEQUENCE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .49
ALTER SERVER . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .53
ALTER TABLE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .56
ALTER TABLESPACE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100
ALTER TYPE (Structured) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109
ALTER USER MAPPING . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .116
ALTER VIEW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .118
ALTER WRAPPER . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 120
ALTER XSROBJECT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122
ASSOCIATE LOCATORS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123
BEGIN DECLARE SECTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125
CALL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127
CASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133
CLOSE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136
COMMENT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 138
COMMIT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148
Compound SQL (Dynamic) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150
Compound SQL (Embedded) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155
Compound SQL (Procedure) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159
CONNECT (Type 1) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168
CONNECT (Type 2) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175
© Copyright IBM Corp. 1993, 2006 iii
剩余882页未读,继续阅读
资源评论
- zhugefung2013-02-06DB2 SQL语句参考卷2,主要讲述DB2中SQL语句的DDL,DML,DCL语句的具体用法,其它卷呢
hcglc
- 粉丝: 0
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功