DM8SQL 程序设计
IV
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
