版次注意事項


應用程式開發

部份目錄

  • Administrative API Reference (無中文版)
  • |33.1 db2ArchiveLog (new API)
  • |db2ArchiveLog
  • 33.2 db2ConvMonStream
  • 33.3 db2DatabasePing (new API)
  • db2DatabasePing - Ping Database
  • |33.4 db2HistData
  • |33.5 db2HistoryOpenScan
  • 33.6 db2XaGetInfo (new API)
  • db2XaGetInfo - Get Information for Resource Manager
  • 33.7 db2XaListIndTrans (new API that supercedes sqlxphqr)
  • db2XaListIndTrans - List Indoubt Transactions
  • |33.8 db2GetSnapshot - Get Snapshot
  • |33.9 Forget Log Record
  • 33.10 sqlaintp - Get Error Message
  • |33.11 sqlbctcq - Close Tablespace Container Query
  • |33.12 sqlubkp - Backup Database
  • |33.13 sqlureot - Reorganize Table
  • |33.14 sqlurestore - Restore Database
  • 33.15 Documentation Error Regarding AIX Extended Shared Memory Support (EXTSHM)
  • 33.16 SQLFUPD
  • |33.16.1 locklist
  • |33.17 SQLEDBDESC
  • |33.18 SQLFUPD Documentation Error
  • 應用程式開發手冊
  • 34.1 第 1 章 簡介
  • 34.1.1 支援軟體
  • 34.1.2 範例程式
  • 34.2 第 3 章 開發 DB2 應用程式的一般資訊
  • 34.2.1 開發檔案、make 檔和錯誤檢查的公用程式
  • 34.3 第 4 章 開發 Java Applets 和應用程式
  • 34.3.1 設定環境
  • 34.3.1.1 OS/2 上的 JDK 層次
  • |34.3.1.2 HP-UX 上的 Java2
  • 34.4 第 5 章 開發 SQL 程序
  • 34.4.1 設定 SQL 程序環境
  • 34.4.2 設定編譯器環境變數
  • 34.4.3 自訂編譯指令
  • 34.4.4 保留中間檔
  • 34.4.5 備份和復置
  • 34.4.6 建立 SQL 程序
  • 34.4.7 呼叫儲存程序
  • |34.4.8 分送已編譯的 SQL 程序
  • 34.5 第 7 章 開發 HP-UX 應用程式
  • 34.5.1 HP-UX C
  • 34.5.2 HP-UX C++
  • 34.6 第 9 章 開發 OS/2 應用程式
  • 34.6.1 VisualAge C++ for OS/2 版本 4.0
  • 34.7 第 10 章 開發 PTX 應用程式
  • 34.7.1 ptx/C++
  • 34.8 第 12 章 開發 Solaris 應用程式
  • 34.8.1 SPARCompiler C++
  • 34.9 第 13 章 建置 Windows 32 位元作業系統的應用程式
  • 34.9.1 VisualAge C++ 版本 4.0
  • Application Development Guide(無中文版)
  • 35.1 Chapter 2. Coding a DB2 Application
  • 35.1.1 Activating the IBM DB2 Universal Database Project and Tool Add-ins for Microsoft Visual C++
  • 35.2 Chapter 6. Common DB2 Application Techniques
  • |35.2.1 Generating Sequential Values
  • |35.2.1.1 Controlling Sequence Behavior
  • |35.2.1.2 Improving Performance with Sequence Objects
  • |35.2.1.3 Comparing Sequence Objects and Identity Columns
  • 35.3 Chapter 7. Stored Procedures
  • |35.3.1 DECIMAL Type Fails in Linux Java Routines
  • |35.3.2 Using Cursors in Recursive Stored Procedures
  • 35.3.3 Writing OLE Automation Stored Procedures
  • 35.4 Chapter 12. Working with Complex Objects: User-Defined Structured Types
  • 35.4.1 Inserting Structured Type Attributes Into Columns
  • 35.5 Chapter 13. Using Large Objects (LOBs)
  • |35.5.1 Large object (LOBs) support in federated database systems
  • |35.5.1.1 How DB2 retrieves LOBs
  • |35.5.1.2 How applications can use LOB locators
  • |35.5.1.3 Restrictions on LOBs
  • |35.5.1.4 Mappings between LOB and non-LOB data types
  • 35.5.2 Tuning the system
  • 35.6 Part 5. DB2 Programming Considerations
  • 35.6.1 IBM DB2 OLE DB Provider
  • 35.7 Chapter 20. Programming in C and C++
  • 35.7.1 C/C++ Types for Stored Procedures, Functions, and Methods
  • 35.8 Chapter 21. Programming in Java
  • 35.8.1 Java Method Signature in PARAMETER STYLE JAVA Procedures and Functions
  • |35.8.2 Connecting to the JDBC Applet Server
  • 35.9 Appendix B. Sample Programs
  • CLI Guide and Reference(無中文版)
  • 36.1 Binding Database Utilities Using the Run-Time Client
  • 36.2 Using Static SQL in CLI Applications
  • 36.3 Limitations of JDBC/ODBC/CLI Static Profiling
  • 36.4 ADT Transforms
  • |36.5 Chapter 3. Using Advanced Features
  • |36.5.1 Writing Multi-Threaded Applications
  • |36.5.2 Scrollable Cursors
  • |36.5.2.1 Server-side Scrollable Cursor Support for OS/390
  • |36.5.3 Using Compound SQL
  • |36.5.4 Using Stored Procedures
  • |36.5.4.1 Writing a Stored Procedure in CLI
  • |36.5.4.2 CLI Stored Procedures and Autobinding
  • |36.6 Chapter 4. Configuring CLI/ODBC and Running Sample Applications
  • |36.6.1 Configuration Keywords
  • 36.7 Chapter 5. DB2 CLI Functions
  • 36.7.1 SQLBindFileToParam - Bind LOB File Reference to LOB Parameter
  • |36.7.2 SQLNextResult - Associate Next Result Set with Another Statement Handle
  • |36.7.2.1 Purpose
  • |36.7.2.2 Syntax
  • |36.7.2.3 Function Arguments
  • |36.7.2.4 Usage
  • |36.7.2.5 Return Codes
  • |36.7.2.6 Diagnostics
  • |36.7.2.7 Restrictions
  • |36.7.2.8 References
  • 36.8 Appendix D. Extended Scalar Functions
  • 36.8.1 Date and Time Functions
  • 36.9 Appendix K. Using the DB2 CLI/ODBC/JDBC Trace Facility
  • 訊息參考手冊
  • |37.1 取得訊息與 SQLSTATE 說明
  • |37.2 在 DB2 Connect 變更的 SQLCODE 重新對映
  • 37.3 新的與變更的訊息
  • 37.3.1 呼叫層次介面 (CLI) 訊息
  • 37.3.2 DB2 訊息
  • 37.3.3 DBI 訊息
  • 37.3.4 資料倉儲中心 (DWC) 訊息
  • 37.3.5 SQL 訊息
  • 37.4 更正 SQLSTATES
  • SQL Reference(無中文版)
  • 38.1 SQL Reference is Provided in One PDF File
  • |38.2 Chapter 3. Language Elements
  • |38.2.1 Naming Conventions and Implicit Object Name Qualifications
  • |38.2.2 DATALINK Assignments
  • |38.2.3 Expressions
  • |38.2.3.1 Syntax Diagram
  • |38.2.3.2 OLAP Functions
  • |38.2.3.3 Sequence Reference
  • 38.3 Chapter 4. Functions
  • |38.3.1 Enabling the New Functions and Procedures
  • 38.3.2 Scalar Functions
  • |38.3.2.1 ABS or ABSVAL
  • |38.3.2.2 DECRYPT_BIN and DECRYPT_CHAR
  • |38.3.2.3 ENCRYPT
  • |38.3.2.4 GETHINT
  • |38.3.2.5 IDENTITY_VAL_LOCAL
  • 38.3.2.6 LCASE and UCASE (Unicode)
  • |38.3.2.7 MQPUBLISH
  • |38.3.2.8 MQREAD
  • |38.3.2.9 MQRECEIVE
  • |38.3.2.10 MQSEND
  • |38.3.2.11 MQSUBSCRIBE
  • |38.3.2.12 MQUNSUBSCRIBE
  • |38.3.2.13 MULTIPLY_ALT
  • |38.3.2.14 REC2XML
  • |38.3.2.15 ROUND
  • 38.3.2.16 WEEK_ISO
  • 38.3.3 Table Functions
  • |38.3.3.1 MQREADALL
  • |38.3.3.2 MQRECEIVEALL
  • |38.3.4 Procedures
  • |38.3.4.1 GET_ROUTINE_SAR
  • |38.3.4.2 PUT_ROUTINE_SAR
  • 38.4 Chapter 5. Queries
  • |38.4.1 select-statement/syntax diagram
  • 38.4.2 select-statement/fetch-first-clause
  • |38.5 Chapter 6. SQL Statements
  • |38.5.1 Update of the Partitioning Key Now Supported
  • |38.5.1.1 Statement: ALTER TABLE
  • |38.5.1.2 Statement: CREATE TABLE
  • |38.5.1.3 Statement: DECLARE GLOBAL TEMPORARY TABLE PARTITIONING KEY (column-name,...)
  • |38.5.1.4 Statement: UPDATE
  • |38.5.2 Larger Index Keys for Unicode Databases
  • |38.5.2.1 ALTER TABLE
  • |38.5.2.2 CREATE INDEX
  • |38.5.2.3 CREATE TABLE
  • |38.5.3 ALTER SEQUENCE
  • |ALTER SEQUENCE
  • |38.5.4 ALTER TABLE
  • |38.5.5 Compound SQL (Embedded)
  • |38.5.6 Compound Statement (Dynamic)
  • |Compound Statement (Dynamic)
  • |38.5.7 CREATE FUNCTION (Source or Template)
  • |38.5.8 CREATE FUNCTION (SQL Scalar, Table or Row)
  • |38.5.9 CREATE METHOD
  • |CREATE METHOD
  • |38.5.10 CREATE SEQUENCE
  • |CREATE SEQUENCE
  • |38.5.11 CREATE TRIGGER
  • |CREATE TRIGGER
  • |38.5.12 CREATE WRAPPER
  • |38.5.13 DECLARE CURSOR
  • |38.5.14 DELETE
  • |38.5.15 DROP
  • |38.5.16 GRANT (Sequence Privileges)
  • |GRANT (Sequence Privileges)
  • |38.5.17 INSERT
  • |38.5.18 SELECT INTO
  • |38.5.19 SET ENCRYPTION PASSWORD
  • |SET ENCRYPTION PASSWORD
  • |38.5.20 SET transition-variable
  • |SET Variable
  • |38.5.21 UPDATE
  • |38.6 Chapter 7. SQL Procedures now called Chapter 7. SQL Control Statements
  • |38.6.1 SQL Procedure Statement
  • |SQL Procedure Statement
  • |38.6.2 FOR
  • |FOR
  • |38.6.3 Compound Statement changes to Compound Statement (Procedure)
  • |38.6.4 RETURN
  • |RETURN
  • |38.6.5 SIGNAL
  • |SIGNAL
  • |38.7 Appendix A. SQL Limits
  • |38.8 Appendix D. Catalog Views
  • |38.8.1 SYSCAT.SEQUENCES
  • IBM DB2 儲存程序建置器
  • 39.1 Java 1.2 支援儲存程序建置器
  • 39.2 DB2 儲存程序的遠端除錯
  • 39.3 在 Windows、OS/2 或 UNIX 平台上開發 SQL 程序
  • 39.4 在 Solaris 平台使用 DB2 儲存程序建置器
  • 39.5 已知問題與限制
  • 39.6 在繁體中文語言環境下使用 DB2 儲存程序建置器
  • 39.7 UNIX (AIX、Sun Solaris、Linux) 安裝與儲存程序建置器
  • |39.8 建置 OS/390 的 SQL 儲存程序
  • |39.9 除錯 SQL 儲存程序
  • |39.10 匯出 Java 儲存程序
  • |39.11 在 OS/390 上插入儲存程序
  • |39.12 在工作站伺服器中設定 SQL 儲存程序的建置選項
  • |39.13 自動復新 OS/390 上儲存程序建置的 WLM 位址空間
  • |39.14 在 OS/390 開發 Java 儲存程序
  • |39.15 為 MQ Series 與 OLE DB 建置 DB2 表格使用者定義功能 (UDF)
  • |Unicode 更新
  • |40.1 簡介
  • |40.1.1 DB2 Unicode 資料庫及應用程式
  • |40.1.2 文件更新
  • |40.2 SQL Reference(無中文版)
  • |40.2.1 Chapter 3 Language Elements
  • |40.2.1.1 Promotion of Data Types
  • |40.2.1.2 Casting Between Data Types
  • |40.2.1.3 Assignments and Comparisons
  • |40.2.1.4 Rules for Result Data Types
  • |40.2.1.5 Rules for String Conversions
  • |40.2.1.6 Expressions
  • |40.2.1.7 Predicates
  • |40.2.2 Chapter 4 Functions
  • |40.2.2.1 Scalar Functions
  • |40.3 CLI Guide and Reference(無中文版)
  • |40.3.1 Chapter 3. Using Advanced Features
  • |40.3.1.1 Writing a DB2 CLI Unicode Application
  • |40.3.2 Appendix C. DB2 CLI and ODBC
  • |40.3.2.1 ODBC Unicode Applications
  • |40.4 Data Movement Utilities Guide and Reference(無中文版)
  • |40.4.1 Appendix C. Export/Import/Load Utility File Formats

  • [ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]