6.
Embedded Language Syntax
This chapter explains the syntax and structure of the embedded language.
Organization of this chapter
General rules
BEGIN DECLARE SECTION (Declare beginning of embedded SQL)
END DECLARE SECTION (Declare end of embedded SQL)
ALLOCATE CONNECTION HANDLE (Allocate connection handle)
FREE CONNECTION HANDLE (Release connection handle)
DECLARE CONNECTION HANDLE SET (Declare connection handle to be used)
DECLARE CONNECTION HANDLE UNSET (Reset all connection handles being used)
GET CONNECTION HANDLE (Get connection handle)
COPY (Include library text)
GET DIAGNOSTICS (Retrieve diagnostic information)
COMMAND EXECUTE (Execute commands from a UAP)
SQL prefix
SQL terminator
WHENEVER (Declare embedded exception)
SQLCODE variable
SQLSTATE variable
PDCNCTHDL type variable declaration
INSTALL JAR (Register JAR file)
REPLACE JAR (Re-register JAR file)
REMOVE JAR (Remove JAR file)