深入學習-InformixDynamicServer2002高級編程技術

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