Index

Special characters
A B C D E F G H I J L M N O P Q R S T U V W X

Special characters

.NET data provider
- overview (2209)
- using (2329)

access path selection
- sample script (2477)
- using EXPLAIN statement (2467)
access privileges, defining in subscription (3282)
access to data and files, providing (3212)
Add Data Filter window (3215)
administration
- device registration (3238)
- subscription sets (3108)
- subscriptions (3089)
- synchronization objects.See synchronization object (3054)
- task road maps (3166), (3204)
- troubleshooting (3141)
- user groups (3040), (3074), (3078)
administration control database. See control database (3063)
allocating handles (2589)
application
- writing (3037)
application development tools
- for EPOC R5 (2339)
- for Linux and embedded Linux (2352)
- for Palm OS (2332)
- for QNX Neutrino (2349)
- for Symbian OS Version 6.0 (2340)
- for Symbian OS Version 7.0 (2343)
- for Windows 2000 (2348)
- for Windows CE (2346)
- for Windows NT (2347)
application server clones
- creating (2967)
- setting up to create (2966)
application UIDs
- for EPOC R5 (2342)
- for Palm OS (2337)
- for Symbian OS Version 6.0 (2341)
- for Symbian OS Version 7.0 (2344)
applications
- sample (2887)
  - Command Line Processor (2891)
  - Visiting Nurse (2982)
applications, sample (2986)
applications for DB2 Everyplace, writing (3032)
Apply program
- role in synchronization (3008), (3015)
Apply qualifier (3274)
attributes, data type (2539)
authentication
- control database verification (3064)
- user passwords (3228)
Authentication page
- DataPropagator subscription notebook (3293)
- User notebook (3225)
authorization, user. See authentication. (3067)
AUTOCOMMIT (2465)
autocommit mode
- cursor behavior (2193)

batching synchronization requests (3092), (3127)
Bind A Buffer To A Parameter Marker, function (2604)
Bind Column, function (2602)
bind parameters (2529)
Blob, interface (2677)
Blob class, in Java (2679)
BLOB data type (2438)
books (2844)
byte counts (2445)

C/C++
- supported development tools (2331)
cable connection, RAS setup (3168)
CALL statement (2395)
CallableStatement interface (2730)
Capture program
- role in synchronization (3006), (3013)
cardinality violation messages, in SQLState (2554)
case sensitivity (3263)
catalog (2393)
CD-ROM, running DB2 Everyplace from (2184)
change data table (DataPropagator) (3285)
CHAR data type (2435)
CHARACTER data type (2436)
character encoding (2200)
characteristics of groups (3076)
class, DB2eConnection (2719)
class, DB2eStatement (2716)
CLI
- using for piecemeal retrieval of data (2310)
CLI/ODBC interface (2148), (2210), (2266)
client
- database conflicts (3024)
- how synchronization happens (2994)
client application (2399)
client synchronization software (2996)
clones (2901)
Cloudscape Sync Client (2169)
Code field
- error messages (3352)
codes for error messages (3380)
column-name, in CREATE TABLE statement (2419)
column options, in CREATE TABLE statement (2442)
column properties, finding in ResultSet object (2709)
column types, finding in ResultSet object (2708)
columns
- inserting values, INSERT statement (2491)
- updating row values, UPDATE statement (2514)
Command Line Processor (2893)
commands
- CLP (2981)
commit
- cursor behavior (2191)
configuration
- Administrator workflow (3206)
conflict management (3022)
conflicts, naming (2305)
connect function (2606)
connecting with database, using Java (2685)
connection
- establishing (2316)
connection, database (2308)
connection exception messages, in SQLState (2550)
connection handle
- allocating (2591)
- dummy (2595)
- freeing (2632)
Connection interface (2683)
connection serialization (2181)
connections
- cursor behavior within (2189)
constraint violation messages, in SQLState (2556)
constraints in Visual Basic sample applications (2137)
contents pane
- deleting objects (3203)
- editing objects (3198)
- filtering (3196)
- interpreting information (3069)
- refreshing (3191)
Control Center
- starting Mobile Devices Administration Center (3186)
control database
- description (3058)
- importing user definitions (3247)
CREATE INDEX statement (2403), (2408)
CREATE TABLE statement (2413)
creating synchronization objects
- DataPropagator subscription (3157)
- general process (3188)
- group (3081)
- subscription set (3107)
- user (3151)
cursor behavior (2186)
custom adapter, creating (3115)
Custom subscription, assigning a subscription set to (3323)
custom subscription, creating (3161)
customizer, Launching the (3322)

data
- conflict management (3021)
- encrypting
  - connecting to the database (2318)
  - creating a table (2323)
  - example of using DB2eCLP (2194)
  - granting user privileges (2322)
  - managing user privileges (2328)
  - overview (2313)
- retrieving piecemeal (2311)
data conversion (2531), (2667)
data exception messages, in SQLState (2555)
data filter. See filtering data. (3087)
Data filter page
- Group notebook (3214)
- User notebook (3229)
data synchronization. See synchronization. (3039)
data synchronization group. See group (3056)
data type
- BLOB (2428)
- CHAR (2430)
- compatibility (2523)
- compatible (2525)
- conversions (2532)
- DATE (2432)
- DECIMAL (2429)
- for IBM Sync Client C-APIs (2740)
- HISCCONF (2770)
- HISCCSR (2774)
- HISCENG (2772)
- HISCSERV (2768)
- INT (2424)
- INTEGER (2423)
- ISCEVT (2776)
- ISCLISTENARG (2780)
- ISCLISTENCOLUMN (2782)
- ISCLISTENCONFLICT (2784)
- ISCSTATE (2778)
- isy_BOOL (2766)
- isy_BYTE (2758)
- isy_DWORD (2762)
- isy_INT (2744)
- isy_INT16 (2748)
- isy_INT32 (2752)
- isy_TCHAR (2764)
- isy_UINT (2746)
- isy_UINT16 (2750)
- isy_UINT32 (2754)
- isy_ULONG (2756)
- isy_VOID (2742)
- isy_WORD (2760)
- operands, of (2524)
- SMALLINT (2426)
- TIME (2431)
- TIMESTAMP (2427)
- VARCHAR (2425)
data type attributes (2538)
database
- access privileges for subscription (3283)
- administration control information. See control database (3248)
- conflict management (3023)
- establishing a connection (2317)
- mirror. See mirror database. (3270)
database_enabler_cldc.jar (2249)
database engine for mobile devices (3033)
Database field
- error messages (3356)
DatabaseMetaData interface (2687)
DataPropagator
- Apply program (3009), (3016)
- Apply qualifier (3276)
- Capture program (3007)
- replication source definition (3271)
- role in synchronization (2990)
DataPropagator (DPROP)
- Capture program (3014)
DataPropagator subscription (3155)
- assigning to subscription set (3297)
- data filters (3103)
- database authentication (3289)
- defined (3118), (3119)
- naming (3260)
- synchronization batch parameters (3126)
DataPropagator subscription, assigning a subscription set to (3258)
DataPropagator subscription notebook (3156)
DataSource interface (2727)
DATE data type (2439)
DB2 CLI
- functions, list of (2580)
- SQLSTATEs (2577)
DB2 Control Center. See Control Center (3187)
DB2 Everyplace
- information set (2843)
- limits (2848)
- reserved words (2868)
DB2 Everyplace Administrator error messages, in SQLState (2576)
DB2 Everyplace catalog (2394)
DB2 Everyplace CLP
- commands (2980)
- importing and exporting data (2962)
DB2 Everyplace database
- connecting to (2307)
DB2 Everyplace database engine (3034)
DB2 Everyplace Mobile Application Builder (3036)
DB2 Everyplace sample applications, testing (2935)
DB2 Everyplace Update Tool (2941)
- error messages (2978)
DB2 Everyplace Web site (2333)
DB2 UDB
- enabling replication with (2921)
DB2eAppl.java
- compiling and running on non-Palm OS (2265)
- compiling and running on Palm OS (2262)
- for non-Palm
  - adding db2ejdbc.jar to the build path (2246)
  - creating a WSDD project (2245)
- for Palm
  - adding the JDBC driver to the build path (2247)
  - creating a WSDD project using jclCldc configuration (2236)
  - creating a WSDD project using jclXtr configuration (2238)
- importing into WSDD for non-Palm OS targets (2254)
- importing into WSDD for Palm OS targets (2252)
- running on a Palm OS emulator (2257)
- running on QNX Neutrino or embedded Linux (2258)
- running on Symbian (2259)
- running on Win32 (2255)
- running on Windows CE (2256)
DB2eCLP
- encryption using (2196)
DB2eCommand (2872)
DB2eCommandBuilder (2870)
DB2eConnection (2874)
DB2eConnection class (2720)
DB2eDataAdapter (2876)
DB2eDataReader (2878)
DB2eError (2880)
DB2eException (2882)
DB2eJDBC_Cldc_maps.jar (2250)
DB2eParameter (2884)
DB2ePLANTABLE
- columns (2475)
- using EXPLAIN statement (2473)
DB2eStatement class (2717)
DB2eSYSCOLUMNS (2840)
DB2eSYSRELS (2841)
DB2eSYSTABLES (2839)
DB2eSYSUSERS (2842)
DB2eType (2886)
DBCS characters
- in column names (2421)
- in table names (2418)
DECIMAL data type (2434)
Define Replication Subscription window (3273)
definitions (user), importing (3246)
DELETE, dirty bit state (2665)
DELETE privilege, allowing in subscription (3281)
DELETE statement (2446)
- errors in executing (2453)
- logically deleted records (2455)
- multiple row (2452)
deleting a synchronization object (3202)
deleting SQL objects (2458)
delimited identifiers
- using for column names (2420)
- using for table names (2417)
deprecated function
- SQLAllocConnect (2584)
- SQLAllocEnv (2586)
- SQLAllocStmt (2599)
- SQLError (2612)
- SQLFreeConnect (2624)
- SQLFreeEnv (2626)
- SQLFreeStmt (2634)
Describe Column Attributes, function (2608)
description, providing for object
- file subscription (3309)
- subscription set (3332)
Description field
- error messages (3353)
descriptor handle
- allocating (2593)
developing DB2 Everyplace applications
- for the Sync Client (2151)
- registering application creator IDs (2336)
- using .NET
  - DB2eCommand Members (2871)
  - DB2eCommandBuilder members (2869)
  - DB2eConnection Members (2873)
  - DB2eDataAdapter Members (2875)
  - DB2eDataReader Members (2877)
  - DB2eError Members (2879)
  - DB2eException Members (2881)
  - DB2eParameter Members (2883)
  - DB2eType enumeration (2885)
- using C/C++
  - compiling samples (2215)
  - for Sync Client (2303)
  - header files (2216)
  - overview (2211)
  - preparing, compiling, and linking projects (2214)
  - preprocessor definition (2219)
  - required files for testing (2229)
  - required library files (2217)
  - sample application (2127)
  - stack size for Palm OS (2218)
  - supported development tools (2330)
  - supported operating systems (2353)
  - testing application (2228)
  - UNICODE support (2220), (2227)
- using Java
  - overview (2231)
  - sample applications (2129)
  - sample programs (2260), (2263)
  - supported operating systems (2362)
- using JavaServer Pages
  - configuring the mini HTTP Web server on Win32 (2280)
  - overview (2143)
  - running an application on a Windows CE device (2279)
  - running an application on a Windows workstation (2277)
  - running JSP applications (2283)
  - sample applications (2149), (2173)
  - supported JSP Version 1.1 subsets (2374)
  - supported operating systems (2378)
  - testing (2144)
  - using IBM custom tags (2376)
- using Visual Basic
  - basic steps (2270)
  - overview (2267)
  - sample applications, overview (2136)
  - SQLAllocHandle, function (2598)
  - supported operating systems (2373)
  - testing sample program (2271)
device See mobile device (3237)
diagnosis of problems. See troubleshooting (3139)
diagnostics, get multiple fields (2642)
dirty bit
- concept of (2660)
- errors, in setting (2521)
- setting manually (2522)
- states (2662)
- understanding (2661)
- values, obtaining (2666)
disabling synchronization (3344)
Disconnect, function (2610)
DPROP. See DataPropagator. (3272)
Driver class, in Java (2692)
Driver interface (2690)
DROP statement
- errors in executing (2463)
- purpose (2456)
DSYCTLDB database
- description (3059)
DSYID variable (user exits) (3364)
DSYMSG variable (user exits) (3366)
DSYUserExits.properties file (3363)
dynamic SQL error messages, in SQLState (2549)

editing a synchronization object (3197)
efficiency, increasing by using PreparedStatement object (2701)
embedded Linux. See Linux (2361)
embedded Linux, installing files on (2931)
enablers (2857)
enabling synchronization (3239)
encryption
- example of using DB2eCLP (2195)
- granting, SQL statement instructions (2479)
- overview (2314)
encryption of user ID and passwords (3068)
encryption privileges
- granting (2319)
- managing (2325)
environment handle
- allocating (2590)
- freeing (2631)
error log. See log (3346)
error message
- log. See log (3057)
error messages
- CLI (2542)
- codes and explanations (3378)
- DB2 Everyplace Update Tool (2979)
- rejected records (3124)
- SQL (2541)
- user exit interface for (3362)
- viewing (3349), (3370)
errors
- in executing DELETE statements (2454)
- in executing DROP statement (2464)
- in executing UPDATE statements (2520)
Execute statement, function (2617)
Execute statement Directly, function (2615)
executeUpdate(String sql) method (2133)
executing SQL statement (2713)
EXPLAIN statement, supported operating systems (2469)
external function call exception messages, in SQLState (2565)
external function exception messages, in SQLState (2564)

FAR pointers (2582)
feature not supported messages, in SQLState (2552)
Fetch, function (2619)
Fetch row set and Return Data, function (2621)
file
- changing after creating subscription (3320)
file subscription
- assigning to subscription sets (3315)
- defined (3117)
- file changes (3318)
File subscription
filtering (3376)
filtering data
- contents pane (3195)
- DB2 UDB variables, using (3181)
- for individual users (3374)
- group (3086), (3144), (3148), (3171), (3175) , (3179)
- horizontal (3142), (3146), (3169), (3173), (3177)
- subscription (3104), (3143), (3147), (3170), (3174) , (3178)
- user (3145), (3149), (3172), (3176), (3180) , (3231)
- vertical (3182)
free handle resources, function (2629)
FROM clause in DELETE statement (2449)
functions, DB2 CLI, by category (2581)

Get Column Information for a Table, function (2673)
Get current setting of a connection attribute, function (2669)
Get Cursor Name, function (2637)
Get Data, function (2639)
Get Foreign Key Columns, function (2623)
Get Info, function (2644)
Get Multiple Fields of Diagnostic Record, function (2641)
Get Number of Parameters in A SQL Statement, function (2675)
Get Number of Result Columns, function (2648)
Get Primary Key Columns, function (2653)
Get Row Count, function (2655)
Get setting of a statement, function (2646)
Get Table Information, function (2671)
GNU Software Developer's Kit (2334)
GoISyncConsole sample synchronization application, running (2302)
GRANT statement, supported operating systems (2480)
graphical user interface (GUI). See interface. (3044)
group
- assigning subscription sets (3210), (3338)
- assigning users (3218), (3224)
- creating (3080)
- definition (3083)
- disabling synchronization (3342)
- enabling synchronization (3339)
- evaluating user needs (3075)
- filtering source data for (3085)
- naming (3209)
Group notebook (3079)
Groups page
- Subscription set notebook (3336)
- User notebook (3222)
GUI (graphical user interface). See interface. (3045)

handle, freeing (2630)
hardware requirements (2126)
header files (2212)
HISCCONF data type (2769)
HISCCSR data type (2773)
HISCENG data type (2771)
HISCSERV data type (2767)
Host:Port field
- error messages (3357)
host variable, inserting in rows (2495)

IBDB (2338)
IBM Java Sync API (2836)
IBM Sync
- advanced (2898)
- client component of Sync Server (2995)
- settings menu (2897)
- subscription sets menu (2896)
IBM Sync application
- menu options (2895)
- overview (2894)
- synchronizing data (2964)
IBM Sync Client APIs
- Java ISync Client
  - overview (2172)
- Java Sync Client for Cloudscape
  - overview (2168)
- MIDP ISync Client
  - implementing (2165)
  - overview (2161)
- native ISync Client
  - overview (2157)
IBM Sync Client C-API
- data types (2738)
- function summary (2733)
- key to function descrptions (2785)
- version comparison (2732)
IBM Sync Client C-APIs
- data types (2739)
- summary (2734), (2735), (2736), (2737)
ID parameter in user exits (3365)
Identification page
- DataPropagator subscription notebook (3259)
- File Subscription notebook (3307)
- Group notebook (3208)
- Subscription set notebook (3330)
- User notebook (3220)
importing and exporting data (2963)
importing user definitions (3245)
increasing efficiency, by using PreparedStatement object (2700)
index
- bi-directional scanning (2410)
- creating, dirty bit (2409)
- creating, SQL statement instructions (2405)
- deleting, using DROP statement (2460)
- duplicate description (2407)
- limitations in creating (2406)
- ordering (2411)
- prefix-scanning (2412)
INDEX clause, DROP statement (2462)
inheritance of values (group to user) (3232)
input queue for synchronization requests (2998), (3018)
INSERT, dirty bit state (2663)
INSERT clause, restrictions leading to failure (2496)
INSERT privilege, allowing in subscription (3279)
INSERT statement (2488)
Install on Mobile Devices tool (2924)
installing DB2 Everyplace Express on a server
- steps (2972), (2975)
installing DB2 Everyplace on a mobile device
- manually (2936)
- overview (2938)
- using the Install on Mobile Devices tool (2922)
installing DB2 Everyplace on a server
- overview (2903)
- steps (2906), (2969)
INTEGER data type (2422)
interface, Blob (2676)
interface, CallableStatement (2729)
interface, Connection (2682)
interface, DatabaseMetaData (2686)
interface, DataSource (2726)
interface, Driver (2689)
interface, PreparedStatement (2695)
interface, ResultSet (2702)
interface, ResultSetMetaData (2705)
interface, Statement (2710)
interface drivers, registering (2681), (2694)
interface to Sync Server (3043)
INTO clause
- INSERT statement, naming table (2489)
- restrictions on using, list of (2490)
invalid application state messages, in SQLState (2570)
invalid authorization specification messages, in SQLState (2560)
invalid connection name messages, in SQLState (2562)
invalid cursor name messages, in SQLState (2563)
invalid cursor state messages, in SQLState (2557)
invalid SQL statement identifier messages, in SQLState (2559)
invalid token messages, in SQLState (2553)
invalid transaction state messages, in SQLState (2558)
invalid transaction termination messages, in SQLState (2561)
iscConfigClose(), synchronization function (2797)
iscConfigCloseCursor(), synchronization function (2803)
iscConfigDisableSubsSet(), synchronization function (2809)
iscConfigEnableSubsSet(), synchronization function (2807)
iscConfigGetNextSubsSet(), synchronization function (2805)
iscConfigGetSubsSetStatus(), synchronization function (2817)
iscConfigOpen() , synchronization function (2795)
iscConfigOpenCursor(), synchronization function (2801)
iscConfigPurge(), synchronization function (2799)
iscConfigResetSubsSet(), synchronization function (2811)
iscConfigSubsSetIsEnabled(), synchronization function (2813)
iscConfigSubsSetIsReset(), synchronization function (2815)
iscEngineClose(), synchronization function (2821)
iscEngineGetInfo(), synchronization function (2823)
iscEngineGetPref(), synchronization function (2831)
iscEngineListenerPF, synchronization function (2827)
iscEngineOpen(), synchronization function (2819)
iscEngineSetListener(), synchronization function (2825)
iscEngineSetPref(), synchronization function (2829)
iscEngineSync(), synchronization function (2833)
iscEngineSyncConfig(), synchronization function (2835)
ISCEVT data type (2775)
iscGetVersion(), synchronization function (2787)
ISCLISTENARG data type (2779)
ISCLISTENCOLUMN data type (2781)
ISCLISTENCONFLICT data type (2783)
iscServiceClose(), synchronization function (2791)
iscServiceOpen(), synchronization function (2789)
iscServiceOpenEx(), synchronization function (2793)
ISCSTATE data type (2777)
isy_BOOL data type (2765)
isy_BYTE data type (2757)
isy_DWORD data type (2761)
isy_INT data type (2743)
isy_INT16 data type (2747)
isy_INT32 data type (2751)
isy_TCHAR data type (2763)
isy_UINT data type (2745)
isy_UINT16 data type (2749)
isy_UINT32 data type (2753)
isy_ULONG data type (2755)
isy_VOID data type (2741)
isy_WORD data type (2759)
ISync
- configuring on a Symbian OS v6.0 device (2957)
ISync.Net API
- file locations (2207)
- sample code (2208)
ISync.NET API
isync4j (2153)
isync4j for MIDP application
- developing with the Sun Wireless Toolkit (2295)
- developing with the Sun Wireless Toolkit Command Line (2297)
isync4j for PalmOS (2300)
ISyncSample.java application (2175)

J2ME CLDC Configuration (2234)
J2ME MIDP ISync Client
- implementing (2163)
- overview (2159)
J9 runtime environment
- installing on a Windows CE device (2274)
Java API for Cloudscape Sync Client
- overview (2166)
Java API for ISync Client
- implementing
  - JNI, on Symbian for Nokia devices (2290)
  - JNI, on Win32 (2286), (2287)
  - JNI, on Windows CE (2292)
Java API for J2ME MIDP ISync Client
- implementing (2162)
- overview (2158)
Java API for Java Sync Client
- overview (2170)
Java API for native ISync Client
- overview (2155)
Java applications
- using UNICODE (2202)
Java DDL messages, in SQLState (2569)
Java ISync Client
- overview (2171)
Java method
- class, DB2eConnecton (2721)
- class, DB2eStatement (2718)
- interface, Blob (2678)
- interface, CallableStatement (2731)
- interface, Connection (2684)
- interface, DatabaseMetaData (2688)
- interface, DataSource (2728)
- interface, Driver (2691)
- interface, PreparedStatement (2697)
- interface, ResultSet (2704)
- interface, ResultSetMetaData (2707)
- interface, Statement (2712)
Java Software Developer's Kit (2232), (2725)
java.sql (2248)
java.sql package (2131)
Java Sync Client for Cloudscape
- overview (2167)
JavaServer Pages applications See developing DB2 Everyplace applications, JavaServer Pages (2141)
JCL Extreme Palm Custom Configuration (2235)
jclCldc configuration, uring (2237)
jclXtr configuration, using (2239)
JDBC
- supported operating systems (2369)
JDBC APIs (2724)
JDBC interface. See also developing DB2 Everyplace applications, using Java (2230)
JDBC methods
- supported (2723)
JDBC package (2132)
JDBC subscription
- synchronization batch parameters (3091)
JDBC subscription, creating (3153)
JNI-based native synchronization provider, installing (2285)
JNI-based synchronization provider
- installing (2294)
JSP
- IBM custom tags (2377)
JSP See developing DB2 Everyplace applications, JavaServer Pages (2142)
JSP application
- transferring to a Windows CE device (2275)
JSP applications
- running (2284)
- running on a Windows CE device (2278)
- running on a Windows workstation (2276)
JSP processor (2140)
JSP support (2138)
- setting up on a Windows CE device
  - overview (2273)
- verifying on a Windows workstation (2272)
JSP Version 1.1 subsets, supported (2375)

language enablers (2858)
language support
- by operating system (2854)
- character encoding in Java applications (2197)
- overview (2851)
- UNICODE (2864)
- using language enablers (2860)
limits (2847)
Linux
- installing DB2 Everyplace (2971), (2977)
- use with C/C++ (2360)
- use with EXPLAIN statement (2472)
- use with Java (2368)
local data
- encrypting (2312)
log, interpreting (3345)
logon verification. See authentication. (3065)
Logs folder (3348)

m-Router Connect
- configuring on a device (2955)
- configuring on a workstation (2953)
message, error. See error message (3350)
messages, in SQLState (2545)
methods, Java (2722)
Metrowerks CodeWarrior (2335), (2350)
Microsoft eMbedded Visual Tools (2345)
MIDP ISync Client
- implementing (2164)
- overview (2160)
MIDP sample synchronization application (2177)
migration to version 8.1.2
- steps (2905)
mini HTTP Web server (2139)
mini HTTP Web server, configuring for JavaServer Pages on Win32 (2281)
MiniHttpConfig.properties file, example for JavaServer Pages for Win32 (2282)
MIPS processor (2223)
mirror database
- referencing in subscription (3269)
- role in synchronization (3001), (3017)
- staging tables (3002)
miscellaneous SQL or product error messages, in SQLState (2573)
Mobile Application Builder, downloading (2934)
mobile computing solution
- component products (3031)
mobile device
- changing users (3240)
- how synchronization happens (2988)
- installing DB2 Everyplace (2940)
- registering with Sync Server (3233)
- using language enablers (2859)
Mobile Devices Administration Center
- Administrator (3042)
- working with (3041)
Mobile Devices Administration Center (MDAC)
- interface (3046)
monitoring client synchronization status (3164)
MSG parameter in user exits (3367)
multiple server environment
- configuring (2899)
- planning considerations and tips (2902)
- post configuration tasks (2968)

name, providing for object
- DataPropagator subscription (3261)
- file subscription (3308)
- subscription set (3331)
names
- reserved (3060)
naming conflicts, handling (2304)
national language support
- by operating system (2855)
- character encoding in Java applications (2198)
- overview (2852)
- UNICODE (2865)
- using language enablers (2861)
native ISync Client
- overview (2156)
next(), method (2134)
NLS support
- by operating system (2856)
- character encoding in Java applications (2199)
- overview (2853)
- UNICODE (2866)
- using language enablers (2862)
no data messages, in SQLState (2548)
notebook, Create Custom Adapter (3116)
notebook, Create Custom Subscription (3162)
notebook, Create JDBC subscription (3154)
notebooks
- create mode (3190)
- edit mode (3200)
- group (3082)
Number of Result Columns, function (2649)

object. See synchronization object (3055)
object not in prerequisite state messages, in SQLState (2572)
obtaining information, for SELECT statement (2468)
On Error Resume Next, statement (2269)
online help (2846)
operating system library (2213)
order of synchronization (3122)

Palm OS
- installing DB2 Everyplace libraries (2926)
- installing DB2 Everyplace sample applications (2927)
- installing DB2 Everyplace synchronization files (2948)
- use with C/C++ (2354)
- use with GRANT statement (2484)
- use with Java (2363)
Palm OS device
- setting up for synchronization (2946)
- synchronization setup overview (2943)
- synchronizing and verifying data (2949)
Palm OS emulator
- setting up for synchronization (2947)
- synchronization setup overview (2944)
- synchronizing and verifying data (2950)
parameter markers
- ADO.NET example (2206)
- CLI example (2204)
- JDBC example (2205)
- overview (2203)
- restrictions (2534)
- untyped (2533)
parameters
- data filtering (3216)
- synchronization batches (3257), (3288)
parameters, binding (2530)
password
- subscription (3290)
password, setting
- user (3227)
PDFs (2845)
performance
- batching synchronization requests (3096), (3131)
- replicating on demand (3097), (3132), (3327)
piecemeal retrieval of data (2309)
pointers, FAR (2583)
Prepare statement, function (2651)
PreparedStatement interface (2696)
preprocessor definition (2221)
privileges
- user
  - granting for encrypted databases (2321)
  - managing for encrypted databases (2327)
problems with synchronization. See troubleshooting. (3140)
purging log entries automatically
- log and trace file, managing (3358)

QNX Neutrino
- use with C/C++ (2359)
- use with Java (2367)
- use with Metrowerks CodeWarrior (2351)
QNX Neutrino, installing files on (2930)
queues for synchronization requests (2999), (3019)

read cursor
- behavior under write conflicts (2187)
read-only media, running DB2 Everyplace from (2183)
read write conflicts (2188)
referential constraints
- in CREATE TABLE statement (2443)
refresh function (contents pane) (3192)
registering interface drivers (2680), (2693)
registration of device (3236), (3243)
Remote Query (2398)
renaming a subscription (3262)
REORG TABLE statement
- invoking internally (2504)
- purpose (2501)
replicating on demand (3101), (3136), (3324)
replication, enabling (2920)
replication subscription. See DataPropagator subscription or file subscription. (3090)
reply to synchronization (3011)
request for synchronization (2993), (3326)
- batching (3095), (3130)
reserved names (3061)
reserved words (2867)
reset function for file changes (3319)
resetting user IDs
- using a command line (3373)
- using MDAC (3372)
resetting user IDs for mobile devices (3371)
resolution of conflicts (3026)
resource not available or operator intervention messages, in SQLState (2574)
resources, releasing (2596)
ResultSet interface (2703)
ResultSetMetaData interface (2706)
rollback
- cursor behavior (2192)
ROM chips, running DB2 Everyplace from (2185)
row
- deleting, SQL statement, details (2448)
- inserting into table (2486)
- inserting values, INSERT statement (2494)
- restrictions for inserting values (2497)
- updating column values, UPDATE statement (2513)
rows in source table
- filtering in subscription (3256), (3287)

sample applications
- C/C++ (2128)
- CLP (2892)
- Java (2130)
- Java MIDP synchronization (2176)
- Java synchronization
  - GoISyncConsole (2301)
- JSP (2150)
- native synchronization (2174)
- setting up (2912)
- Sync Client C/C++ (2178)
- Visiting Nurse (2888)
  - overview (2890)
  - running (2961)
  - tables (2983)
- Visual Basic
  - overview (2135)
sample applications, description and locations (2985)
sample databases
- setting up (2909)
sample programs
- CALL statement (2402)
- Java (2261), (2264)
scrollable cursor
- behavior under write conflicts (2190)
search condition
- with DELETE, row selection (2451)
- with SELECT, row selection (2510)
- with UPDATE, applying changes to a match (2519)
security (2315)
SELECT statement (2507)
serial connection, RAS setup (3167)
serialization, connection (2182)
server groups (2900)
servlet
- testing (2913)
SET clause, UPDATE statement (2516)
Set Connection Options, function (2657)
Set Statement Options, function (2659)
setting up DB2 Everyplace Express on a server
- steps (2973), (2976)
setting up DB2 Everyplace on a mobile device
- manually (2937)
- overview (2939)
- using the Install on Mobile Devices tool (2923)
setting up DB2 Everyplace on a server
- overview (2904)
- steps (2907), (2970)
setup for synchronization
- Administrator workflow (3207)
SH3 processor (2224)
SH4 processor (2225)
SMALLINT data type (2433)
source
- how synchronization happens (3012)
source database (3265), (3267)
- how synchronization happens (2989)
- mapping (2919)
- password for subscriptions against (3292)
- staging of updates to (3005)
- user ID for subscriptions against (3294)
source file, specifying (3312), (3313)
SQL
- limits (2849)
SQL access privileges
- defining in subscription (3278)
- subscription user ID and (3296)
SQL data types
- attributes (2537)
- symbolic and default (2535)
SQL or product limit exceeded messages, in SQLState (2571)
SQL privileges
- influence on (3125)
SQL statement
- CALL (2381), (2396)
- CREATE INDEX (2382), (2404)
- CREATE TABLE (2383), (2414)
- DELETE (2384), (2447)
- DROP (2386), (2457)
- executing (2714)
- EXPLAIN
  - DB2ePLANTABLE table, columns in (2476)
  - DB2ePLANTABLE table, creating (2474)
  - list (2387)
  - purpose (2466)
- GRANT (2478)
- INSERT
  - list (2385)
  - purpose (2485)
  - restrictions (2498)
- length limitation (2392)
- overview (2380)
- precompiled (2698)
- prepared (2699)
- REORG TABLE
  - considerations (2505)
  - invoking internally (2502)
  - list (2389)
  - purpose (2499)
- REVOKE (2506)
- SELECT (2390), (2508)
- SQLExecute, function (2401)
- SQLPrepare, function (2400)
- static (2715)
- UPDATE (2388), (2512)
SQL statement support (2379)
SQLAllocConnect, deprecated function (2585)
SQLAllocEnv, deprecated function (2587)
SQLAllocHandle, function (2588)
SQLAllocHandleVer, internal function (2268)
SQLAllocStmt, deprecated function (2600)
SQLBindCol, function (2601)
SQLBindParameter, function (2526), (2603)
SQLColumns, function (2672)
SQLConnect, function (2605)
SQLDescribeCol, function (2607)
SQLDisconnect, function (2609)
SQLEndTran, function (2611)
SQLError, deprecated function (2613)
SQLExecDirect, function (2528), (2614)
SQLExecute, function (2527), (2616)
SQLFetch, function (2618)
SQLFetchScroll, function (2620)
SQLForeignKeys, function (2622)
SQLFreeConnect, deprecated function (2625)
SQLFreeEnv, deprecated function (2627)
SQLFreeHandle, function (2628)
SQLFreeStmt, deprecated function (2635)
SQLGetConnectAttr, function (2668)
SQLGetCursorName, function
- description (2636)
SQLGetData, function (2638)
SQLGetDiagRec, function (2640)
SQLGetInfo, function (2643)
SQLGetStmtAttr, function (2645)
SQLNumParams, function (2674)
SQLNumResultCols, function (2647)
SQLPrepare, function (2650)
SQLPrimaryKeys, function (2652)
SQLRowCount, function (2654)
SQLSetConnectAttr, function (2656)
SQLSetStmtAttr, function (2658)
SQLState messages
- class codes (2544)
- CLI (2578)
- JDBC (2579)
SQLSTATEs (2391), (2540)
SQLTables, function (2670)
stack size for Palm OS (2226)
staging tables (3003)
starting the Mobile Devices Administration Center (3184)
statement handle
- allocating (2592)
- descriptor (2597)
- freeing (2633)
- multiple (2594)
Statement interface (2711)
stored procedure
- calling, SQL statement instructions (2397)
subscription
- Apply qualifier (3275)
- assigning to a subscription set (3335)
- bundling in subscription set (3112)
- definition (3088)
- filtering data (3105)
- password to access source (3291)
- role in synchronization (3000)
- timing (3098), (3133), (3328)
- user ID to access source (3295)
subscription, identifying the JDBC (3249), (3321)
subscription, specify the encryption level (3250), (3264), (3310)
subscription, specify the mirror database driver and URL (3252)
subscription, specify the source database driver and URL (3251)
subscription, specifying privileges (3255)
subscription, specifying source tables (3253)
subscription, specifying target tables (3254)
Subscription field
- error messages (3355)
subscription set
- assigning subscriptions to (3317), (3334)
- assigning to group (3211)
- defined (3120), (3121)
Subscription set
Subscription set notebook (3110)
subscription set object
- assigning subscriptions to (3299)
- assigning to group (3337)
- definition (3111)
- naming (3113)
Subscription sets page
- DataPropagator subscription notebook (3298)
- File Subscription notebook (3316)
- Group notebook (3084)
Subscriptions page (Subscription set notebook) (3333)
Sun Wireless Toolkit (2296)
Sun Wireless Toolkit Command Line (2298)
Symbian
- JNI-based implementations (2291)
Symbian OS
- use with C/C++ (2355)
Symbian OS, installing files on (2929)
Symbian OS/EPOC
- use with GRANT statement (2483)
Symbian OS v6.0 device
- setting up and configuring for synchronization
  - configuring ISync on the device (2956)
  - configuring m-Router Connect on a workstation (2952)
  - configuring m-Router Connect on the device (2954)
  - overview (2951)
  - synchronizing data (2958)
Symbian OS Version 7, installing files on (2933)
symbolic and default data types, SQL (2536)
Sync Client
- Java-API overview (2154)
- sample applications
  - C/C++ (2179)
- synchronization log (3369)
- upgrading software (2942)
Sync Server
- changing devices (3242)
- configuring to use with WebSphere Application Server (2917)
- device registration (3235)
- overview (3035)
- testing the servlet (2914)
synchronization
- Apply qualifier (3277)
- authentication. See authentication. (3066)
- batching requests (3094), (3129)
- customizing for groups (3038)
- database conflicts (3025)
- disabling groups and users (3341)
- explanation of (2987)
- order (3123)
- Palm OS setup (2945)
- subscription set list (3114)
- timestamp (3030)
synchronization client software (2997)
synchronization function
- iscConfigClose() (2796)
- iscConfigCloseCursor() (2802)
- iscConfigDisableSubsSet() (2808)
- iscConfigEnableSubsSet() (2806)
- iscConfigGetNextSubsSet() (2804)
- iscConfigGetSubsSetStatus() (2816)
- iscConfigOpen() (2794)
- iscConfigOpenCursor() (2800)
- iscConfigPurge() (2798)
- iscConfigResetSubsSet() (2810)
- iscConfigSubsSetIsEnabled() (2812)
- iscConfigSubsSetIsReset() (2814)
- iscEngineClose() (2820)
- iscEngineGetInfo() (2822)
- iscEngineGetPref() (2830)
- iscEngineListenerPF (2826)
- iscEngineOpen() (2818)
- iscEngineSetListener() (2824)
- iscEngineSetPref() (2828)
- iscEngineSync() (2832)
- iscEngineSyncConfig() (2834)
- iscGetVersion() (2786)
- iscServiceClose() (2790)
- iscServiceOpen() (2788)
- iscServiceOpenEx() (2792)
Synchronization Monitor tool
- using (3165)
synchronization object
- adapter (3052)
- creating (3189)
- DataPropagator subscription (3158)
- deleting (3201)
- displaying information about (3070)
- editing (3199)
- group (3048), (3077)
- log (3053)
- subscription (3050)
- subscription set (3051), (3109)
- types (3047)
- user (3049)
- where stored (3062)
synchronization providers
- overview (2152)
synchronization queue
- batching requests (3100), (3135)
synchronization reply (3010)
synchronization request (2992)
synchronization session (2991)
- batching multiple (3093), (3128)
- replicating on demand (3102), (3137), (3325)
synchronizing data using IBM Sync (2965)
syntax
- horizontal filtering (3375)
syntax error or access rule violation messages, in SQLState (2567)
system catalog base tables, description (2838)
system ErrorResource messages, in SQLState (2575)

table
- compression
  - invoking internally (2503)
  - with SQL statement (2500)
- conflict management (3027)
- creating, on enterprise database (2444)
- creating, SQL statement instructions (2415)
- creating encrypted (2324)
- deleting, using DROP statement (2459)
- inserting row
  - with SQL statement (2487)
- maximum number for subscription (3159)
- name on mobile device, specifying (3286)
- updating by row and column, UPDATE statement (2515)
- version tracking (3028)
TABLE clause, DROP statement (2461)
table-name, in CREATE TABLE statement (2416)
tables
- limits for DB2 Everyplace (2850)
- overview of DB2 Everyplace (2180)
- system catalog base, description (2837)
target database (3266), (3268)
Target file name field (3314)
Target filename field (3311)
target table
- multiple for same source table (3284)
TIME data type (2440)
Timestamp
- error messages (3351)
TIMESTAMP data type (2441)
timing synchronization requests (3099), (3134), (3329)
toolbar
- starting Mobile Devices Administration Center (3185)
trace files. Seelog and trace file, managing (3360)
tracing level, defining
- log and trace file, managing (3359)
transaction rollback messages, in SQLState (2566)
trap-based native synchronization provider
- installing (2299)
triggered action exception messages, in SQLState (2551)
troubleshooting
- error messages and codes (3379)
troubleshooting problems
- error log, viewing (3347)
- log on client, viewing (3368)
- monitoring client synchronization status (3163)

UNICODE
- support in DB2 Everyplace (2863)
- using in Java applications (2201)
UNICODE support (2222)
UNIX
- setting up sample databases and applications (2911)
- testing the Sync Server servlet (2916)
unqualified successful completion messages, in SQLState (2546)
UPDATE, dirty bit state (2664)
update conflicts, how to handled (3020)
UPDATE privilege, allowing in subscription (3280)
UPDATE statement
- purpose (2511)
updates to source data
- staging of (3004)
updating of columns by row, positional (2517)
upload subscription, assigning a subscription set to (3306)
upload subscription, creating (3160)
upload subscription, identifying (3300)
upload subscription, specify the encryption level (3301)
upload subscription, specify the source database driver and URL (3302)
upload subscription, specifying privileges (3305)
upload subscription, specifying source tables (3303)
upload subscription, specifying target tables (3304)
user
- assigning to group (3217), (3223)
- changing devices (3241)
- creating (3150)
- data and file access, providing (3213)
- device registration (3234)
- disabling synchronization (3343)
- enabling synchronization (3340)
- evaluating group needs (3073)
- filtering data to (3230)
- importing (3244)
- naming (3221)
- password, setting (3226)
user. See user. (3072)
user-defined tables
- handling naming conflicts (2306)
user-exit interface for error handling (3361)
User name field
- error messages (3354)
User notebook (3152)
user privileges
- granting for encrypted databases (2320)
- managing for encrypted databases (2326)
Users page, Group notebook (3219)

VALUES clause
- INSERT statement, loading one row (2492)
- number of values, rules for (2493)
VARCHAR data type (2437)
version tracking for database records (3029)
vertical partitioning. See filtering data, vertical (3183)
view of objects
- filtering (3194)
- interpreting contents pane (3071)
- refreshing (3193)
Visiting Nurse application
- overview (2889)
- running (2960)
- tables (2984)

warning messages, in SQLState (2547)
warning types (2543)
WCE tooling
- installing for non-Palm targets (2243)
- installing for Palm targets (2241)
WebSphere Application Server
- configuring Sync Server to use (2918)
WHERE clause
- DELETE statement, row selection (2450)
- SELECT statement, row selection (2509)
- UPDATE statement, conditional search (2518)
WHERE clause. See filtering data. (3106)
Win32, installing files on (2932)
WinCE, installing files on (2928)
WinCE device
- setting up and configuring for synchronization
  - overview (2959)
Windows
- installing DB2 Everyplace (2908), (2974)
- installing DB2 Everyplace on mobile devices (2925)
- setting up sample databases and applications (2910)
- testing the Sync Server servlet (2915)
Windows 2000
- JNI-based implementations (2288)
- use with C/C++ (2358)
- use with EXPLAIN statement (2471)
- use with Java (2366)
- use with JavaServer Pages (2147)
- use with Visual Basic (2372)
Windows CE
- JNI-based implementations (2293)
- use with C/C++ (2356)
- use with GRANT statement (2482)
- use with Java (2364)
- use with JavaServer Pages (2145)
- use with Visual Basic (2370)
Windows NT
- JNI-based implementations (2289)
- use with C/C++ (2357)
- use with EXPLAIN statement (2470)
- use with GRANT statement (2481)
- use with Java (2365)
- use with JavaServer Pages (2146)
- use with Visual Basic (2371)
with check option violation messages, in SQLState (2568)
workflow for synchronization setup (3205)
WSDD
- creating a project for DB2eAppl.java for non-Palm targets (2244)
- creating a project for DB2eAppl.java for Palm targets (2233)
- importing DB2eAppl.java for non-Palm targets (2253)
- importing DB2eAppl.java for Palm targets (2251)
- installing WCE tooling for non-Palm targets (2242)
- installing WCE tooling for Palm targets (2240)

XML Scripting tool
- DTD (3381)
- overview (3138)
- parameters (3377)