深入學(xué)習(xí)-InformixDynamicServer2002高級編程技術(shù)

第1章  IDS 2000的業(yè)務(wù)優(yōu)勢                  
     邏輯演變                  
     關(guān)系式演變                  
     自定義演變                  
     IDS 2000特性                  
     更多的特性                  
     何謂DataBlade模塊                  
     性能                  
     硬件組件                  
     操作系統(tǒng)                  
     IDS 2000                  
     查詢的執(zhí)行                  
     性能優(yōu)勢                  
     性能優(yōu)勢小結(jié)                  
     其他優(yōu)勢                  
     IDS 2000的前景                  
   第2章  用戶定義過程                  
     進(jìn)程                  
     線程                  
     線程實(shí)現(xiàn)                  
     IDS2000的多線程處理                  
     動(dòng)態(tài)庫                  
     符號的可視性                  
     UDR限制                  
     違法的操作函數(shù)                  
     Create Function語句                  
     函數(shù)解析                  
     操作符重載                  
     內(nèi)部函數(shù)重載                  
     庫的裝載與卸載                  
     簡單例子                  
     MI—FPARAM變元                  
     內(nèi)存分配                  
     DataBlade開發(fā)工具庫(DBDK)                  
   第3章  SQL語句                  
     語法示意圖說明                  
     AGGREGATE                  
     CAST                  
     DISTINCT類型                  
     FUNCTION                  
     GRANT                  
     OPAQUE類型                  
     OPCLASS                  
     PROCEDURE                  
     ROW類型                  
     共享庫重新裝入                  
   第4章  處理數(shù)據(jù)類型                  
     環(huán)境說明                  
     MI DATUM                  
     BLOB                  
     BOOLEAN                  
     BYTE                  
     CHAR(n)(CHARACTER(n))                  
     CLOB                  
     DATE                  
     DATETIME                  
     DECIMAL(DEC)                  
     DISTINCT(獨(dú)特類型)                  
     DOUBLE PRECISION                  
     FLOAT(n)                  
     INTEGER或INT                  
     INT8                  
     INTERVAL                  
     LIST                  
     LVARCHAR                  
     MONEY                  
     MULTISET                  
     NCHAR(n)                  
     NU MERIC                  
     NVARCHAR                  
     Opague(非透明)                  
     BEAL                  
     ROW                  
     SERIAL                  
     SERIAL8                  
     SET                  
     SMALLINT                  
     SMALLFLOAT                  
     TEXT                  
     VARCHAR                  
   第5章  計(jì)算函數(shù)                  
     函數(shù)應(yīng)用程序                  
     函數(shù)并行性                  
     Quarter函數(shù)                  
     函數(shù)重載                  
     處理Null值                  
     返回NULL結(jié)果                  
     發(fā)出異常                  
     SQLSTATE                  
     mi—1varchar API函數(shù)                  
     內(nèi)存分配                  
     mi—get—vardata()                  
     mi—get—vardata—align()                  
     mi—get—varlen()                  
     mi一1varchar—to—string()                  
     mi—new—var()                  
     mi—set—vardata()                  
     mi—set—vardata—align()                  
     mi—set—varlen()                  
     mi—set—varptr()                  
     mi—string—to—lvarchar()                  
     mi—var—copy()                  
     mi—var—free()                  
     mi—var—to—buffer()                  
     mi—1varchar緩沖區(qū)長度                  
   第6章  用戶定義類型                  
     復(fù)雜類型                  
     行類型                  
     插入行類型                  
     行類型限制                  
     行類型索引                  
     行類型處理                  
     取得行類型名                  
     取得其他信息                  
     訪問行字段                  
     返回行                  
     執(zhí)行SQL語句                  
     集合類型                  
     集合類型限制                  
     集合類型索引                  
     集合類型處理                  
     光標(biāo)操作與編移量                  
     返回集合類型                  
     生成復(fù)雜類型                  
     MI—CONNECTION的使用                  
     獨(dú)特類型                  
   第7章  非透明型                  
     非透明型的作用                  
     非透明型的元素                  
     定長與變長非透明型                  
     輸入函數(shù)與輸出函數(shù)                  
     導(dǎo)入函數(shù)與導(dǎo)出函數(shù)                  
     發(fā)送函數(shù)與接收函數(shù)                  
     Importbinary和Exportbinary函數(shù)                  
     Compare函數(shù)                  
     比較函數(shù)                  
     Assign與Destroy函數(shù)                  
     數(shù)學(xué)函數(shù)                  
     B型樹函數(shù)                  
     R型樹函數(shù)                  
     Like和Matches函數(shù)                  
     其他函數(shù)                  
     Null值                  
   第8章  迭代函數(shù)                  
     DataBlade API元素                  
     遞減計(jì)數(shù)函數(shù)                  
     項(xiàng)目讀取函數(shù)                  
     SET—INIT部分                  
     SET—RETONE部分                  
     SET—END部分                  
     迭代的局限性                  
     局限性解決辦法                  
     SPL解決方案                  
     C語言方案                  
     SET—INIT部分                  
     SET—RETONE部分                  
     SET—END部分                  
     使用迭代函數(shù)進(jìn)行連接                  
   第9章  快捷路徑接口                  
     為什么使用快捷路徑接口                  
     快捷路徑函數(shù)                  
     使用系統(tǒng)校正功能                  
     校正舉例                  
     調(diào)用Informix函數(shù)                  
     調(diào)用另一用戶函數(shù)                  
     尋找函數(shù)信息                  
     查看＄INFORMIXDIR                  
     查看系統(tǒng)目錄                  
     使用用戶定義過程                  
   第10章  智能塊傳輸與多重表示                  
     智能大型對象                  
     智能大型對象的存放                  
     定義智能大型對象空間                  
     如何尋找sbspace                  
     生成表格                  
     插入智能大型對象                  
     大型對象的API函數(shù)                  
     大型對象結(jié)構(gòu)                  
     處理大型對象                  
     大型對象統(tǒng)計(jì)信息                  
     大型對象規(guī)范                  
     生成大型對象                  
     取得行規(guī)范                  
     非透明型與大型對象                  
     行上下文檢索                  
     lohandles()函數(shù)                  
     多重表示非透明型                  
     大型對象存儲(chǔ)規(guī)范注意事項(xiàng)                  
   第11章  累計(jì)函數(shù)                  
     IDS 2000累計(jì)函數(shù)                  
     累計(jì)函數(shù)的用法                  
     擴(kuò)展內(nèi)部累計(jì)函數(shù)                  
     累計(jì)函數(shù)如何工作                  
     用戶定義累計(jì)模型                  
     ＜STATE＞類型                  
     用戶自定義累計(jì)                  
     簡單例子：MYAVG()                  
     處理＜STATE＞變元                  
     前N個(gè)市場份額舉例                  
     其他累計(jì)功能的使用                  
   第12章  跟蹤與調(diào)試                  
     常見問題                  
     舊庫                  
     找不到符號                  
     數(shù)值或引用                  
     使用緩沖區(qū)                  
     使用mi—lvarchar和mi—bitvarying                  
     使用SPL                  
     測試腳本                  
     跟蹤                  
     調(diào)試                  
     Unix中的調(diào)試                  
     在Windows NT中調(diào)試                  
     共享內(nèi)存轉(zhuǎn)儲(chǔ)                  
   附錄  函數(shù)參考資料                  
     函數(shù)類別                  
     函數(shù)參考資料