DB2 CLI指南与参考：第二卷，创建数据库应用与函数详解

需积分: 11 197 浏览量更新于2024-07-17 收藏 2.52MB PDF 举报

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

领优惠券(最高得80元）

资源详情

资源推荐

Table 1. CLI Function list by category (continued)

Task

Function name

ODBC

3.0

SQL/

CLI

first version

supported Purpose

SQLCopyDesc() Core 95 V5 Copies descriptor information between

handles.

SQLGetDescField() Core 95 V5 Gets single field settings of a descriptor

record.

SQLGetDescRec() Core 95 V5 Gets multiple field settings of a descriptor

record.

SQLSetDescField() Core 95 V5 Sets a single field of a descriptor record.

SQLSetDescRec() Core 95 V5 Sets multiple field settings of a descriptor

record.

Large object support

SQLBindFileToCol() No No V2.1 Associates a LOB file reference with a LOB

column.

SQLBindFileToParam() No No V2.1 Associates a LOB file reference with a

parameter marker.

SQLGetLength() No SQL3 V2.1 Gets the length of a string referenced by a

LOB locator.

SQLGetPosition() No SQL3 V2.1 Gets the position of a string within a

source string referenced by a LOB locator.

SQLGetSubString() No SQL3 V2.1 Creates a new LOB locator that references

a substring within a source string. The

source string is also represented by a LOB

locator.

Obtaining information about the data source's system tables (catalog functions)

SQLColumns() Lvl 1 SQL3 V2.1

Returns the list of column names in

specified tables.

SQLExtendedProcedures() No No V9.7 Returns the list of procedure names stored

in a specific data source with additional

information.

SQLExtendedProcedureColumns() No No V9.7 Returns the list of input and output

parameters for the specified procedures

with additional information.

SQLForeignKeys() Lvl 2 SQL3 V2.1 Returns the list of column names that

comprise foreign keys, if they exist for a

specified table.

SQLPrimaryKeys() Lvl 1 SQL3 V2.1 Returns the list of column names that

comprise the primary key for a table.

SQLProcedureColumns() Lvl 2 No V2.1 Returns the list of input and output

parameters for the specified procedures.

SQLProcedures() Lvl 2 No V2.1 Returns the list of procedure names stored

in a specific data source.

SQLSpecialColumns() Core SQL3 V2.1

Returns information about the optimal set

of columns that uniquely identifies a row

in a specified table.

SQLStatistics() Core SQL3 V2.1

Returns statistics about a single table and

the list of indexes associated with the table.

CLI and ODBC function summary

Call Level Interface Guide and Reference Volume 2

Table 1. CLI Function list by category (continued)

Task

Function name

ODBC

3.0

SQL/

CLI

first version

supported Purpose

SQLTablePrivileges() Lvl 2 SQL3 V2.1 Returns a list of tables and the privileges

associated with each table.

SQLTables() Core SQL3 V2.1

Returns the list of table names stored in a

specific data source.

Terminating a statement

SQLFreeHandle() Core 95 V1.1 Frees handle resources.

SQLFreeStmt() Core 95 V1.1 Ends statement processing and closes the

associated cursor, discards pending results,

and, optionally, frees all resources

associated with the statement handle.

SQLCancel() Core 95 V1.1 Cancels an SQL statement.

SQLTransact() Depr No V1.1 Commits or rolls back a transaction.

SQLCloseCursor() Core 95 V5 Commits or rolls back a transaction.

Terminating a connection

SQLDisconnect() Core 95 V1.1 Closes the connection.

SQLEndTran() Core 95 V5 Ends the transaction of a connection.

SQLFreeConnect() Depr 95 V1.1 Releases the connection handle.

SQLFreeEnv() Depr 95 V1.1 Releases the environment handle.

Creating and dropping a database

SQLCreateDb() No No V9.7 Creates a database based on the specified

database name, code-set, and mode.

SQLDropDb() No No V9.7 Drops the specified database.

Note:

Runtime support for this function was also available in the DB2 Client Application Enabler for DOS

Version 1.2 product.

SQLBindParam() has been replaced by SQLBindParameter().

Depr in the ODBC column indicates that the function has been deprecated for ODBC.

The following limitations apply to ODBC functions:

v SQLSetScrollOptions() is supported for runtime use only, because it has been superseded by the

SQL_CURSOR_TYPE, SQL_CONCURRENCY, SQL_KEYSET_SIZE, and SQL_ROWSET_SIZE statement options.

v SQLDrivers() is implemented by the ODBC driver manager.

Unicode functions (CLI)

CLI Unicode functions accept Unicode string arguments in place of ANSI string

arguments. The Unicode string arguments must be in UCS-2 encoding

(native-endian format).

ODBC API functions have suffixes to indicate the format of their string arguments:

those that accept Unicode end in W, and those that accept ANSI have no suffix

CLI and ODBC function summary

Chapter 1. CLI and ODBC functions 5

v SQLTables

For unicode functions that take a string length as an argument, the length is

calculated as the number of SQL_WCHAR elements that are needed to store the

string. For unicode functions that return string data from the server, the returned

length of the string data is the number of SQL_WCHAR elements that are needed

to store the string. However, the length of data that can be a string or non-string is

calculated in number of bytes that are needed to store the data.

For example, the SQLGetInfoW() API takes the length as the number of bytes

while the SQLExecDirectW() function interprets the length as the number of

SQL_WCHAR elements. On Windows operating systems, where the UTF-16

extended character set is used, the single character SQL_WCHAR is equivalent to 2

SQL_C_CHAR elements. Each SQL_C_CHAR element has length of 2 bytes. The

CLI driver returns data from the result sets in either unicode or ANSI, depending

on the API called by the application and the data that are bound. If an application

binds data to a SQL_C_CHAR type, the CLI driver converts SQL_WCHAR data to

SQL_CHAR in the unicode function.

ANSI to Unicode function mappings

The syntax for a CLI Unicode function is the same as the syntax for its

corresponding ANSI function, except that SQL_CHAR parameters are defined as

SQL_WCHAR. Character buffers defined as SQLPOINTER in the ANSI syntax can

be defined as either SQL_CHAR or SQL_WCHAR in the unicode function.

SQLAllocConnect function (CLI) - Allocate connection handle

In ODBC 3.0, SQLAllocConnect() has been deprecated and replaced with

SQLAllocHandle().

Although this version of CLI continues to support SQLAllocConnect(), it is

recommended that you use SQLAllocHandle() in your CLI programs so that they

conform to the latest standards.

Migrating to the new function

The statement:

SQLAllocConnect(henv, &hdbc);

for example, would be rewritten using the new function as:

SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);

SQLAllocEnv function (CLI) - Allocate environment handle

In ODBC 3.0, SQLAllocEnv() has been deprecated and replaced with

SQLAllocHandle().

Although this version of CLI continues to support SQLAllocEnv(), use

SQLAllocHandle() in your CLI programs so that they conform to the latest

standards.

Unicode functions (CLI)

Chapter 1. CLI and ODBC functions 7

剩余606页未读，继续阅读

Alent7

粉丝: 0
资源: 4

DB2 CLI指南与参考：第二卷，创建数据库应用与函数详解

DB2 V9.5 - Call Level Interface Guide and Reference, Volume 2.pdf

DB2数据库C接口（CLI ODBC）说明文档

Java模板引擎Handlebars.java.zip

DB2安装包，下载地址？

java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver

ftp://public.dhe.ibm.com/ps/products/db2/fixes2/english-us/db2winia32v8/

. $HOME/.profile /istrpt/sqllib/bin/db2 -tvf $HOME/asmcrpt/asmcrpt_hourly_job.sql -l $HOME/asmcrpt/log/asmcrpt_hourly_job.log

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): gcs.duty.mapper.db2.DepartmentMapper.selectList

给我一个spring batch双数据源的例子，H2与DB2，并且在application.yml中 指定默认数据源为h2

FileNotFoundError: [Errno 2] No such file or directory: 'c4db2f9b7e4b422d14b6e038f0cdc3ecee239b55326e9181ee4520f9.jpg'

linux离线安装db2

DB2 V10.5DB2驱动包下载

if name == 'root' and secret == '123456': self.page.destroy() StudentManager(self.root) elif name in db2.keys(): mi = db2.get(name) for key in db2.keys(): if name == key and secret == mi: self.page.destroy() Studentonly(self.root, name)给这段代码加上注释

opencv3.10还能安装吗

在application.yml中配置db2数据源，并举例如何调用

linux环境连接db2数据库

DB2的发行版本有哪些？

如何用Hikari同时配置H2与db2数据库，请给我具体的application.yml配置内容

最新资源

给我一个spring batch双数据源的例子，H2与DB2，并且在application.yml中指定默认数据源为h2