Supported executable SQL
statements can be issued interactively from the 모빌 디바이스 by using the
command line processor (CLP), or they can be used in application programs
to access data in a DB2 Everyplace database. 표 14 lists the SQL statements
supported by DB2 Everyplace.
표 14. Supported SQL statements
| SQL statement |
Function
|
|---|---|
| CALL | Calls a remote stored procedure using the DB2 Everyplace Sync Server Remote Query and Stored Procedure Adapter (AgentAdapter) |
| CREATE INDEX | Creates an index. |
| CREATE TABLE | Defines a table. |
| DELETE | Deletes one or more rows from a table. |
| DROP | Deletes a table or index from a database. |
| EXPLAIN | Obtains information about access path selection for a SELECT statement. |
| GRANT | Grants encryption privileges to a user. |
| INSERT | Inserts one or more rows into a table. |
| REORG TABLE | Removes or reduces the wasted storage associated with the specified table. |
| REVOKE | Revokes a user's encryption privileges. |
| SELECT | Specifies a result table queried from one or more tables. |
| UPDATE | Updates the values of one or more columns in one or more rows of a table. |
SQLState messages reported by SQL lists all of the SQLSTATEs reported by the DB2 Everyplace SQL engine.
The length of an SQL statement cannot exceed 64,000 characters.
The catalog includes the following DB2 Everyplace system tables that are managed by DB2 Everyplace: DB2eSYSTABLES, DB2eSYSRELS, and DB2eSYSCOLUMNS.
Related reference