目錄

DB2 Everyplace 共用

  • 概念
  • 什麼是 DB2 Everyplace？
  • DB2 Everyplace 行動資料庫
  • DB2 Everyplace Sync Server
  • DB2 Everyplace Sync Client
  • DB2 Everyplace 行動應用程式建置器
  • DB2 Everyplace 範例應用程式
  • 範例 DB2 Everyplace 實務範例
  • 協助工具
  • 在「DB2 Everyplace 資訊中心」中尋找主題
  • 「DB2 Everyplace 資訊中心」的特性
  • 存取 DB2 Everyplace 書籍及版本資訊
  • 直接從 DB2 Everyplace CD 檢視技術文件

    • DB2 Everyplace 應用程式開發

  • 概念
  • The sample C/C++ applications
  • Overview of the sample Java applications
  • Overview of the sample Visual Basic application
  • DB2 Everyplace JSP support overview
  • Developing DB2 Everyplace JSP applications
  • The sample JSP applications
  • Overview of DB2 Everyplace synchronization providers
  • DB2 Everyplace native synchronization
  • DB2 Everyplace J2ME MIDP synchronization
  • DB2 Everyplace Java Sync Client for Cloudscape
  • DB2 Everyplace Java synchronization
  • The sample Java native synchronization applications
  • The sample Java MIDP synchronization applications
  • The sample Sync Client C/C++ application
  • Overview of the DB2 Everyplace database tables
  • Connection serialization
  • DB2 Everyplace databases on read-only media
  • Cursor behavior within the context of a connection
  • Encryption using the DB2eCLP
  • Character encoding in Java applications
  • Overview of parameter markers
  • Examples of parameter marker usage
  • ISync.Net API file locations
  • Simple example application using the ISync.NET API
  • Overview of .NET support for building applications on the client database
  • Sample DB2 Everyplace .NET Data Provider application code for WinCE and Win32
  • 作業
  • Developing DB2 Everyplace C/C++ applications
  • Preparing, compiling, and linking a C/C++ project
  • Testing a C/C++ application
  • Developing DB2 Everyplace Java applications
  • Creating a WSDD project for DB2eAppl.java for Palm OS targets
  • Installing WCE Tooling for WSDD for Palm OS targets
  • Installing WCE Tooling for WSDD for non-Palm OS targets
  • Creating a WSDD project and adding jar files to the build path for DB2eAppl.java for non-Palm OS targets
  • Adding the DB2 Everyplace JDBC Driver and java.sql package to the build path
  • Importing DB2eAppl.java into WSDD for Palm OS
  • Importing DB2eAppl.java into WSDD for non-Palm OS targets
  • Running DB2eAppl.java on Win32
  • Running DB2eAppl.java on Windows CE
  • Running DB2eAppl.java on a Palm OS emulator
  • Running DB2eAppl.java on QNX Neutrino or embedded Linux
  • Running DB2eAppl.java on Symbian
  • Compiling and running sample Java applications on Palm OS targets
  • Compiling and running sample Java applications on non-Palm OS targets
  • Developing DB2 Everyplace Visual Basic applications
  • Compiling and testing the sample Visual Basic program
  • Verifying JSP support on a Windows workstation
  • Setting up for JSP development on a Windows CE device
  • Installing and verifying JSP support on a Windows CE device
  • Installing the J9 JVM run-time environment on a Windows CE device
  • Transferring a JSP application to a Windows CE device
  • Running a JSP application on a Windows workstation
  • Running a JSP application on a Windows CE device
  • Configuring the mini HTTP Web server
  • Running a JSP application
  • Installing and verifying JSP support on a Symbian OS Version 6 device
  • Running a JSP application on a Symbian OS Version 6 device
  • Installing the JNI-based native synchronization provider
  • Installing the JNI-based synchronization provider on Win32
  • Installing the JNI-based synchronization provider on Nokia 9210/9290 Communicator devices using Symbian V6
  • Installing the JNI-based synchronization provider on Windows CE
  • Developing the isync4j for MIDP application with the Sun Wireless Toolkit
  • Developing the isync4j for MIDP application with ANT and the Sun Wireless Toolkit Command Line
  • Installing and verifying the trap-based native synchronization provider
  • Compiling and running the GoISyncConsole sample Java synchronization application
  • Developing DB2 Everyplace Sync Client applications using C/C++
  • Handling naming conflicts
  • Connecting to the DB2 Everyplace database
  • Piecemeal retrieval of data through CLI
  • Overview of local data encryption
  • Establishing a connection to the DB2 Everyplace database
  • Granting a user encryption privileges
  • Creating an encrypted table
  • Managing encryption privileges
  • Using the ISync.NET API
  • Using ISyncComponent
  • Overview of developing ADO.NET applications using the DB2 Everyplace
  • 參照
  • Supported C/C++ development tools
  • C/C++ supported operating systems
  • JDBC interface supported operating systems
  • Visual Basic Interface supported operating systems
  • Supported JSP Version 1.1 subsets
  • IBM custom tags for JSP application database access
  • JSP supported operating systems
  • Troubleshooting JSP applications
  • Overview of DB2 Everyplace SQL statement support
  • CALL
  • CREATE INDEX
  • CREATE TABLE
  • DELETE
  • DROP
  • EXPLAIN
  • GRANT
  • INSERT
  • REORG TABLE
  • REVOKE
  • SELECT
  • UPDATE
  • Data type compatibility for assignments and comparisons
  • DB2 Everyplace supported parameter markers
  • SQL symbolic and default data types
  • Data type attributes
  • SQLState listing
  • Summary of SQLState class codes
  • SQLState messages reported by SQL
  • SQLState messages reported by CLI
  • SQLState messages reported by JDBC
  • DB2 CLI function summary
  • Key to DB2 CLI function descriptions
  • SQLAllocConnect--Allocate connection handle
  • SQLAllocEnv--Allocate environment handle
  • SQLAllocHandle--Allocate handle
  • SQLAllocStmt--Allocate a statement handle
  • SQLBindCol--Bind a column to an application variable
  • SQLBindParameter--Bind a parameter marker to a buffer
  • SQLConnect--Connect to a data source
  • SQLDescribeCol--Return a set of attributes for a column
  • SQLDisconnect--Disconnect from a data source
  • SQLEndTran--Request a COMMIT or ROLLBACK
  • SQLError--Retrieve error information
  • SQLExecDirect--Execute a statement directly
  • SQLExecute--Execute a statement
  • SQLFetch--Fetch next row
  • SQLFetchScroll--Fetch row set and return data for all bound columns
  • SQLForeignKeys--Get the list of foreign key columns
  • SQLFreeConnect--Free connection handle
  • SQLFreeEnv--Free environment handle
  • SQLFreeHandle--Free handle resources
  • SQLFreeStmt--Free (or reset) a statement handle
  • SQLGetCursorName--Get cursor name
  • SQLGetData--Get data from a column
  • SQLGetDiagRec--Get multiple fields settings of diagnostic record
  • SQLGetInfo--Get general information
  • SQLGetStmtAttr--Get current setting of a statement attribute
  • SQLNumResultCols--Get number of result columns
  • SQLPrepare--Prepare a statement
  • SQLPrimaryKeys--Get primary key columns of a table
  • SQLRowCount--Get row count
  • SQLSetConnectAttr--Set options related to a connection
  • SQLSetStmtAttr--Set options related to a statement
  • Data conversion by DB2 CLI functions
  • SQLGetConnectAttr--Get current setting of a connection attribute
  • SQLTables - Get Table Information
  • SQLColumns - Get Column Information for a Table
  • SQLNumParams - Get Number of Parameters in A SQL Statement
  • Blob interface
  • Connection interface
  • DatabaseMetaData interface
  • Driver interface
  • PreparedStatement interface
  • ResultSet interface
  • ResultSetMetaData interface
  • Statement interface
  • DB2eStatement class
  • DB2eConnection class
  • Overview of DB2 Everyplace JDBC support
  • DataSource interface
  • CallableStatement interface
  • Comparisons between IBM Sync Client C-API Version 8.1 and Version 7.2
  • IBM Sync Client C-API function summary
  • IBM Sync Client C-API data types
  • Key to IBM Sync Client C-API function descriptions
  • iscGetVersion()
  • iscServiceOpen()
  • iscServiceClose()
  • iscServiceOpenEx()
  • iscConfigOpen()
  • iscConfigClose()
  • iscConfigPurge()
  • iscConfigOpenCursor()
  • iscConfigCloseCursor()
  • iscConfigGetNextSubsSet()
  • iscConfigEnableSubsSet()
  • iscConfigDisableSubsSet()
  • iscConfigResetSubsSet()
  • iscConfigSubsSetIsEnabled()
  • iscConfigSubsSetIsReset()
  • iscConfigGetSubsSetStatus()
  • iscEngineOpen()
  • iscEngineClose()
  • iscEngineGetInfo()
  • iscEngineSetListener()
  • iscEngineListenerPF
  • iscEngineSetPref()
  • iscEngineGetPref()
  • iscEngineSync()
  • iscEngineSyncConfig()
  • IBM Java Sync APIs
  • Java Sync API supported operating systems
  • DB2 Everyplace System Catalog base tables
  • The DB2 Everyplace information set
  • DB2 Everyplace limits
  • National language support (NLS)
  • DB2 Everyplace NLS support by operating system
  • DB2 Everyplace language enablers
  • DB2 Everyplace UNICODE support
  • DB2 Everyplace reserved words
  • DB2eCommandBuilder Members
  • DB2eCommand Members
  • DB2eConnection Members
  • DB2eDataAdapter Members
  • DB2eDataReader Members
  • DB2eError Members
  • DB2eException Members
  • DB2eParameter Members
  • DB2eTransaction Members
  • DB2eType Enumeration

    • DB2 Everyplace 安裝

  • 概念
  • WAS 安裝 Script
  • Visiting Nurse 範例應用程式的概觀
  • CLP 應用程式的概觀
  • IBM Sync 的概觀
  • IBM Sync 功能表選項
  • 配置多個伺服器環境
  • 伺服器群組及複製物
  • 規劃注意事項及要訣
  • 作業
  • 在伺服器上安裝
  • 利用 WebSphere Application Server 5.0 版來配置及安裝 DB2 Everyplace
  • 建立叢集環境
  • 管理作業
  • 8.1.4 版的移轉注意事項
  • 在伺服器上安裝 (Windows)
  • 設定範例資料庫及應用程式
  • 測試 Sync Server Servlet
  • 配置 Sync Server 以與 IBM WebSphere Application Server 搭配使用
  • 對映來源資料庫至中層伺服器
  • 啟用抄寫
  • 新增伺服器節點
  • 建立叢集
  • 將新的伺服器新增至叢集
  • 收集配置資訊
  • 重建 Web 伺服器 Plugin
  • 從 WAS 解除安裝 DB2 Everyplace
  • 啟動及停止 DB2 Everyplace 應用程式伺服器
  • 刪除叢集
  • 安裝與配置概觀
  • 建立及安裝應用程式伺服器
  • 使用「在行動裝置上安裝」工具來安裝
  • 在 Palm OS 裝置上安裝 DB2 Everyplace 檔案
  • 在 Windows CE 裝置上安裝檔案
  • 在 Symbian OS 第 6 版裝置上安裝檔案
  • 在 QNX Neutrino 或內嵌式 Linux 行動裝置上安裝檔案
  • 在 MIDP 支援的裝置上安裝檔案
  • 安裝檔案於一個 Win32 的從屬站。
  • 在 Sharp Zaurus 裝置上安裝檔案
  • 在 Symbian OS 第 7 版裝置上安裝檔案
  • 行動裝置上的後置安裝作業
  • 手動安裝 DB2 Everyplace 檔案
  • 安裝行動裝置
  • 使用 DB2 Everyplace 更新工具來更新 Sync Client 軟體
  • 在 Sync Server 上設定 DB2 Everyplace 更新工具
  • 在行動裝置上安裝 DB2 Everyplace 更新工具
  • 設定 Palm OS 行動裝置來進行同步化
  • 設定 Palm OS 行動裝置或模擬程式
  • 在 Palm OS 行動裝置或模擬程式上安裝檔案
  • 在 Palm OS 行動裝置或模擬程式上進行同步化及驗證資料
  • 設定並配置 Symbian OS 第 6 版行動裝置來進行同步化
  • 在工作站上配置 m-Router Connect
  • 在裝置上配置 m-Router Connect
  • 在裝置上配置 ISync
  • 在 Symbian OS 第 6 版裝置上同步化資料
  • 執行 Visiting Nurse 應用程式
  • 使用 CLP 匯入及匯出資料
  • 針對 Palm OS 配置 IBM Sync
  • 使用 IBM Sync 同步化資料
  • 設定以建立應用程式伺服器複製物
  • 建立應用程式伺服器複製物
  • 後置配置作業
  • 針對 Linux 調整作業系統參數
  • 針對 Solaris 調整作業系統參數
  • 針對 AIX 調整作業系統參數
  • 在伺服器上安裝 (UNIX)
  • 在伺服器上安裝 DB2 Everyplace Express (Windows)
  • 在伺服器上安裝 DB2 Everyplace Express (Linux)
  • 在 UNIX 上建立 DB2 Everyplace 案例
  • 參照
  • DB2 Everyplace 更新工具錯誤訊息
  • CLP 命令
  • Visiting Nurse 範例應用程式表格
  • DB2 Everyplace 範例應用程式的概觀

    • DB2 Everyplace Sync Server 管理

  • 概念
  • The synchronization process
  • Synchronization from the mobile device to the source database
  • Synchronization from the source database to the mobile device
  • Synchronization conflict resolution
  • Components of the DB2 Everyplace solution
  • Default JDBC drivers list
  • The remote query and stored procedure adapter
  • Using the remote query and stored procedure adapter in an application
  • Mobile Devices Administration Center and synchronization objects
  • What is the Mobile Devices Administration Center?
  • The Mobile Devices Administration Center interface
  • What is a synchronization object?
  • Where synchronization objects are stored
  • Information displayed in the contents pane
  • Evalutating the characteristics of your 機動使用者
  • What is data synchronization?
  • What is a subscription set?
  • Data filter example
  • What is a data filter?
  • What is a user?
  • Data set up and replication
  • Replication Invocation
  • What is a replication source?
  • Data filtering and replication
  • What is an upload subscription?
  • What is a subscription set?
  • The default adapters
  • What is a file subscription?
  • What is a DataPropagator subscription?
  • What is a JDBC subscription?
  • What a subscription set?
  • What is a replication subscription?
  • Overview of the XML Scripting tool
  • XML Scripting tool restrictions
  • The order of synchronization and reception of error messages
  • Custom logic
  • Improving replication performance
  • Utilizing the XML Scripting tool
  • Handling synchronization problems
  • 作業
  • Configuring synchronization
  • Creating a DataPropagator subscription to access data
  • Using a Remote Access Service
  • Configuring the Sync Server to access data sources
  • Creating a DataPropagator table subscription
  • Filtering data from data sources
  • Filtering data horizontally
  • Defining simple horizontal filters
  • Creating an application using the remote query and stored procedure adapter
  • Using the Mobile Devices Administration Center
  • Creating a data synchronization group
  • Creating users in the Mobile Devices Administration Center
  • Creating a JDBC subscription
  • Creating a DataPropagator subscription
  • Creating an 上載 subscription
  • Creating a file subscription
  • Creating a custom subscription
  • Enabling groups to access their data and files
  • Monitoring client synchronization status
  • Using the Synchronization Monitor tool
  • Basic setup for the DB2 Everyplace solution
  • Installing the sample database
  • Creating a JDBC subscription to access source data
  • Setting up sources for DataPropagator subscriptions
  • Creating the DataPropagator subscription
  • Configuring the databases and starting Capture for DataPropagator subscriptions.
  • Grouping subscriptions into mobile subscription sets
  • Creating mobile users
  • Creating a data synchronization group
  • Starting the application server
  • Setting up the serial cradle for use with Windows Remote Access Service
  • Configuring the Windows Remote Access Service on the Windows workstation
  • Configuring the Sync Server for JDBC sources using supported drivers
  • Configuring the Sync Server for JDBC sources using unsupported drivers
  • Configuring the JDBC driver to access Lotus Domino data
  • Specifying the JDBC driver in the Mobile Device Administration Center
  • Configuring DataPropagator for DB2 Everyplace subscriptions
  • Associating the DataPropagator Subscription Set with a DB2 Everyplace table subscription
  • Filtering data at the subscription level
  • Filtering data at the group level
  • Filtering data at the user level
  • Defining complex horizontal filters
  • Filtering data vertically
  • Defining the default value data-filter parameters
  • Creating an AgentAdapter subscription
  • Creating a data source using the sample application
  • Creating the Agent Adapter subscription for the sample application
  • Starting the Mobile Devices Administration Center
  • Creating an object from the object tree
  • Creating synchronization objects
  • Refreshing the view
  • Filtering the contents pane
  • Editing a synchronization object
  • Deleting an object
  • Creating a new object when working with another
  • The administration process
  • Concluding the administration process
  • Identifying the group
  • Enabling the group to access data and files
  • Defining a data filter for a group
  • Assigning a user to a group
  • Identifying the user
  • Assigning the user to a group
  • Setting passwords for the user
  • Filtering the data available to the user
  • Registering a device
  • Importing user definitions from another source
  • Identifying the JDBC subscription
  • Specifying the encryption level
  • Specifying the source database driver and URL
  • Specifying the mirror database driver and URL
  • Specifying source tables, target tables, and privileges for the subscription
  • Filtering the data that will be replicated during synchronization
  • Batching synchronization requests
  • Assigning a subscription set to a JDBC subscription
  • Identifying the subscription
  • Specifying the encryption level
  • Mapping the source to the target
  • Identifying the mirror database
  • Adding a replication source
  • Creating a filter for replicated data
  • Batching synchronization requests
  • Providing a user ID and password for the subscription
  • Specifying the subscription sets that use this subscription
  • Identifying the 上載 subscription
  • Specifying the encryption level
  • Specifying the source database driver and URL
  • Specifying source tables and target tables
  • Assigning a subscription set to an 上載 subscription
  • Identifying the subscription
  • Specifying the encryption level
  • Specifying the name of the source file
  • Specifying subscription sets that use the subscription
  • Flagging a subscription that references a changed file
  • Identifying the Custom subscription
  • Specifying the encryption level
  • Launch the customizer
  • Assigning a subscription set to a Custom subscription
  • Replicating on demand
  • Identifying the subscription set
  • Specifying what information the subscription set accesses
  • Making the subscription set available to a group
  • Enabling and disabling synchronization
  • Enabling synchronization
  • Disabling synchronization
  • Creating XML scripts
  • Viewing the error log to diagnose problems
  • Purging error log entries automatically
  • Defining the tracing level
  • Providing your own error-handling logic
  • Viewing the log on the client
  • Resetting the user ID
  • Accessing the Synchronization Monitor tool
  • Setting an automatic refresh
  • Selecting a view
  • Customizing the column display
  • Exporting data
  • Enabling the sample application for custom logic
  • Using the custom logic sample application
  • Developing custom logic
  • 參照
  • Lotus Domino data source restrictions
  • XML sample scripts
  • Common restrictions for JDBC data sources
  • Data source restrictions for DataPropagator subscriptions
  • Syntax for filters
  • Supported data types for stored procedures
  • CLI functions and restrictions for result sets
  • Create a data source
  • Creating a stored procedure using the sample application
  • Creating a DB2 Everyplace application
  • Sample application code
  • Using XML Scripting tool parameters
  • Example code for programmers
  • Error messages
  • Data type mappings between DB2 Everyplace and data sources
  • DB2 Universal Database
  • Informix
  • Oracle
  • Sybase
  • Lotus Domino
  • Data type mapping restrictions
  • SQL Server 2000
  • XML Scripting tool DTD
  • Cloudscape
  • Command line scripts for the DB2 Everyplace Sync Server

    • 索引