DSNREXX Support

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:

For example:

ADDRESS DSNREXX EXECSQL “ROLLBACK”
rexxvar=”ROLLBACKT”
ADDRESS DSNREXX EXECSQL rexxvar