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

前言                  
                   
 第一章  安裝指南                  
                   
 1.1  安裝準(zhǔn)備                  
 1.2  安裝數(shù)據(jù)庫服務(wù)器                  
 1.2.1  運(yùn)行數(shù)據(jù)庫服務(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ù)庫服務(wù)器                  
 1.3  Informix菜單                  
 1.4  啟動(dòng)和停止數(shù)據(jù)庫服務(wù)器                  
 1.4.1  啟動(dòng)數(shù)據(jù)庫服務(wù)器                  
 1.4.2  停止數(shù)據(jù)庫服務(wù)器                  
 1.5  卸載. 重新安裝數(shù)據(jù)庫服務(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)化查詢語言                  
                   
 2.1  Informix SQL                  
 2.2  SELECT語句介紹                  
 2.2.1  基本概念                  
 2.2.2  特殊數(shù)據(jù)類型                  
 2.3  單表查詢語句                  
 2.3.1  查詢所有的行和列                  
 2.3.2  選擇特定的列                  
 2.3.3  使用WHERE子句                  
 2.3.4  使用FIRST子句選擇特定行                  
 2.3.5  表達(dá)式和求值                  
 2.3.6  在SELECT語句中使用函數(shù)                  
 2.4  多表查詢語句                  
 2.4.1  笛卡兒乘積                  
 2.4.2  創(chuàng)建連接                  
 2.4.3  其他簡潔查詢方式                  
 2.5  對(duì)其他數(shù)據(jù)庫中的表進(jìn)行查詢                  
 2.6  構(gòu)造高級(jí)查詢語句                  
 2.6.1  使用GROUP BY和HAVING子句                  
 2.6.2  創(chuàng)建高級(jí)連接                  
 2.6.3  子查詢語句                  
 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ù)庫的訪問權(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ù)庫服務(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語句                  
 3.5.1  語句預(yù)處理                  
 3.5.2  執(zhí)行預(yù)處理過的SQL語句                  
 3.5.3  動(dòng)態(tài)主變量                  
 3.5.4  釋放預(yù)處理語句                  
 3.5.5  快速執(zhí)行動(dòng)態(tài)SQL語句                  
 3.6  修改權(quán)限語句                  
 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語言和觸發(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ù)庫服務(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ù)庫服務(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ù)庫空間                  
 5.5.2  鏡像數(shù)據(jù)庫空間                  
 5.5.3  備份和恢復(fù)數(shù)據(jù)                  
 5.5.4  導(dǎo)出和引入數(shù)據(jù)庫                  
 5.5.5  加載和卸載表                  
 5.6  數(shù)據(jù)庫對(duì)象管理                  
 5.6.1  數(shù)據(jù)庫管理                  
 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語句管理                  
 5.8.1  創(chuàng)建. 修改. 執(zhí)行SQL語句                  
 5.8.2  查看執(zhí)行結(jié)果                  
 5.8.3  SQL編輯器數(shù)據(jù)的保存                  
 5.8.4  IECC支持的SQL語句                  
                   
 第六章 DB-Access應(yīng)用工具                  
                   
 6.1  DB-Access基本操作                  
 6.1.1  運(yùn)行DB-Access                  
 6.1.2  DB-Access基本操作                  
 6.2  SQL語句管理                  
 6.2.1  SQL子菜單                  
 6.2.2  SPL語言和內(nèi)部存儲(chǔ)過程                  
 6.3  數(shù)據(jù)管理                  
 6.3.1  選擇當(dāng)前數(shù)據(jù)庫                  
 6.3.2  創(chuàng)建數(shù)據(jù)庫                  
 6.3.3  查看數(shù)據(jù)庫信息和刪除數(shù)據(jù)庫                  
 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)境. 連接和語句句柄                  
 7.2.3  數(shù)據(jù)類型                  
 7.2.4  函數(shù)返回值                  
 7.2.5  使用INFORMIX-CLIAPI                  
 7.3  連接到數(shù)據(jù)源                  
 7.4  執(zhí)行SQL語句                  
 7.4.1  執(zhí)行SQL語句                  
 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í)行語句                  
 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ù)測試. 處理函數(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語句處理異常                  
 8.7.2  識(shí)別SQLSATE                  
 8.7.3  使用sqlca結(jié)構(gòu)處理異常                  
 8.8  和數(shù)據(jù)庫服務(wù)器協(xié)調(diào)工作                  
 8.9  動(dòng)態(tài)SQL語句                  
 8.9.1  游標(biāo)的使用                  
                   
 附錄 一 INFORMIX錯(cuò)誤信息                  
                   
 附錄 二 SQL. SPL語法結(jié)構(gòu)