Supported executable SQL statements can be issued interactively from the
mobiles Gerät by using the command line processor (CLP), or they can be used
in application programs to access data in a DB2 Everyplace database. Tabelle 14 lists the SQL statements supported by DB2 Everyplace.
Tabelle 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.
Zugehörige Referenzen