IBM 7.2.1 manual DB2 Everyplace Characteristics, DB2 Everyplace SQL

Page 12

DB2 Everyplace Characteristics

RDBMS especially made for mobile devices and embedded systems API's

DB2 Call Level Interface (CLI) / ODBC subset

A set of C/C++ function can be called in programs to access the database JDBC and Java application support

DBCS (double byte character set) and NLV support Encryption (communication)

IBM Microdrive and Compact Flash Memory support

DB2 Everyplace SQL

Supports a subset of SQL

CALL procedure

CREATE INDEX (asc/desc) bidirectional

CREATE TABLE

DROP TABLE/INDEX

EXPLAIN

INSERT with subselects and default values

DELETE

UPDATE (records)

SELECT (records) with

JOIN ( up to 8 tables)

GROUP BY

ORDER BY (asc/desc)

LIMIT (integer) for result set

IN predicate scrollable cursors

Page 23-24

Image 12
Contents DB2 Everyplace AgendaIBM Mobile solutions-- technical overview Things to think aboutIBM DB2 Family IBM Pervasive Computing Vision DB2 Everyplace WHY?? DB2 Everyplace Sync connection optionsBusiness applications ISVs and partners Field Force Automation Gas de FranceHealthcare Asatte Asset Tracking Essential SystemsAsset Tracking Application DB2E database DB2E sync server UDB on Palm On LinuxRetail/Sales Force Automation NetSetGo Retail/Easy of Use Penn StateSystem Monitoring/Embedded X-Serwis DB2 EveryplaceDB2 Everyplace Solution DB2 Everyplace ArchitectureDB2 Everyplace Characteristics DB2 Everyplace SQLCreate table Orders CHARACTERSmallint VARCHARSmallint BLOBSmallintDB2 Everyplace Functions Sync Server Design OverviewFunctions supported Expression can beMobile device administration center Mdac is the tool to define all these object propertiesRobust Development environment Commercial Development tools contdEnd References/resourcesPackaging & Pricing Enterprise Edition