IBM SC34-5764-01 Server User Manual


 
SQL Interface
REXX programs may contain SQL statements. These statements are interpreted and executed
dynamically. The results of the SQL statements are placed into REXX variables for use within the REXX
program.
Programming Considerations
To embed SQL statements withn a REXX exec, the host command environment must be changed, The
ADDRESS instruction, followed by the name of the environment, is used to change the host command
environment.
The REXX/CICS command envlironment that supports SQL statements is EXECSQL.
Embedding SQL statments
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
How to Read the Syntax Diagrams
Throughout this book, syntax is described using the structure defined below.
v Read the syntax diagrams from left to right, from top to bottom, following the path of the line.
The ─── symbol indicates the beginning of a statement.
The ─── symbol indicates that the statement syntax is continued on the next line.
The ─── symbol indicates that a statement is continued from the previous line.
The ─── symbol indicates the end of a statement.
Diagrams of syntactical units other than complete statements start with the ─── symbol and end with
the ─── symbol.
Introduction
106
CICS TS for VSE/ESA: REXX Guide