IBM 7.2.1 Computer Accessories User Manual


 
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