IBM 7.2.1 Manual do Utilizador descarregar pdf (Página 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

1 2 ... 7 8 9 10 11 12 13 14 15 16 17 18

Sem comentários

IBM 7.2.1 Manual do Utilizador Página 12