DSNREXX Support

Attention: This feature is in Early Adopter Program (EAP) release status. We intend to provide the finalized feature in a future release. Please contact Micro Focus Customer Care if you require further clarification.

The Micro Focus support parallels DSNREXX on DB2 for z/OS but with the following limitation: Micro Focus DSNREXX is currently only available under Enterprise Server using the ODBC XA switch module on Windows platforms for SQL Server and DB2 LUW only. Additionally, UNIX support for DB2 LUW is available on some platforms. See Additional Software Requirements on Windows or Additional Software Requirements for Micro Focus Enterprise Developer Unix Components for more information.

The following table shows REXX static SQL statements and indicates whether they are supported using DB2 LUW:

REXX Statement	Supported	Notes
CALL	Partially	Only supports non-result set CALLs.
CLOSE	Yes
CONNECT	Yes
DECLARE CURSOR	Yes
DESCRIBE prepared statement	Yes
DESCRIBE CURSOR	No
DESCRIBE INPUT	Yes
DESCRIBE PROCEDURE	No
EXECUTE	Yes
EXECUTE IMMEDIATE	Yes
FETCH	Yes
OPEN	Yes
PREPARE	Yes
RELEASE connection	Partially	Syntax supported - Only performs a DISCONNECT.
SET CONNECTION	No
SET CURRENT PACKAGE PATH	Yes
SET CURRENT PACKAGESET	Partially	See Setting Isolation Level.
SET host variable = CURRENT DATE	Yes
SET host variable = CURRENT DEGREE	Yes
SET host variable = CURRENT MEMBER	Yes
SET host variable = CURRENT PACKAGESET	No	DB2 LUW does not support this special register.
SET host variable = CURRENT PATH	Yes
SET host variable = CURRENT SERVER	Yes
SET host variable = CURRENT SQLID	Yes
SET host variable = CURRENT TIME	Yes
SET host variable = CURRENT TIMESTAMP	Yes
SET host variable = CURRENT TIMEZONE	Yes

The following table shows REXX static SQL statements and indicates whether they are supported using SQL Server with HCOSS.

Note: You must run the HCOSS install scripts before trying to access the supported special registers. See DSN command for more information.

REXX Statement	Supported	Notes
CALL	No
CLOSE	Yes
CONNECT	Yes
DECLARE CURSOR	Yes
DESCRIBE prepared statement	Yes
DESCRIBE CURSOR	No
DESCRIBE INPUT	Yes
DESCRIBE PROCEDURE	No
EXECUTE	Yes
EXECUTE IMMEDIATE	Yes
FETCH	Yes
OPEN	Yes
PREPARE	Yes
RELEASE connection	Partially	Syntax supported - Only performs a DISCONNECT.
SET CONNECTION	No
SET CURRENT PACKAGE PATH	No	HCOSS/SQL Server does not support this special register.
SET CURRENT PACKAGESET	Partially	See Setting Isolation Level.
SET host variable = CURRENT DATE	Yes
SET host variable = CURRENT DEGREE	No	HCOSS/SQL Server does not support this special register.
SET host variable = CURRENT MEMBER	No	HCOSS/SQL Server does not support this special register.
SET host variable = CURRENT PACKAGESET	No	HCOSS/SQL Server does not support this special register.
SET host variable = CURRENT PATH	No	HCOSS/SQL Server does not support this special register.
SET host variable = CURRENT SERVER	Yes
SET host variable = CURRENT SQLID	Yes
SET host variable = CURRENT TIME	Yes
SET host variable = CURRENT TIMESTAMP	Yes
SET host variable = CURRENT TIMEZONE	Yes

The SET CURRENT SCHEMA statement is not supported. For example:

Sqlsmt = "SET CURRENT SCHEMA PRODA"
ADDRESS DSNREXX "EXECSQL EXECUTE IMMEDIATE :Sqlsmt"

You must start each SQL statement with EXECSQL, followed by either:

An SQL statement enclosed in single or double quotes.
A REXX variable that contains the SQL statement.

For example:

ADDRESS DSNREXX EXECSQL “ROLLBACK”

rexxvar=”ROLLBACKT”
ADDRESS DSNREXX EXECSQL rexxvar