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