JCL
Lists supported and tested databases that can be used with the JCL
DSNREXX and
Mainframe Batch Data Tools features of
Enterprise Developer.
DSNREXX
- Availability - Windows platforms
-
Feature/Platform 32-bit 64-bit x86-64 running Windows 
- Availability - UNIX platforms
-
Feature/Platform 32-bit 64-bit x86-64 running Red Hat Linux
x86-64 running SUSE Linux
IBM System p running AIX
- OpenESQL
- DSNREXX is supported in OpenESQL applications, and is native code using ODBC. See the OpenESQL section in the Database Management Systems (DBMSs) topic for additional software requirements, and the DSNREXX Support topics for complete details.
- Testing
-
On Windows platforms, this release of DSNREXX was tested with:
- DB2 LUW 10.5 and later
- SQL Server 2014 and later
On UNIX platforms, this release of DSNREXX was tested with DB2 LUW 10.5.
Mainframe Batch Database Tools (MBDT)
- Availability - Windows platforms
-
Feature/Platform 32-bit 64-bit x86-64 running Windows
- Availability - UNIX platforms
-
Feature/Platform 32-bit 64-bit x86-64 running Red Hat Linux
x86-64 running SUSE Linux
IBM System p running AIX
- OpenESQL
- The MBDT toolset consists of OpenESQL applications, and are native code using ODBC. See the OpenESQL section in the Database Management Systems (DBMSs) topic for further details.
- Testing
- For this version, MBDT was tested with:
- DB2 LUW 11.1 and 11.5
- Oracle 19c and 21c
- On Windows platforms - SQL Server 2016 and later
- On UNIX platforms - SQL Server 2017 and later
- GDG and EDB PostgreSQL 12.x, 13.x, and 14.x
- Amazon RDS and AWS Aurora for PostgreSQL 12.x, 13.x, and 14.x