没有合适的资源?快使用搜索试试~ 我知道了~
首页db2 cli 函数说明大全(最新版)
db2 cli 函数说明大全(最新版)
5星 · 超过95%的资源 需积分: 19 100 下载量 157 浏览量
更新于2023-03-03
评论
收藏 2.85MB PDF 举报
《Call Level Interface Guide and Reference,Volume2》 cli 所有函数的详细说明,对于查询cli的函数说明、参数等很有帮助。该文档没有包含如何使用cli等内容(比如cli的配置、cli 调用顺序等内容),这些内容在另一份文档 《Call Level Interface Guide and Reference,Volume1》里。
资源详情
资源评论
资源推荐
IB M
®
DB2
Universal
Database
™
Call
Level
Interface
Gui de
and
Reference,
Volu me
2
Ve r s i o n
8.2
SC09-4850-01
IB M
®
DB2
Universal
Database
™
Call
Level
Interface
Gui de
and
Reference,
Volu me
2
Ve r s i o n
8.2
SC09-4850-01
Before
using
this
information
and
the
product
it
supports,
be
sure
to
read
the
general
information
under
Notices.
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
-
2004.
All
rights
reserved.
US
Government
Users
Restricted
Rights
–
Use,
duplication
or
disclosure
restricted
by
GSA
ADP
Schedule
Contract
with
IBM
Corp.
Contents
Chapter
1.
DB2
CLI
functions
.
.
.
.
.1
CLI
and
ODBC
function
summary
.
.
.
.
.
.
.1
SQLAllocConnect
function
(CLI)
-
Allocate
connection
handle
.
.
.
.
.
.
.
.
.
.
.
.5
SQLAllocEnv
function
(CLI)
-
Allocate
environment
handle
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.6
SQLAllocHandle
function
(CLI)
-
Allocate
handle
.
.6
SQLAllocStmt
function
(CLI)
-
Allocate
a
statement
handle
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.9
SQLBindCol
function
(CLI)
-
Bind
a
column
to
an
application
variable
or
LOB
locator
.
.
.
.
.
.
.9
SQLBindFileToCol
function
(CLI)
-
Bind
LOB
file
reference
to
LOB
column
.
.
.
.
.
.
.
.
.
.16
SQLBindFileToParam
function
(CLI)
-
Bind
LOB
file
reference
to
LOB
parameter
.
.
.
.
.
.
.
.
.20
SQLBindParameter
function
(CLI)
-
Bind
a
parameter
marker
to
a
buffer
or
LOB
locator
.
.
.23
SQLBrowseConnect
function
(CLI)
-
Get
required
attributes
to
connect
to
data
source
.
.
.
.
.
.36
SQLBuildDataLink
function
(CLI)
-
Build
DATALINK
value
.
.
.
.
.
.
.
.
.
.
.
.41
SQLBulkOperations
function
(CLI)
-
Add,
update,
delete
or
fetch
a
set
of
rows
.
.
.
.
.
.
.
.
.43
SQLCancel
function
(CLI)
-
Cancel
statement
.
.
.49
SQLCloseCursor
function
(CLI)
-
Close
cursor
and
discard
pending
results
.
.
.
.
.
.
.
.
.
.51
SQLColAttribute
function
(CLI)
-
Return
a
column
attribute
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.53
SQLColAttributes
function
(CLI)
-
Get
column
attributes
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.62
SQLColumnPrivileges
function
(CLI)
-
Get
privileges
associated
with
the
columns
of
a
table
.
.63
SQLColumns
function
(CLI)
-
Get
column
information
for
a
table
.
.
.
.
.
.
.
.
.
.
.66
SQLConnect
function
(CLI)
-
Connect
to
a
data
source
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.73
SQLCopyDesc
function
(CLI)
-
Copy
descriptor
information
between
handles
.
.
.
.
.
.
.
.76
SQLDataSources
function
(CLI)
-
Get
list
of
data
sources
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.79
SQLDescribeCol
function
(CLI)
-
Return
a
set
of
attributes
for
a
column
.
.
.
.
.
.
.
.
.
.82
SQLDescribeParam
function
(CLI)
-
Return
description
of
a
parameter
marker
.
.
.
.
.
.
.85
SQLDisconnect
function
(CLI)
-
Disconnect
from
a
data
source
.
.
.
.
.
.
.
.
.
.
.
.
.
.88
SQLDriverConnect
function
(CLI)
-
(Expanded)
Connect
to
a
data
source
.
.
.
.
.
.
.
.
.
.90
SQLEndTran
function
(CLI)
-
End
transactions
of
a
connection
or
an
Environment
.
.
.
.
.
.
.
.96
SQLError
function
(CLI)
-
Retrieve
error
information
99
SQLExecDirect
function
(CLI)
-
Execute
a
statement
directly
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 100
SQLExecute
function
(CLI)
-
Execute
a
statement
105
SQLExtendedBind
function
(CLI)
-
Bind
an
array
of
columns
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 108
SQLExtendedFetch
function
(CLI)
-
Extended
fetch
(fetch
array
of
rows)
.
.
.
.
.
.
.
.
.
.
.112
SQLExtendedPrepare
function
(CLI)
-
Prepare
a
statement
and
set
statement
attributes
.
.
.
.
.112
SQLFetch
function
(CLI)
-
Fetch
next
row
.
.
.
.117
SQLFetchScroll
function
(CLI)
-
Fetch
rowset
and
return
data
for
all
bound
columns
.
.
.
.
.
. 125
Cursor
positioning
rules
for
SQLFetchScroll()
(CLI)
131
SQLForeignKeys
function
(CLI)
-
Get
the
list
of
foreign
key
columns
.
.
.
.
.
.
.
.
.
.
. 133
SQLFreeConnect
function
(CLI)
-
Free
connection
handle
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 138
SQLFreeEnv
function
(CLI)
-
Free
environment
handle
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 139
SQLFreeHandle
function
(CLI)
-
Free
handle
resources
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 139
SQLFreeStmt
function
(CLI)
-
Free
(or
reset)
a
statement
handle
.
.
.
.
.
.
.
.
.
.
.
. 142
SQLGetConnectAttr
function
(CLI)
-
Get
current
attribute
setting
.
.
.
.
.
.
.
.
.
.
.
. 145
SQLGetConnectOption
function
(CLI)
-
Return
current
setting
of
a
connect
option
.
.
.
.
.
. 148
SQLGetCursorName
function
(CLI)
-
Get
cursor
name
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 148
SQLGetData
function
(CLI)
-
Get
data
from
a
column
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 151
SQLGetDataLinkAttr
function
(CLI)
-
Get
DataLink
attribute
value
.
.
.
.
.
.
.
.
.
.
.
.
. 157
SQLGetDescField
function
(CLI)
-
Get
single
field
settings
of
descriptor
record
.
.
.
.
.
.
.
. 159
SQLGetDescRec
function
(CLI)
-
Get
multiple
field
settings
of
descriptor
record
.
.
.
.
.
.
.
. 163
SQLGetDiagField
function
(CLI)
-
Get
a
field
of
diagnostic
data
.
.
.
.
.
.
.
.
.
.
.
.
. 167
SQLGetDiagRec
function
(CLI)
-
Get
multiple
fields
settings
of
diagnostic
record
.
.
.
.
.
.
.
. 172
SQLGetEnvAttr
function
(CLI)
-
Retrieve
current
environment
attribute
value
.
.
.
.
.
.
.
. 175
SQLGetFunctions
function
(CLI)
-
Get
functions
177
SQLGetInfo
function
(CLI)
-
Get
general
information
.
.
.
.
.
.
.
.
.
.
.
.
.
. 178
SQLGetLength
function
(CLI)
-
Retrieve
length
of
a
string
value
.
.
.
.
.
.
.
.
.
.
.
.
.
. 209
SQLGetPosition
function
(CLI)
-
Return
starting
position
of
string
.
.
.
.
.
.
.
.
.
.
.
.211
SQLGetSQLCA
function
(CLI)
-
Get
SQLCA
data
structure
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 214
SQLGetStmtAttr
function
(CLI)
-
Get
current
setting
of
a
statement
attribute
.
.
.
.
.
.
. 215
SQLGetStmtOption
function
(CLI)
-
Return
current
setting
of
a
statement
option
.
.
.
.
.
.
.
. 218
SQLGetSubString
function
(CLI)
-
Retrieve
portion
of
a
string
value
.
.
.
.
.
.
.
.
.
.
.
. 219
SQLGetTypeInfo
function
(CLI)
-
Get
data
type
information
.
.
.
.
.
.
.
.
.
.
.
.
.
. 222
©
Copyright
IBM
Corp.
1993
-
2004
iii
剩余426页未读,继续阅读
henry_3333333333333
- 粉丝: 8
- 资源: 6
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- 27页智慧街道信息化建设综合解决方案.pptx
- 计算机二级Ms-Office选择题汇总.doc
- 单链表的插入和删除实验报告 (2).docx
- 单链表的插入和删除实验报告.pdf
- 物联网智能终端项目设备管理方案.pdf
- 如何打造品牌的模式.doc
- 样式控制与页面布局.pdf
- 武汉理工Java实验报告(二).docx
- 2021线上新品消费趋势报告.pdf
- 第3章 Matlab中的矩阵及其运算.docx
- 基于Web的人力资源管理系统的必要性和可行性.doc
- 基于一阶倒立摆的matlab仿真实验.doc
- 速运公司物流管理模式研究教材
- 大数据与管理.pptx
- 单片机课程设计之步进电机.doc
- 大数据与数据挖掘.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论2