INFORMIX關(guān)系數(shù)據(jù)庫(kù)系統(tǒng)管理與軟件設(shè)計(jì)

前言                  
                   
 第一章  安裝指南                  
                   
 1.1  安裝準(zhǔn)備                  
 1.2  安裝數(shù)據(jù)庫(kù)服務(wù)器                  
 1.2.1  運(yùn)行數(shù)據(jù)庫(kù)服務(wù)器安裝程序                  
 1.2.2  軟件升級(jí)和重新安裝                  
 1.2.3  歡迎界面                  
 1.2.4  用戶信息界面                  
 1.2.5  建立安裝路徑                  
 1.2.6  主界面                  
 1.2.7  選擇安裝選項(xiàng)                  
 1.2.8  管理任務(wù)的分配                  
 1.2.9  復(fù)制文件                  
 1.2.10  配置數(shù)據(jù)庫(kù)服務(wù)器                  
 1.3  Informix菜單                  
 1.4  啟動(dòng)和停止數(shù)據(jù)庫(kù)服務(wù)器                  
 1.4.1  啟動(dòng)數(shù)據(jù)庫(kù)服務(wù)器                  
 1.4.2  停止數(shù)據(jù)庫(kù)服務(wù)器                  
 1.5  卸載. 重新安裝數(shù)據(jù)庫(kù)服務(wù)器                  
 1.6  自動(dòng)安裝                  
 1.6.1  記錄模式Record Mode                  
 1.6.2  重放模式Playback Mode                  
 1.7  重放文件必需的參數(shù)                  
 1.7.1  Bundle-Common部分                  
 1.7.2  Server Install部分                  
 1.7.3  Server Instance部分                  
                   
 第二章 結(jié)構(gòu)化查詢語(yǔ)言                  
                   
 2.1  Informix SQL                  
 2.2  SELECT語(yǔ)句介紹                  
 2.2.1  基本概念                  
 2.2.2  特殊數(shù)據(jù)類型                  
 2.3  單表查詢語(yǔ)句                  
 2.3.1  查詢所有的行和列                  
 2.3.2  選擇特定的列                  
 2.3.3  使用WHERE子句                  
 2.3.4  使用FIRST子句選擇特定行                  
 2.3.5  表達(dá)式和求值                  
 2.3.6  在SELECT語(yǔ)句中使用函數(shù)                  
 2.4  多表查詢語(yǔ)句                  
 2.4.1  笛卡兒乘積                  
 2.4.2  創(chuàng)建連接                  
 2.4.3  其他簡(jiǎn)潔查詢方式                  
 2.5  對(duì)其他數(shù)據(jù)庫(kù)中的表進(jìn)行查詢                  
 2.6  構(gòu)造高級(jí)查詢語(yǔ)句                  
 2.6.1  使用GROUP BY和HAVING子句                  
 2.6.2  創(chuàng)建高級(jí)連接                  
 2.6.3  子查詢語(yǔ)句                  
 2.6.4  集合運(yùn)算                  
 2.7  數(shù)據(jù)更新                  
 2.7.1  刪除表中的所有行                  
 2.7.2  插入行                  
 2.7.3  修改數(shù)據(jù)                  
 2.7.4  數(shù)據(jù)庫(kù)的訪問權(quán)限                  
 2.7.5  數(shù)據(jù)完整性                  
 2.7.6  數(shù)據(jù)備份和事務(wù)日志                  
 2.7.7  并發(fā)控制和加鎖                  
                   
 第三章 程序設(shè)計(jì)方法                  
                   
 3.1  程序變量和主變量                  
 3.2  調(diào)用數(shù)據(jù)庫(kù)服務(wù)器                  
 3.2.1  SQL通信區(qū)                  
 3.2.2  SQLCODE的數(shù)據(jù)域                  
 3.2.3  SQLSTATE值                  
 3.3  返回單行數(shù)據(jù)                  
 3.4  多行查詢                  
 3.4.1  打開游標(biāo)                  
 3.4.2  獲取記錄                  
 3.4.3  游標(biāo)活動(dòng)集                  
 3.5  動(dòng)態(tài)SQL語(yǔ)句                  
 3.5.1  語(yǔ)句預(yù)處理                  
 3.5.2  執(zhí)行預(yù)處理過的SQL語(yǔ)句                  
 3.5.3  動(dòng)態(tài)主變量                  
 3.5.4  釋放預(yù)處理語(yǔ)句                  
 3.5.5  快速執(zhí)行動(dòng)態(tài)SQL語(yǔ)句                  
 3.6  修改權(quán)限語(yǔ)句                  
 3.7  通過SQL程序修改數(shù)據(jù)                  
 3.7.1  使用DELETE                  
 3.7.2  使用INSERT                  
 3.7.3  使用UPDATE                  
 3.8  數(shù)據(jù)共享與并發(fā)控制                  
 3.8.1  并發(fā)控制                  
 3.8.2  數(shù)據(jù)加鎖                  
 3.8.3  隔離級(jí)別                  
 3.8.4  設(shè)置鎖定模式                  
                   
 第四章 SPL語(yǔ)言和觸發(fā)器                  
                   
 4.1  SQL和內(nèi)部存儲(chǔ)過程                  
 4.1.1  創(chuàng)建內(nèi)部存儲(chǔ)過程                  
 4.1.2  運(yùn)行內(nèi)部存儲(chǔ)過程                  
 4.2  內(nèi)部存儲(chǔ)過程權(quán)限                  
 4.3  變量和表達(dá)式                  
 4.4  程序流程控制                  
 4.5  異常處理                  
 4.6  觸發(fā)器                  
 4.6.1  創(chuàng)建觸發(fā)器                  
 4.6.2  觸發(fā)器操作                  
 4.6.3  跟蹤觸發(fā)器操作                  
                   
 第五章  使用IECC管理數(shù)據(jù)庫(kù)服務(wù)器                  
                   
 5.1  安裝IECC                  
 5.1.1  系統(tǒng)要求                  
 5.1.2  IECC產(chǎn)品                  
 5.1.3  安裝順序                  
 5.1.4  修改環(huán)境變量                  
 5.1.5  卸載IECC                  
 5.1.6  IECC備份和恢復(fù)BAR                  
 5.2  啟動(dòng)IECC                  
 5.2.1  運(yùn)行IECC                  
 5.2.2  配置IECC                  
 5.3  數(shù)據(jù)庫(kù)服務(wù)器管理                  
 5.3.1  觀察. 修改服務(wù)器運(yùn)行模式                  
 5.3.2  觀察服務(wù)器屬性                  
 5.3.3  監(jiān)視用戶會(huì)話                  
 5.3.4  生成報(bào)表                  
 5.4  異常事件管理                  
 5.5  數(shù)據(jù)和存儲(chǔ)空間管理                  
 5.5.1  管理數(shù)據(jù)庫(kù)空間                  
 5.5.2  鏡像數(shù)據(jù)庫(kù)空間                  
 5.5.3  備份和恢復(fù)數(shù)據(jù)                  
 5.5.4  導(dǎo)出和引入數(shù)據(jù)庫(kù)                  
 5.5.5  加載和卸載表                  
 5.6  數(shù)據(jù)庫(kù)對(duì)象管理                  
 5.6.1  數(shù)據(jù)庫(kù)管理                  
 5.6.2  同義詞管理                  
 5.6.3  管理內(nèi)部存儲(chǔ)過程. 視圖和觸發(fā)器                  
 5.7  表的管理                  
 5.7.1  表中列的管理                  
 5.7.2  索引管理                  
 5.7.3  外碼管理                  
 5.7.4  管理限制                  
 5.8  SQL語(yǔ)句管理                  
 5.8.1  創(chuàng)建. 修改. 執(zhí)行SQL語(yǔ)句                  
 5.8.2  查看執(zhí)行結(jié)果                  
 5.8.3  SQL編輯器數(shù)據(jù)的保存                  
 5.8.4  IECC支持的SQL語(yǔ)句                  
                   
 第六章 DB-Access應(yīng)用工具                  
                   
 6.1  DB-Access基本操作                  
 6.1.1  運(yùn)行DB-Access                  
 6.1.2  DB-Access基本操作                  
 6.2  SQL語(yǔ)句管理                  
 6.2.1  SQL子菜單                  
 6.2.2  SPL語(yǔ)言和內(nèi)部存儲(chǔ)過程                  
 6.3  數(shù)據(jù)管理                  
 6.3.1  選擇當(dāng)前數(shù)據(jù)庫(kù)                  
 6.3.2  創(chuàng)建數(shù)據(jù)庫(kù)                  
 6.3.3  查看數(shù)據(jù)庫(kù)信息和刪除數(shù)據(jù)庫(kù)                  
 6.4  表的管理                  
 6.4.1  創(chuàng)建. 修改表                  
 6.4.2  查看表的信息                  
 6.4.3  刪除表                  
 6.5  連接和會(huì)話                  
 6.5.1  連接                  
 6.5.2  會(huì)話信息                  
                   
 第七章  INFORMIX-CLI編程                  
                   
 7.1  配置數(shù)據(jù)源                  
 7.2  基本概念                  
 7.2.1  緩沖區(qū)                  
 7.2.2  環(huán)境. 連接和語(yǔ)句句柄                  
 7.2.3  數(shù)據(jù)類型                  
 7.2.4  函數(shù)返回值                  
 7.2.5  使用INFORMIX-CLIAPI                  
 7.3  連接到數(shù)據(jù)源                  
 7.4  執(zhí)行SQL語(yǔ)句                  
 7.4.1  執(zhí)行SQL語(yǔ)句                  
 7.4.2  事務(wù)處理                  
 7.5  獲得返回結(jié)果                  
 7.5.1  給結(jié)果指定存儲(chǔ)空間                  
 7.5.2  獲取結(jié)果數(shù)據(jù)                  
 7.6  函數(shù)返回值和錯(cuò)誤信息                  
 7.7  釋放句柄和斷開連接                  
 7.8  使用INFORMIX-CLI創(chuàng)建應(yīng)用程序例子                  
 7.9  應(yīng)用程序性優(yōu)化                  
 7.9.1  連接優(yōu)化                  
 7.9.2  獲取數(shù)據(jù)源信息                  
 7.9.3  字典函數(shù)的使用                  
 7.9.4  獲取數(shù)據(jù)                  
 7.9.5  執(zhí)行語(yǔ)句                  
 7.9.6  數(shù)據(jù)更新                  
 7.9.7  提交數(shù)據(jù)                  
 7.10  VISUAL C++程序設(shè)計(jì)                  
 7.10.1  構(gòu)造對(duì)象                  
 7.10.2  使用Visual C++向?qū)?chuàng)建ODBC應(yīng)用程序                  
 7.11  INFOTMIX-CLI函數(shù)介紹                  
 7.11.1  規(guī)則說明                  
 7.11.2  函數(shù)說明                  
                   
 第八章  INFORMIX-ESQL/C編程                  
                   
 8.1  使用INFORMIX-ESQL/C編程                  
 8.1.1  INFORMIX-CLI頭文件                  
 8.1.2  定義. 使用主變量                  
 8.1.3  使用ESQL命令                  
 8.2  ESQL/C數(shù)據(jù)類型                  
 8.2.1  選擇主變量的數(shù)據(jù)類型                  
 8.2.2  數(shù)據(jù)轉(zhuǎn)換                  
 8.2.3  數(shù)據(jù)測(cè)試. 處理函數(shù)                  
 8.3  字符. 字符串?dāng)?shù)據(jù)處理                  
 8.4  SQL DECIMAL數(shù)據(jù)類型                  
 8.5  數(shù)值處理                  
 8.6  日期. 時(shí)間處理                  
 8.7  異常處理                  
 8.7.1  使用SQLSATE和GET DIAGNOSTICS語(yǔ)句處理異常                  
 8.7.2  識(shí)別SQLSATE                  
 8.7.3  使用sqlca結(jié)構(gòu)處理異常                  
 8.8  和數(shù)據(jù)庫(kù)服務(wù)器協(xié)調(diào)工作                  
 8.9  動(dòng)態(tài)SQL語(yǔ)句                  
 8.9.1  游標(biāo)的使用                  
                   
 附錄 一 INFORMIX錯(cuò)誤信息                  
                   
 附錄 二 SQL. SPL語(yǔ)法結(jié)構(gòu)