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

Page 12
Image 12
IBM 7.2.1 manual DB2 Everyplace Characteristics, DB2 Everyplace SQL