Index

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

A

AddPublicationItem method

restricting predicate, 16.1.3

administration, 19.5, 22.4

defining snapshot values, 19.5.5

granting user access, 19.5.4

setting properties, 19.5.3

ADO.NET, 2.4.3

creating database for test, 14.1.7

testing application, 14.1.7

ADO.NET provider, 3.7.1.4

classes, 14.1

creating commands, 14.1.3

DataReader.GetString method, 14.3.3

DbNull object, 14.3.3

demo, 14.2

establishing connections, 14.1.1

GetSchemaTable method, 14.3.1

large object support, 14.1.5

limitations, 14.3

OracleBlob class, 14.1.5

OracleCommand, 14.1.3

OracleConnection class, 14.1.1

OracleParameter class

ADO.NET provider, 14.1.4

performance, 14.1.4

synchronization, 14.1.6

thread safety, 14.3.4

transactions, 14.1.2

Advanced Encryption Standard, see AES

AES, see encryption

ALTER TABLE statement, 11.3.2.1, 11.3.2.5, 11.5.2.1

ALTER TRIGGER statement, 11.5.2.1

application

administration, 19.5, 22.4

Web-to-Go, 19.6

application development, 7

applications

building Web applications, 19

packaging, 19.3

publishing, 19.4

uploading, 19.4.5

apply callback, 5.2

architecture

Data Source name, 1.8

Java support, 1.7

MGP, 1.3.4

Mobile Development Kit, 1.5

Mobile Server, 1.3.3

msync, 1.3.2

Oracle Database Lite RDBMS, 1.3.1

repository, 1.3.5

supported platforms, 1.6

B

BC4J, 20.1.1

access by JSP, 20.2.5

ceating the database connection, 20.2.1

creating the BC4J component, 20.2.2

deploying, 20.7

deploying JSPs, 20.2.6

developing applications, 20.2

overview, 20.1

packaging JSPs, 20.3

publishing, 20.4

testing, 20.5

Web-to-Go, 20.6

BLOB, 2.12.1, 10.5.2, 10.5.2, 10.6

ADO.NET provider, 14.1.5

getting values, 10.5.3

query tables, 14.1.5.1

read and write data, 14.1.5.1

setting values, 10.5.3

using in parameterized SQL statements, 14.1.5.1

building applications

using BC4J, 20.1.1

Win32, 21.1, 21.2, 21.2.1

Windows CE, 22.1, 22.1.1

building Mobile applications

before you start, 19.1.1

developing, 19.2

building Mobile Web applications, 19

C

C application

get publication name, 4.2.3

initiate synchronization, 4.2.6

programmatic synchronization, 4.2

selective synchronization, 4.2.5

setting HTTP parameters, 4.2.2.2

synchronization

initialize environment, 4.2.1

C++ application

get publication name, 4.2.3

initiate synchronization, 4.2.6

programmatic synchronization, 4.2

example, 4.2

selective synchronization, 4.2.5

setting HTTP parameters, 4.2.2.2

synchronization

intialize environment, 4.2.1

Caching Publication Item Queries, 16.1.4

call specifications

creating, 11.3.1.2, 11.6.5

sample, 11.3.1.2, 11.3.1.3, 11.3.1.3, 11.3.1.5

callable statement, 11.9.2

CallableStatement class, 11.9.2

Callback Customization for DML Operations, 3.3.1.12

Calling Published Stored Procedures, 11.3.1.3

C/C++ Interface, 3.7.1.2, 4.2

classes

loading with CREATE JAVA, 11.3.1.1.2

loading with loadjava, 11.3.1.1.1

clients

subscribing to publications, 3.3.1.8

CLOB, 10.5.2, 10.5.2, 10.6

getting values, 10.5.3

setting values, 10.5.3

close method, 10.5.3

COM Interface, 3.7.1.1, 4.1

initiate synchronization, 4.1.6

ISyncProgressListener interface, 4.1.5

programmatic synchronization, 4.1.1

setting HTTP parameters, 4.1.3

setting synchronization parameters, 4.1.2

SyncOption class, 4.1.1

SyncParam, 4.1.2

TransportParam, 4.1.3

COM interface

programmatic synchronization, 4.1

complete refresh

defined in MDW, 5.2

Complete Refresh for Views, 3.8.2

compose callback, 5.2

conflict resolution

synchronization rules, 5.6.1.1

Connect to Oracle Database Lite

Type 2 Driver Connection URL Syntax, 10.3.1

Type 4 (Pure Java) Driver Connection URL Syntax, 10.3.2

Connection objects, passed as arguments, 11.4.1

connections

ADO.NET provider, 14.1.1

Consolidator Manager

modifying publication item, 3.3.1.11

consperf

query optimizer, 16.3.1.3

tuning queries, 16.3, 16.3.1

consperf utility

EXPLAIN PLAN, 16.2

CREATE FUNCTION statement, 11.3.1.2

CREATE JAVA statement, 11.3.1.1.2, 11.3.1.1.2, 11.3.1.5

CREATE PROCEDURE statement, 11.3.1.2

CREATE TRIGGER statement, 11.5.2

CreateDatabase method, 14.1.7

CREATEDB, B.2

syntax, B.2

createStatement method, 11.9.1

Creating a Dependency Hint, 3.10.1

cursors

restrictions with isolation levels, 15.4

D

Data Access Extensions

Reading from a BLOB Sample Program, 10.5.3.1

Writing to a CLOB Sample Program, 10.5.3.2

data source

creating name, 2.3.3.1

name creation, 8.3

database

accessing, 2.5.1.7

backing up, 2.7

building demo tables, 2.3.4.2

connecting, 2.3.3.3

creating, 2.3.3.2

encrypting and decrypting, 2.8

row-level locking, 15.1

starter, 2.3.2

database connection

verification using mSQL

mSQL, 2.5.1.8

database objects

creating, 22.2.1

DataReader object

limitations, 14.3.3

DataSource object, 10.4

datatypes, 10.5.1

Java, 11.4

mapping, 3.18

DECRYPDB, B.5

decryption

database, 2.8

Defining Application DDLs

Importing Views and Index Definitions, 6.1.9.1

Defining Snapshots for Replication

Creating Indexes for Snapshots, 6.1.7.2

Creating New Snapshots, 6.1.7.1

Editing Snapshots, 6.1.7.4

Importing Sequences, 6.1.8.1

Importing Snapshots, 6.1.7.3

dependency hint

creating for publication item, 5.2

creating in MDW, 5.2.2

DETACH AND DELETE statement, 11.3.2.5

Developing and Testing the Application, 7.2

developing applications

execution, 19.2.4

Developing Java Server Pages, 7.2.3

Developing Mobile Applications for PALM OS Devices

Building a SODA Application, 13.6

Building a SODA Forms Application, 13.7

Building an ODBC Application, 13.8

Customizing Oracle Database Lite Runtime, 13.10

Installing Oracle Database Lite Runtime on the Device, 13.1

Packaging your Application with Oracle Database Lite Runtime, 13.9

Running Oracle Database Lite on Palm OS Emulator, 13.3

Running Oracle Database Lite on Palm OS Simulator, 13.4

Uninstalling or Replacing Oracle Database Lite Runtime, 13.2

Using Oracle Database Lite Base Libraries, 13.5

Developing Mobile Web Applications, 7.1

development

compiling, 19.2.2

create database object, 19.2.1

registration, 19.2.3

Development and Testing

Building Web-to-Go Applications, 7.2.1

Customizing the Workplace Application, 7.2.9

Debugging Web-to-Go Applications, 7.2.8

Developing Applet JDBC Communication, 7.2.6

Developing Applet Servlet Communication, 7.2.7

Developing Java servlets for Web-to-Go, 7.2.4

Specifying Application Roles, 7.2.2

Using the Mobile Server Admin API, 7.2.10

Using Web-to-Go Applets, 7.2.5

Development Architecture, 7.2

development interfaces

for object database development, 2.4

for relational database development, 2.4

JDBC, 2.4.1

ODBC, 2.4.2

SODA, 2.4.4

DML

callback, 5.6.1.1

doCompose Method, 3.5.1.2

DROP FUNCTION statement, 11.3.1.4.2

DROP JAVA statement, 11.3.1.4.2

DROP PROCEDURE statement, 11.3.1.4.2

DROP TRIGGER statement, 11.5.3

dropjava

arguments, 11.3.1.4.1

options, 11.3.1.4.1

specifying filenames to, 11.3.1.4.1

DSN

adding, B.7.1, B.7.2

creating, 2.5.1.6

E

Embedded Visual Tools, 22

encCreateCtxt method, 17.2.1.1

encCreateKey method, 17.2.1.3

encDecryptData method, 17.2.1.5

encDeleteCtxt method, 17.2.1.2

encEncryptData method, 17.2.1.4

ENCRYPDB, B.4

encryption

APIs, 17.2.1

create key, 17.2.1.3

database, 2.8

decrypt data, 17.2.1.5

delete encryption context, 17.2.1.2

encrypt data, 17.2.1.4

initializing custom module, 17.2.1.1

plug-in custom module, 17.2.2

provide custom module, 17.2

Error queue

synchronization, 3.1

executeQuery method, 11.9.1, 11.9.1

EXPLAIN PLAN, 16.2

EXTERNAL_ENCRYPTION_DLL parameter, 17.2.2

F

fast refresh

defined in MDW, 5.2

requirements, 5.2

virtual primary key, 5.8

fast refresh and update, 3.8

Fast Refresh for Views, 3.8.1

flush method, 10.5.3

foreign key constraint, 3.9.3.2, 3.17.1.3

foreign key constraints, 3.17.1

violations, 3.17.1.1

G

getAsciiOutputStream, 10.5.2

getAsciiStream, 10.5.2

getBinaryOutputStream, 10.5.2

getBinaryStream, 10.5.2

getBLOB, 10.5.3

getBytes, 10.5.2

getCharacterOutputStream, 10.5.2

getCharacterStream, 10.5.2

getChars, 10.5.2

getCLOB, 10.5.3

getConnection, 10.5.2, 10.5.2

GetSchemaTable method

returns partial data, 14.3.1

getSubString, 10.5.2

H

HTTP

COM Interface

setting parameters, 4.1.3

setting parameters, 4.2.2.2

I

In-Queue

synchronization, 3.1

INSTEAD OF Triggers, 3.10.2

Interface Connection

Methods, 10.7.1.1

Interface Database MetaData

Methods, 10.7.4.1

Methods that Return False, 10.7.4.2

Interface PreparedStatement

Methods, 10.7.6.1

Interface ResultMetaData

Methods, 10.7.5.1

Interface ResultSet

Fields, 10.7.3.1

Methods, 10.7.3.2

Methods that Return False, 10.7.3.3

isConvertibleTo, 10.5.2, 10.5.2

isolation level

configuration, 15.3

restrictions with cursors, 15.4

isolation level, transaction, 11.9.1

isolation levels, 15.2

ISync interface, 4.1.6

ISyncOption interface, 4.1.1

ISyncProgressListener Interface, 4.1.5

J

JAR files, loading, 11.3.1.1.1

Java

datatypes

declaring parameters, 11.4.1

example, 11.4.2.2

return multiple rows, 11.4.2

development environment, 9.2

native application usage, 9.1

non-static methods, 11.3.2

static methods, 11.3.2

Java Development Tools, 9.3

Java Interface SyncParam Settings

Example 1, 4.3.5

Example 2, 4.3.5

Java Interface TransportParam Parameters

Example, 4.3.6

Java Stored Procedure

publish, 11.6.5

Java stored procedure

create trigger, 11.7

start mSQL, 11.6.1

Java stored procedures, 11.3.3

calling, 11.3.2.4, 11.3.2.4

create Java Class, 11.6.3

create table, 11.6.2

development model, 11.3.2

dropping, 11.3.1.4, 11.3.2.5

example, 11.3.1.5

Java datatypes, 11.4

JDBC, 11.9, 11.9.1, 11.9.2

load Java class, 11.6.4

ODBC, 11.3.3

publishing to SQL, 11.6.5

return multiple rows, 11.4.2.1

row-level, 11.3.2.3

SELECT statement, 11.3.2.4

table-level, 11.3.2.2

tutorial, 11.6

using dropjava, 11.3.1.4.1

using SQL Commands, 11.3.1.4.2

using triggers, 11.5

Java Stored Procedures (JSPs), see JSP

Java Stored Procedures and Triggers, 11.1, 11.2

Java Support on Windows CE

Java Interface SyncParam Settings, 4.3.5

Java Interface TransportParam Parameters, 4.3.6

Overview, 4.3.1

Sync Class, 4.3.2

SyncException Class, 4.3.3

SyncOption Class, 4.3.4

SyncProgress Listener Service, 4.3.7

Java Virtual Machine (JVM), 11.2, 11.3.2.5, 11.3.3, 11.6.4

JDBC

description, 10

extensions, 10.5

Java stored procedures, 11.9

using DataSource, 10.4

JDBC driver, 2.4.1

description, 2.4.1

JDBC Programming

Connect to Oracle Database Lite, 10.3

JDBC Compliance, 10.1

JDBC Environment Setup, 10.2

Limitations, 10.6

New JDBC 2.0 Features, 10.7

Oracle Database Lite Extensions, 10.5

JDK

setting variables, 9.2.1

JSP

access BC4J component, 20.2.5

deploying, 20.2.6

load, 11.3.1

loading classes, 11.3.1.1

publish, 11.3.1

publishing, 11.3.1.2

triggers, 11.3

using, 11.3

jvm.dll, 11.3.3

L

length method, 10.5.2, 10.5.2

linguistic sort, 2.11

Load APIs, 2.6, B.10.2.1

Load utility

overview, B.10.1

Load Utility (OLLOAD), 2.6.2

JAR files, 11.3.1.1.1

ZIP files, 11.3.1.1.1

loadjava, 11.3.1.1.1, 11.3.1.1.1

options, 11.3.1.1.1

specifying filenames to, 11.3.1.1.1

syntax, 11.3.1.1.1

locking

row-level, 15.1

M

makeJdbcArray, 10.5.2, 10.5.2

map

partititions, 16.1.5

mark method, 10.5.3

markSupported method, 10.5.3

MDK

Packaging Wizard, 1.5.2, 1.5.3

MDW

create project, 5.1

create publication item, 5.2

dependency hint, 5.2, 5.2.2

deploy publication, 5.10

overview, 1.5.2, 5

parent table hint, 5.2, 5.2.3

primary key hint, 5.2, 5.2.3

project, 1.5.2, 5

definition, 5.1

Project Wizard, 5.1

publication

creation, 5.6

publication item

creating SQL statement, 5.2.1

define refresh mode, 5.2

Publication Item Wizard, 5.2

resource

loading into project, 5.5

script, 5.4

loading into project, 5.4.2

sequence, 5.3

test publication, 5.9

test publication synchronization, 5.9

Message Generator and Processor (MGP), 1.3.4

starting, 22.4.6

MGP

apply callback, 5.2

apply phase, 1.3.4

applying changes to the database, 1.3.4

compose callback, 5.2

compose phase, 1.3.4

composing transaction, 3.1

execution process, 3.1

MIGRATE, B.6

Mobile client

synchronizing, 19.6.3

Mobile Database Workbench, see MDW

Mobile Development Kit, 1.5

mSQL, 1.5.1

Mobile Manager

application properties, 19.5.3

starting, 19.5.1

Mobile Server

logon, 19.4.4

overview, 1.3.3

mSQL, B.1, B.1

database access, B.1.2.1

SET TERM {ON|OFF}, B.1.1.3

SET TIMING {ON|OFF}, B.1.1.4

SET VERIFY {ON|OFF}, B.1.1.5

starting, B.1.1.1, B.1.2.2

Windows 32, B.1.1

Windows CE, B.1.2

populating database, B.1.1.2

msync

architecture, 1.3.2

mSync_com.dll, 4.1

MSync/OCAPIs/mSyncCom, 4.4

multithreaded programs

Java stored procedures, 11.3.3

MyCompose, 3.5.1, 3.5.1

doCompose, 3.5.1.2

needCompse Method, 3.5.1.2

MyCompose class, 5.6.1.1

N

naming stored procedures, 11.2

native application

data source name, 8.3

development, 4, 8

saving user settings, 4.2.4

supported Java functions, 9.1

supported platforms, 8.1

synchronization, 4.1

Native Application Development

Data Source Name, 8.3

Java Support, 9.1

Supported Platforms, 8.1

Using the Packaging Wizard, 6.1

native applications

clean synchronization environment, 4.2.7

selective synchronization, 4.2.5

needCompose Method, 3.5.1.2

New JDBC 2.0 Features

Interface Connection, 10.7.1

Interface Database MetaData, 10.7.4

Interface PreparedStatement, 10.7.6

Interface ResultMetaData, 10.7.5

Interface ResultSet, 10.7.3

Interface Statement, 10.7.2

non-mergable views, 16.3.1.1

O

ocapi.dll, 4.1

OCBC Administrator, 2.3.3.1

ocDoSynchronize method, 4.2.6

ocEnv class, 4.2.1

ocEnv structure, 4.2.2.1

ocGetPublication method, 4.2.3

ocSaveUserInfor method, 4.2.4

ocSessionInit function, 4.2.1

ocSessionTerm method, 4.2.7

ocTransportEnv structure, 4.2.2.2

ODBC

adding DSN, B.7.1, B.7.2

administration, B.7

development interfaces, 2.4.2

Java stored procedures, 11.3.3

ODBC driver, 2.4.2

description, 2.4.2

ODBC support

Palm, C.1

ODBINFO, B.8

optimizer

performance, 16.3.1.3

Optimizing SQL Queries

Optimizing Single-Table Queries, A.1

Oracle Database Lite

application model and architecture, 1.3

introduction, 1.1

Oracle Database Lite Extensions

Data Access Extensions, 10.5.3

Datatype Extensions, 10.5.2

Oracle Database Lite Java Support

Oracle Database Lite Java Development Environment, 9.2

Oracle Database Lite Support

Java Datatypes, 10.5.1

OracleBlob class, 14.1.5

OracleCommand class, 14.1.3

OracleConnection class, 14.1.1

OracleEngine class

CreateDatabase method, 14.1.7

OracleParameter class, 14.1.4

OracleResultSet class, 10.5.3

OracleSync class, 14.1.6

Out-Queue

synchronization, 3.1

P

packaging applications, 19.3, 19.3.6

application connection, 19.3.2

defining, 19.3.1

sequences, 19.3.4

snapshot, 19.3.3

SQL files, 19.3.5

Packaging Wizard, 1.5.2, 1.5.3, 22.3.1

packaging wizard, 19.3.1.1

sequences, 6.1.8

PALM

database tools, B.9.1

send databases, B.9.1.5

sending corrupted databases, B.9.1.4, B.9.1.4

Palm Shared Library Manager (PSLM)

Building a Shared Library Project, 13.12.4

Building an Application Using PSLM, 13.12.6

Calling a PSLM Library from Your Application, 13.12.5

Cloaked Shared Libraries, 13.12.8

Exceptions Across Modules, 13.12.7

Overview, 13.12.1

Patching the CodeWarrior Runtime, 13.12.9

Trying out PSLM, 13.12.2

Writing a PSLM Library, 13.12.3

parameters, stored procedures, 11.9.2

parent table hint

creating in MDW, 5.2.3

partition, 16.1.5

performance

ADO.NET provider, 14.1.4

EXPLAIN PLAN, 16.2

query optimizer, 16.3.1.3

SQL queries, 16.3, 16.3.1

streamlining large amount of data, 16.1.5

using map table partitions, 16.1.5

Pocket PC

installing, 22.5.1

synchronizing, 22.5.2

POLClobReader class, 10.5.3

POLClobWriter class, 10.5.3

POLJDBCDataSource object., 10.4

POLLobInputStream class, 10.5.3

POLLobOutputStream class, 10.5.3

PreparedStatement class, 11.9.1, 14.1.4

primary key

creating virtual, 5.8

primary key hint

creating in MDW, 5.2.3

primary key index, 3.3.1.5, 3.11.1

privileges

setting, 3.12

Programming interfaces

C / C++, 3.7.1.2, 4.2

COM, 3.7.1.1, 4.1

project

MDW, create, 5.1

properties

setting, 19.5.3

Provisioning Mobile Applications

Managing Snapshots, 3.2.1.1

publication

associate publication item, 5.6.1

associate resource, 5.6.4

associate script, 5.6.3

associate sequence, 5.6.2

create using MDW, 1.5.2, 5

creation, 5.6

deploy, 5.10

import existing from repository, 5.7

setting order execution for publication items, 5.6.1.1

specifying conflict resolution rules, 5.6.1.1

test synchronization, 5.9

test using MDW, 5.9

publication item

associate with publication, 5.6.1

create using MDW, 5.2

creating SQL query, 5.2

creating SQL statement, 5.2.1

dependency hint, 5.2

execution order, 5.6.1.1

import from repository, 5.7

modifying, 3.3.1.11

setting priority, 5.6.1.1

publications

subscribing clients to, 3.3.1.8

publish applications, 19.4

create database account, 19.4.1

publishing application

create database objects, 19.4.2

publishing applications

logon to the Mobile Server, 19.4.4

start the Mobile Server, 19.4.3

uploading, 19.4.5

publishing stored procedures, 11.6.5

putBytes, 10.5.2

putChars, 10.5.2

putString, 10.5.2

Q

query

optimizer, 16.3.1.3

query optimizer, A.2.2

querying

in JDBC, 11.9.1

Queue Interface, 3.15

queue-based refresh

defined in MDW, 5.2

queues

involved in synchronization, 3.1

R

RDBMS

creating multiple users, 2.3.4

development interfaces, 2.4

linguistic sort, 2.11

Read-Only Snapshots, 3.2.1.1.1

ready method, 10.5.3

Refresh

complete, 3.8.2

fast, 3.8.1

refresh mode

defined in MDW, 5.2

Refreshing a Snapshot, 3.2.1.1.3

REMOVEDB, B.3

repository

architecture, 1.3.5

reset method, 10.5.3

resource

associate with publication, 5.6.4

import from repository, 5.7

loading into MDW project, 5.5

Restricting Predicate, 3.3.1.13

restricting predicate, 3.3.1.13, 16.1.3

row-level triggers, 11.2

S

schema object names, 11.3.1.1.1

script

adding to publication in MDW, 5.4

associate with publication, 5.6.3

import from repository, 5.7

testing, 5.4.1

SELECT statement

Java stored procedures, 11.3.2.4

selective synchronization

COM Interface, 4.1.4

sequence

associate with publication, 5.6.2

creating in MDW, 5.3

definition, 5.3

import from repository, 5.7

sequences

changing increment value, 6.1.8

synchronization, 3.3.1.7

Servlets

registering, 19.2.3

setSyncFlag method, 4.1.1

shared maps

grouping function to force sharing, 5.6.1.1

skip method, 10.5.3

snapshot

read-only, 5.6.1.1

updatable, 5.6.1.1

snapshot definitions

declarative, 3.2.1

programmatic, 3.2.2

Snapshot Template Variables, 3.2.1.1.4

snapshots

defining, 22.3.3

SQL

EXPLAIN PLAN, 16.2

parsing in ADO.NET provider, 14.1.4

tuning queries, 16.3, 16.3.1

using mSQL, B.1

SQLAllocConnect, C.1.1, C.1.1, C.1.1, C.1.1

SQLAllocEnv, C.1.2

SQLAllocHandle, C.1.3, C.1.3

SQLAllocStmt, C.1.4

SQLBindCol, C.1.16

SQLBindParameter, C.1.11

SQLConnect, C.1.9

SQLDescribeCol, 11.4.2.1, 11.4.2.2, C.1.17

SQLDisconnect, C.1.10

SQLError, C.1.18

SQLExecDirect, C.1.13

SQLExecute, C.1.14

SQLFetch, C.1.15

SQLFreeConnect, C.1.5

SQLFreeEnv, C.1.6

SQLFreeHandle, C.1.7

SQLFreeStmt, C.1.8

SQLGetData, C.1.19

SQLNumResultCols, 11.4.2.1, 11.4.2.2, C.1.20

SQLPrepare, C.1.12

SQLRowCount, C.1.21

SQLTransact, C.1.22

statement-level triggers, 11.2

stored procedures

calling, 11.9.2

description, 11.2

naming, 11.2

Sync Class

Constructors, 4.3.2

Public Methods, 4.3.2

Sync Client

downloading data, 3.1

Sync Server

execution process, 3.1

uploading data, 3.1

SyncException Class

Constructors, 4.3.3

Public Methods, 4.3.3

Synchronization

Add Map Table Partitions, 16.1.5.2

Change Password, 3.3.1.1.1

Client Device Database DDL Operations, 3.4, 3.11.1

Compose Phase Customization, 3.5.1

Create a Map Table Partition, 16.1.5.1

Defining Conflict Rules, 3.3.1.6.1

Defining Publication Items, 3.3.1.3.1

DownloadInfo Class Access Methods, 3.14.2

Drop a Map Table Partition, 16.1.5.3

Drop all Map Table Partitions, 16.1.5.4

Extending MyCompose, 3.5.1.3

Extending MyCompose as a User Defined Sub-Class, 3.5.1.1, 3.5.1.2, 3.5.1.4

getDownloadInfo Method, 3.14.1

Merge Map Table Partitions, 16.1.5.5

PublicationSize Class, 3.14.3

Publish and Subscribe Model, 3.3

Publishing Synonyms, 3.13.1

Remote Database Link Support, 3.13, 3.13.2

Sync Discovery API, 3.14

synchronization

ADO.NET provider, 14.1.6

C applications, 4.2

C++ applications, 4.2

clean environment, 4.2.7

COM Interface

initiate, 4.1.6

composing transaction, 3.1

downloading data, 3.1

errors, 5.6.1.1

execution steps, 3.1

native application, 4.1

native applications

initiate, 4.2.6

performance, 16.1.5

queues, 3.1

selective, 4.2.5

COM Interface, 4.1.4

sequences, 3.3.1.7

subscribing users, 3.3.1.8

tracking progress, 4.1.5

uploading data, 3.1

using APIs, 3.7.1

synchronizing

Mobile client, 19.6.3

Pocket PC, 22.5.2

SyncOption Class

Constructors, 4.3.4

Example, 4.3.4

Public Methods, 4.3.4

SyncOption class, 4.1.1

selective synchronization, 4.1.4

SyncParam object, 4.1.2

SyncProgress Listener Service

Example, 4.3.7

Method, 4.3.7

T

table

attaching a Java class, 11.3.2.1

tables

building, 2.3.4.2

users sharing, 5.6.1.1

thread safety

ADO.NET provider, 14.3.4

threads

invoking Java stored procedures, 11.3.3

toJdbc method, 10.5.2, 10.5.2

tracing, 18

transactions, 15

ADO.NET provider, 14.1.2

configuring isolation level, 15.3

isolation levels, 11.9.1, 15.2

locking, 15.1, 15.1

TransportParam object, 4.1.3

trigger

testing, 11.7.1

triggers

arguments, 11.5.5

example, 11.5.6

creating, 11.5.2, 11.7

description, 11.2

dropping, 11.5.3

enabling and disabling, 11.5.2.1

example, 11.5.4

row-level, 11.2

statement-level, 11.2

statement-level vs. row-level, 11.5.1

troubleshooting

sequences, 3.3.1.7

truncate command, 16.1.5.1, 16.1.5.2, B.10.2.2.3

U

Updatable Snapshots, 3.2.1.1.2

user

granting access, 19.5.4

large amounts of data, 16.1.5

subscribing, 3.3.1.8

users

defining snapshot values, 19.5.5

Using Mobile Sync for Palm

Configuring mSync, 13.11.1

Using HotSync to Synchronize Data with the Mobile Server, 13.11.2

Configuring HotSync for a PalmOS Device, 13.11.2.1

Configuring PalmOS Emulator for HotSync, 13.11.2.3

HotSync Timeout Errors, 13.11.2.2

Using Network Sync, 13.11.3

Network Sync With PalmOS Emulator, 13.11.3.2

Synchronizing Using a Cradle and Windows Desktop, 13.11.3.1

Using the Packaging Wizard for Web Applications

Adding Servlets, 6.1.4

Defining Application DDLs, 6.1.9

Defining Application Roles, 6.1.6

Defining Sequences for Replication, 6.1.8

Defining Snapshots for Replication, 6.1.7

Editing Applications, 6.1.10

Entering Database Information, 6.1.5

Listing Application Files, 6.1.3

Naming New Applications, 6.1.2

Starting the Packaging Wizard, 6.1.11

V

VALIDATEDB, B.9

ValidateDB

execution, B.9.1.3

installation, B.9.1.2

VBScript

native applications, 4.1

view

parent table hint, 5.2.3

primary key hint, 5.2.3

specifying parent table hint, 5.2

specifying primary key hint, 5.2

views

fast refresh and update, 3.8

non-mergable, 16.3.1.1

Virtual Primary Key, 3.11.2

Visual Basic

native application, 4.1

W

Web-to-Go

install the client, 19.6.1

Web-to-go

client installation, 19.6.1

Win32

command sequence, 21.2.1

Windows CE

compilation, 22.2.3

creating database object, 22.2.1

developing applications, 22.2

packaging, 22.3

publishing, 22.3

using the Packaging Wizard, 22.3.1

writing application code, 22.2.2

write method, 10.5.3, 10.5.3

Z

ZIP files, loading, 11.3.1.1.1