DB2 Everyplace Characteristics
RDBMS especiallymade for m obiledevices 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 bytecharacter set) and NLV support
Encryption( communication)
IBM Microdrive and CompactFlash Memory support
DB2 Everyplace SQL
Supports a subset of SQL
CALL procedure
CREATEI NDEX( asc/desc) bidirectional
CREATETABLE
DROPTABLE/ INDEX
EXPLAIN
INSERT with subselects and default values
DELETE
UPDATE(r ecords)
SELECT( records) with
JOIN( up to 8 tables)
GROUPBY
ORDERBY (asc/desc)
LIMIT(integer) for result set
IN predicate
scrollable cursors
Page 23-24