Embedding SQL statments

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

Task Task

Feedback


Timestamp icon Last updated: Tuesday, 7 January 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic/com.ibm.cics.rexx.doc//dfhrx/dfhrx00077.html