达蒙教程（DM8 SQL程序设计.pdf）

【实例截图】

【核心代码】

目录
1 概述 .............................................................. 1
1.1 DMSQL 程序简介 ........................................................................................................................1
1.2 使用 DMSQL 程序的优点 .............................................................................................................1
1.3 一个简单的 DMSQL 程序示例 .....................................................................................................2
2 DMSQL 程序数据类型与操作符 ........................................... 4
2.1 常规数据类型 ..............................................................................................................................4
2.1.1 数值数据类型 .....................................................................................................................4
2.1.2 字符数据类型 ....................................................................................................................7
2.1.3 多媒体数据类型 ................................................................................................................8
2.1.4 日期时间数据类型 ............................................................................................................9
2.1.5 BOOL/BOOLEAN 数据类型 ............................................................................................12
2.2 %TYPE 和%ROWTYPE ................................................................................................................12
2.3 记录类型 ...................................................................................................................................14
2.4 数组类型 ...................................................................................................................................16
2.4.1 静态数组类型 ...................................................................................................................16
2.4.2 动态数组类型 ...................................................................................................................17
2.4.3 复杂类型数组 ...................................................................................................................19
2.5 集合类型 ...................................................................................................................................21
2.5.1 VARRAY ............................................................................................................................21
2.5.2 索引表 ...............................................................................................................................22
2.5.3 嵌套表 ...............................................................................................................................25
2.5.4 集合类型支持的方法 ........................................................................................................26
2.6 类类型 .......................................................................................................................................30
2.7 子类型 .......................................................................................................................................30
2.8 操作符 .......................................................................................................................................30
3 DMSQL 程序的定义、调用与删除 ......................................... 32
3.1 存储过程 ...................................................................................................................................32
III
DM8SQL 程序设计
3.2 存储函数 ...................................................................................................................................34
3.3 客户端 DMSQL 程序 .................................................................................................................37
3.4 参数 ...........................................................................................................................................38
3.5 变量 ...........................................................................................................................................40
3.6 使用 OR REPLACE 选项 ..........................................................................................................43
3.7 调用权限子句 ............................................................................................................................43
3.8 调用、重新编译与删除存储模块 ............................................................................................43
3.8.1 调用存储模块 ...................................................................................................................43
3.8.2 重新编译存储模块 ............................................................................................................45
3.8.3 删除存储模块 ...................................................................................................................45
4 DMSQL 程序中的各种控制结构 .......................................... 47
4.1 语句块 .......................................................................................................................................47
4.2 分支结构 ...................................................................................................................................49
4.2.1 IF 语句 ............................................................................................................................49
4.2.2 CASE 语句 .......................................................................................................................53
4.2.3 SWITCH 语句 ..................................................................................................................55
4.3 循环控制结构 ............................................................................................................................56
4.3.1 LOOP 语句 .......................................................................................................................56
4.3.2 WHILE 语句 .....................................................................................................................57
4.3.3 FOR 语句 .........................................................................................................................58
4.3.4 REPEAT 语句 ..................................................................................................................59
4.3.5 FORALL 语句 ..................................................................................................................60
4.3.6 EXIT 语句 .......................................................................................................................61
4.3.7 CONTINUE 语句 ..............................................................................................................64
4.4 顺序结构 ...................................................................................................................................66
4.4.1 GOTO 语句 .......................................................................................................................66
4.4.2 NULL 语句 .......................................................................................................................67
4.5 其他语句 ...................................................................................................................................68
4.5.1 赋值语句 ..........................................................................................................................68
4.5.2 调用语句 ..........................................................................................................................69
IV
DM8SQL 程序设计
4.5.3 RETURN 语句 ..................................................................................................................71
4.5.4 PRINT 语句 .....................................................................................................................71
4.5.5 PIPE ROW 语句 ..............................................................................................................72
5 DMSQL 程序中的 SQL 语句 ............................................. 74
5.1 普通静态 SQL 语句 ..................................................................................................................74
5.1.1 数据操纵 ..........................................................................................................................74
5.1.2 数据查询 ..........................................................................................................................75
5.1.3 事务控制 ..........................................................................................................................76
5.2 游标 ...........................................................................................................................................77
5.2.1 静态游标 ..........................................................................................................................77
5.2.2 动态游标 ..........................................................................................................................83
5.2.3 游标变量（引用游标）...................................................................................................85
5.2.4 使用游标更新、删除数据 ..............................................................................................86
5.2.5 使用游标 FOR 循环 .........................................................................................................87
5.3 动态 SQL ....................................................................................................................................89
5.4 返回查询结果集 ........................................................................................................................92
5.5 自治事务 ...................................................................................................................................93
5.5.1 定义自治事务 ..................................................................................................................93
5.5.2 自治事务完整性与死锁检测 ..........................................................................................94
5.5.3 自治事务嵌套 ..................................................................................................................95
6 DMSQL 程序异常处理 ................................................. 97
6.1 异常处理的优点 ........................................................................................................................97
6.2 预定义异常 ...............................................................................................................................97
6.3 用户自定义异常 ........................................................................................................................98
6.4 异常的抛出 .............................................................................................................................101
6.5 内置函数 SQLCODE 和 SQLERRM..........................................................................................102
6.6 异常处理部分 ..........................................................................................................................103
7 基于 C、JAVA 语法的 DMSQL 程序 ...................................... 107
7.1 C 语法 DMSQL 程序 ................................................................................................................107
7.2 JAVA 语法 DMSQL 程序 .........................................................................................................109
V
DM8SQL 程序设计
8 DMSQL 程序调试 ................................................... 112
8.1 使用命令行工具 DMDBG 调试 DMSQL 程序 ............................................................................112
8.1.1 dmdbg 工具命令简介 ...................................................................................................112
8.1.2 使用 dmdbg 工具 ..........................................................................................................113
8.2 使用图形化客户端工具 MANAGER 调试 DMSQL 程序 ............................................................125