达梦数据库程序员手册目录目录..................................

文件名称: 达梦数据库程序员手册

所属分类: 其它

开发工具:

文件大小: 2mb

下载次数: 0

上传时间: 2015-06-30

提供者: venu*****

下载 (2mb)

不能下载？报告错误

详细说明：目录目录........................................................................................................................... I 第1章概述............................................................................................................. 1 1.1 功能特性............................................................................................................................1 1.1.1 通用性.....................................................................................................................1 1.1.2 高性能............... ......................................................................................................2 1.1.3 高安全性.................................................................................................................4 1.1.4 高可靠、高可用性.................................................................................................5 1.1.5 易用性.....................................................................................................................6 1.1.6 对存储模块的支持.................................................................................................9 1.1.7 对Web应用的支持................................................................................................9 1.2 主要技术指标....................................................................................................................9 第2章DPI编程指南.............................................................................................11 2.1基础简介...........................................................................................................................11 2.2进阶...................................................................................................................................14 2.3函数原型...........................................................................................................................20 2.4编程参考...........................................................................................................................69 2.5数据捕获...........................................................................................................................99 2.5.1数据类型..............................................................................................................100 2.5.2相关方法..............................................................................................................100 2.5.3数据信息搜集表..................................................................................................102 2.5.4举例说明..............................................................................................................103 第3章DMODBC编程指南................................................................................106 3.1 数据类型........................................................................................................................106 3.2 支持的函数....................................................................................................................107 3.2.1 连接到数据源.....................................................................................................108 3.2.2 获取驱动程序和数据源信息.............................................................................108 3.2.3 设置或者获取驱动程序属性.............................................................................108 3.2.4 设置或者获取描述符字段.................................................................................109 3.2.5 准备SQL语句...................................................................................................109 3.2.6 提交SQL请求...................................................................................................109 3.2.7 检索结果集及其相关信息.................................................................................109 3.2.8 取得数据源系统表的信息.................................................................................110 3.2.9 终止语句执行.....................................................................................................110 3.2.10 中断连接...........................................................................................................110 3.3 建立ODBC连接........................................................................................................... 111 3.3.1 申请环境与连接句柄......................................................................................... 111 3.3.2 如何与数据源进行连接..................................................................................... 111 3.3.3 设置与取得连接的属性.....................................................................................114 3.3.4 断开与数据源之间的连接.................................................................................114 3.4 ODBC应用程序编程的基本步骤.................................................................................116 目录 II 3.4.1 Windows上创建ODBC数据源.........................................................................116 3.4.2 Linux上创建ODBC资源..................................................................................119 3.4.3 ODBC应用程序编写的基本步骤......................................................................121 3.5 使用存储过程和函数....................................................................................................124 3.5.1 存储过程与函数字典信息的获取.....................................................................124 3.5.2 存储模块的创建.................................................................................................125 3.5.3 存储模块的调用.................................................................................................125 第4章OLEDB编程指南....................................................................................128 4.1 DM OLEDB支持的数据类型.......................................................................................128 4.2 提供的SchemaRowset对象.........................................................................................128 4.2.1 CATALOGS .........................................................................................................129 4.2.2 STATISTICS ........................................................................................................129 4.2.3 PROVIDER_TYPES............................................................................................129 4.2.4 SCHEMATA ........................................................................................................130 4.2.5 COLUMNS ..........................................................................................................130 4.2.6 TABLES...............................................................................................................131 4.2.7 PROCEDURES....................................................................................................132 4.2.8 PROCEDURES_COLUMNS ..............................................................................132 4.2.9 VIEWS.................................................................................................................133 4.2.10 CHECK_CONSTRAINTS.................................................................................133 4.2.11 CHECK_CONSTRAINTS_BY_TABLE...........................................................133 4.2.12 PRIMARY_KEYS .............................................................................................134 4.2.13 COLUMN_PRIVILEGES..................................................................................134 4.2.14 TABLE_PRIVILEGES ......................................................................................135 4.2.15 PROCEDURE_PARAMETERS ........................................................................135 4.2.16 TABLES_INFO..................................................................................................136 4.2.17 INDEXES...........................................................................................................136 4.2.18 FOREIGN_KEYS..............................................................................................137 4.2.19 TABLE_CONSTRAINTS..................................................................................138 4.3 提供的对象和接口........................................................................................................138 4.3.1 Data Source对象.................................................................................................138 4.3.2 Session对象........................................................................................................140 4.3.3 Command对象....................................................................................................144 4.3.4 Rowset对象.........................................................................................................148 4.4 使用OLEDB编程基本步骤........................................................................................151 4.4.1 建立与数据源的连接.........................................................................................151 4.4.2 使用OLEDB执行命令......................................................................................152 4.4.3 使用OLEDB结果处理......................................................................................153 4.4.4 例程.....................................................................................................................153 第5章DM JDBC编程指南................................................................................165 5.1 JDBC介绍......................................................................................................................165 5.2 JDBC基本示例..............................................................................................................165 5.3 DM JDBC特性..............................................................................................................173 5.4 DM JDBC扩展..............................................................................................................174 目录 III 5.5 建立JDBC连接............................................................................................................175 5.5.1 通过DriverManager建立连接..........................................................................175 5.5.2 创建JDBC数据源.............................................................................................176 5.5.3 数据源与连接池.................................................................................................178 5.5.4 DM扩展链接属性的使用..................................................................................178 5.6 Statement/Prepare Statement/Callable Statement ...........................................................180 5.6.1 Statement..............................................................................................................180 5.6.2 PreparedStatement................................................................................................181 5.6.3 CallableStatement.................................................................................................183 5.7 ResultSet .........................................................................................................................186 5.8 流与大对象....................................................................................................................188 5.8.1 Stream使用.........................................................................................................188 5.8.2 LOB对象使用.....................................................................................................190 5.9 元数据............................................................................................................................191 5.9.1 ResultSetMetaData...............................................................................................191 5.9.2 DatabaseMetaData ...............................................................................................192 5.9.3 ParameterMetaData..............................................................................................192 5.10 RowSet..........................................................................................................................193 5.10.1 CachedRowSet ...................................................................................................193 5.10.2 JdbcRowSet........................................................................................................194 5.11 分布式事务支持..........................................................................................................195 5.11.1 XADataSource ...................................................................................................195 5.11.2 XAConnection....................................................................................................196 5.11.3 XAResource .......................................................................................................196 5.11.4 Xid......................................................................................................................197 5.11.5 实例解析...........................................................................................................198 第6章PRO*C编程指南.....................................................................................200 6.1 嵌入工作方式简介........................................................................................................200 6.1.1 概述.....................................................................................................................200 6.1.2 预编译系统的结构与功能.................................................................................200 6.1.3 预编译系统配置.................................................................................................202 6.2 嵌入式程序的组成........................................................................................................204 6.2.1 一个简单的嵌入式程序结构分析.....................................................................204 6.2.2 宿主变量的定义.................................................................................................205 6.2.3 可执行的SQL 语句..........................................................................................208 6.2.4 嵌入式程序中的异常处理.................................................................................209 6.3 ORACLE兼容................................................................................................................213 6.3.1 简单的ORACLE 嵌入式程序结构分析..........................................................213 6.3.2 SQLDA/SQLCA..................................................................................................218 6.3.3 宿主变量定义.....................................................................................................220 6.3.4 可执行的SQL语句...........................................................................................221 6.3.5 异常处理.............................................................................................................221 6.4 DB2兼容........................................................................................................................221 6.4.1 简单的DB2嵌入式程序结构分析...................................................................221 目录 IV 6.4.2 SQLDA/SQLCA..................................................................................................223 6.4.3 宿主变量定义.....................................................................................................223 6.4.4 可执行的SQL语句...........................................................................................224 6.4.5 异常处理.............................................................................................................224 6.5 SSL参数配置.................................................................................................................224 6.6大字段LOB....................................................................................................................225 6.7语句块.............................................................................................................................227 6.8游标变量.........................................................................................................................228 6.9批量执行.........................................................................................................................230 6.10程序实例.......................................................................................................................232 6.10.1 SELECT语句....................................................................................................232 6.10.2 插入、更新、删除语句...................................................................................233 6.10.3 游标查询...........................................................................................................236 6.10.4 提交与回滚.......................................................................................................237 6.10.5 动态SQL语句.................................................................................................237 6.10.6 日期、时间数据类型的使用...........................................................................241 第7章.NET Data Provider编程指南..................................................................244 7.1 数据类型........................................................................................................................244 7.2 提供的对象和接口........................................................................................................244 7.2.1 DmConnection对象............................................................................................244 7.2.2 DmCommand对象..............................................................................................245 7.2.3 DmDataAdapter对象..........................................................................................246 7.2.4 DmDataReader对象............................................................................................246 7.2.5 DmParameter对象...............................................................................................247 7.2.6 DmParameterCollection对象..............................................................................247 7.2.7 DmTransaction对象............................................................................................248 7.2.8 DmCommandBuilder对象..................................................................................248 7.2.9 DmConnectionStringBuilder对象.......................................................................249 7.2.10 DmClob对象.....................................................................................................249 7.2.11 DmBlob对象.....................................................................................................249 7.3 .NET Data Provider基本示例........................................................................................250 7.4 对象使用........................................................................................................................251 7.4.1 连接.....................................................................................................................251 7.4.2 查询与结果集.....................................................................................................251 7.4.3 插入、更新、删除.............................................................................................252 7.4.4 大对象.................................................................................................................254 7.4.5 自增列.................................................................................................................255 7.4.6 存储过程与函数.................................................................................................255 第8章DM PHP编程指南...................................................................................258 8.1 DM PHP介绍.................................................................................................................258 8.2 基本示例........................................................................................................................259 8.3 DM PHP模块加载.........................................................................................................262 8.4 编程接口........................................................................................................................264 第9章DM DCI编程指南...................................................................................274 目录 V 9.1 DM DCI介绍.................................................................................................................274 9.2 数据类型........................................................................................................................274 9.3 参考函数........................................................................................................................275 9.3.1关系型接口函数..................................................................................................275 9.4 使用DM DCI编程基本步骤.......................................................................................311 第10章DM FLDR编程指南..............................................................................318 10.1 DM FLDR接口介绍....................................................................................................318 10.2 DM FLDR接口说明....................................................................................................318 10.2.1 返回值说明.......................................................................................................318 10.2.2 接口说明...........................................................................................................318 10.3编程实例.......................................................................................................................325 第11章DM FLDR JNI编程指南........................................................................327 11.1 DM FLDR JNI接口介绍.............................................................................................327 11.2接口说明.......................................................................................................................327 11.3 DM FLDR JNI编程实例.............................................................................................331 第12章DM加密引擎接口编程指南..................................................................336 12.1 概述..............................................................................................................................336 12.2 编程接口说明..............................................................................................................336 12.2.1 算法信息相关接口...........................................................................................336 12.2.2加密过程相关接口............................................................................................337 12.2.3解密过程相关接口............................................................................................339 12.2.4散列过程相关接口............................................................................................340 12.2.5其它可选相关接口............................................................................................342 12.3接口库文件说明...........................................................................................................345 12.4编程实例.......................................................................................................................345 第13章Logmnr接口使用说明...........................................................................363 13.1 JNI 接口.......................................................................................................................363 13.1.1 接口说明...........................................................................................................363 13.1.2 LogmnrRecord对象说明..................................................................................367 13.1.3编程实例............................................................................................................368 13.2 C接口...........................................................................................................................368 13.2.1接口说明............................................................................................................368 附录1 错误码汇编...............................................................................................376 1 DM服务器错误代码汇编................................................................................................376 2 DPI错误码汇编................................................................................................................435 3 PROC错误码汇编............................................................................................................438 附录2 DM技术支持.............................................................................................439 ...展开收缩

(系统自动生成,下载前可以参看下载内容)