Index

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

A

ALL_CONS_COLUMNS

system catalog object, A.1.3

ALL_CONSTRAINTS

system catalog object, A.1.2

ALL_IND_COLUMNS

system catalog object, A.1.5

ALL_INDEXES

system catalog object, A.1.4

ALL_OBJECTS

system catalog object, A.1.6

ALL_SEQUENCES

system catalog object, A.1.7

ALL_SYNONYMS

system catalog object, A.1.8

ALL_TAB_COLUMNS

system catalog object, A.1.10

ALL_TAB_COMMENTS

system catalog object, A.1.11

ALL_TABLES

system catalog object, A.1.9

ALL_USERS

system catalog object, A.1.12

ALL_VIEWS

system catalog object, A.1.13

applications

editing with Packaging Wizard, 6.8.6

listing files, 6.5

naming with Packaging Wizard, 6.4

publishing, 6.8.5

Applications panel

in Packaging Wizard, 6.4

B

BLOB, B.1.15

C

CAT

system catalog object, A.1.14

Change Password, 3.3.4.2

CHAR, 3.2.2, B.1.15

client databases

creating, 3.1.2

clients

subscribing to publications, 3.3.10

CodeWarrior, 5.2.1.4

creating a project, 5.2.4

COLUMN_PRIVILEGES

system catalog object, A.1.15

COMMIT, B.1.10

configuring transport

Palm Computing Platform devices, 5.3.2.3

conflicts, 3.1.8

CREATE INDEX, B.1.4

CREATE TABLE, B.1.2, B.1.2, B.1.2

Create User, 3.3.4.1

Creating Snapshot Definitions, 1.4.2

D

database interfaces

ODBC, 1.3

OKAPI, 1.3

Database panel

in Packaging Wizard, 6.6

database support, 3.1.3

databases

creating, 5.2.2

creating with Mobile SQL, 5.2.3, 5.2.3.3

datatypes

mapping, 3.2

Oracle Lite, 3.2.1

Satellite Forms, 3.2.2

support, B.1.15

DATE, 3.2.2, B.1.15

date functions, B.1.17

DDL operations, 3.1.2

DECIMAL, B.1.15

Defining Customized DML Operations, 3.4.3

DELETE, B.1.5

development environment

configuring, 2.2

Palm Computing Platform, 2.2.1

installing, 2.2.1.1

Development Process, 1.4

development tools

Palm Computing Platform, 5.2.1

DOUBLE, B.1.15

DOUBLE PRECISION, 3.2.2

driectory structure

Palm Computing Platform, 2.2.1.2

DROP TABLE, B.1.3

Drop User, 3.3.4.3

DRPO INDEX, B.1.6

DUAL

system catalog object, A.1.17

E

emulator, 1.4.3

Palm Computing Platform, 5.2.1.5

environment support

EPOC, 1.2

Palm Computing Platform, 1.2

errors, 3.1.8

F

fast refresh and update, 3.1.6

Files panel

in Packaging Wizard, 6.5

FLOAT, 3.2.2, B.1.15

foreign key constraint, 3.1.7.2

foreign key constraints, 3.1.7

violations, 3.1.7.1

G

GNU GCC, 5.2.1.3

group functions, B.1.16

H

hints, 3.1.6.2

HotSync

reassigning button, 5.3.2.5

HTTP transport

Palm Computing Platform, 5.3.2.4

I

indexes

creating for publicatoin items, 3.3.8

INSERT, B.1.7

Installation, 1.4.1

INSTEAD OF triggers, 3.1.6.2

INT, B.1.15

INTEGER, 3.2.2, B.1.15

J

jar files

packaging with Packaging Wizard, 6.8.2

L

LONG RAW, 3.2.2, 3.2.2, 3.2.2, 3.2.2

M

Message Generator and Processor, 3.1

Mobile Server

configuring, 1.4.3

overview, 1.1.5, 3.1

Mobile SQL, 5.2.1.1

creating databases with, 5.2.3.3

installing, 5.2.3.1

starting, 5.2.3.2

using SQL statements, 5.2.3.5

viewing tables with, 5.2.3.4

N

NUMBER, 3.2.2, B.1.15

NUMERIC, B.1.15

O

object naming, 3.1.5

ocTransportEnv, 5.1.4.2

ODBC, 1.3.1

developing with, 5.1.1

ODBC support

Palm Computing Platform, C.1

OKAPI, 1.3.2

developing with, 5.1

P

Packaging Wizard

Applications panel, 6.4

Database panel, 6.6, 6.6

editing snapshots with, 6.7.3

Files panel, 6.5

importing snapshots with, 6.7.2

packaging jar files, 6.8.2

Snapshots panel, 6.7

sorting files with, 6.5.1

starting, 6.2

Palm Computing Platform

database support, 1.1.5

developing applications for, 5.2

native applications support, 1.1.5

parent tables

hints, 3.1.6.2

INSTEAD OF triggers, 3.1.6.2

updatable, 3.1.6.1, 3.1.6.1

partitioning replicated sequences, 3.3.12

PL/SQL, 3.1.4

Platform Selection, 6.3

primary key index, 3.1.2

publication, 3.1.1, 3.3

publication item, 3.3

publication items

adding to publications, 3.3.9

creating, 3.3.6

creating indexes, 3.3.8

publications

creating, 3.3.5

subscribing clients to, 3.3.10

publish/subscribe, 1.1.5

publish/subscribe model, 3.1.1, 3.3

implementing, 3.3.1

purging transactions, 3.4.6.2

R

REAL, B.1.15

replicated sequences

creating, 3.3.11

partitioning for clients, 3.3.12

replication

conflicts, 3.1.8

errors, 3.1.8

with emulator, 1.4.4

requirements

general, 2.1

Oracle8, 2.1

Restricting Predicate, 3.4.5

Retrieving Publication Item Names, 3.3.7

ROLLBACK, B.1.11

S

Sample Orders Application

files, 4.2

installing on device, 4.5

preparing server for, 4.3

using on Palm Computing Platform, 4.4

Satellite Forms

datatypes, 3.2.2

SELECT, B.1.8

SMALLINT, 3.2.2, B.1.15

SNAPSHOTS

system catalog object, A.1.18

snapshots

creating with Packaging Packaging Wizard

Snapshots panel, 6.7.1

editing, 6.7.3

importing, 6.7.2

Snapshots panel

in Packaging Wizard, 6.7

Snapshots, creating definitions, 1.4.2

SQL statements

supported on Palm Computing Platform, B.1.1

SQL support

Palm Computing Platform, 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, 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, C.1.20

SQLPrepare, C.1.12

SQLRowCount, C.1.21

SQLTransact, C.1.22

subscription, 3.1.1, 3.3

subscription parameters, 3.3

defining, 3.3.13

subscriptions

instantiating, 3.3.14

system catalog objects

ALL_CONS_COLUMNS, A.1.3

ALL_CONSTRAINTS, A.1.2

ALL_IND_COLUMNS, A.1.5

ALL_INDEXES, A.1.4

ALL_OBJECTS, A.1.6

ALL_SEQUENCES, A.1.7

ALL_SYNONYMS, A.1.8

ALL_TAB_COLUMNS, A.1.10

ALL_TAB_COMMENTS, A.1.11

ALL_TABLES, A.1.9

ALL_USERS, A.1.12

ALL_VIEWS, A.1.13

CAT, A.1.14

COLUMN_PRIVILEGES, A.1.15

DUAL, A.1.17

SNAPSHOTS, A.1.18

TABLE_PRIVILEGES, A.1.19

USER_OBJECTS, A.1.20

system catalog views, A

T

TABLE_PRIVILEGES

system catalog object, A.1.19

Testing

with device, 1.4.6

TIME, B.1.15

TIMESTAMP, B.1.15

transactions

executing, 3.4.6.1

purging, 3.4.6.2

transport

configuring

Palm Computing Platform, 5.3.2.3

Transport protocols

support, 1.1.5

U

UPDATE, B.1.9

USER_OBJECTS

system catalog object, A.1.20

V

VARCHAR, 3.2.2, B.1.15

VARCHAR2, 3.2.2, B.1.15

versioning, 3.1.8.1

views

fast refresh and update, 3.1.6

Virtual Primary Key, 3.4.4

W

winning rules, 3.1.8.2

X

XML file, 6.8.1