About this task
You can pass the following SQL statements directly to the EXECSQL
command environment:
- ALTER
- CREATE
- COMMENT ON
- DELETE
- EXPLAIN
- INSERT
- GRANT
- INSERT
- LABEL ON
- LOCK
- REVOKE
- SELECT
- UPDATE
You cannot use the following SQL statements:
- BEGIN DECLARE SECTION
- CLOSE
- COMMIT
- CONNECT
- DECLARE CURSOR
- DESCRIBE
- END DECLARE SECTION
- EXECUTE
- EXECUTE IMMEDIATE
- FETCH
- INCLUDE
- OPEN
- PREPARE
- ROLLBACK
- WHENEVER