DSNREXX Support (Technology Preview)

Note: This is a technology preview feature only. It is being made available to allow you to test and provide feedback on this new capability; however, this feature is not intended for production use and it is not supported as such.

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 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