Mainframe Batch Database Tools (MBDT)

The MBDT toolset provides basic batch utility support for the following z/OS DB2 utilities:

DSNTIAUL: Enables you to unload your data from the target DBMS, using an SQLTUL alias.
Attention: This feature is in Early Adopter Program (EAP) release status. We intend to provide the finalized feature in a future release. Please contact OpenText Support for Micro Focus Products if you require further clarification.
DSNTEP2: Enables you to execute SQL DDL and DML in a target DBMS using an SQLTP2 alias.
DSNTEP2 accepts native DBMS DDL and DML syntax for DB2 LUW, Oracle, and SQL Server by default. DSNTEP2 also accepts z/OS DB2 DDL and DML syntax for SQL Server. See MBDT Configuration Utility for details.
DSNUTILB: Enables you to load or unload your data to or from the target DBMS using an SQLUTB alias.

The versions of DSNTIAUL, DSNTEP2 and DSNUTILB provided by Micro Focus initialize the OpenESQL compiler directives required to set up the appropriate environment parameters, and then call OpenESQL runtime functions. They always use ODBC to communicate with target DBMSs. To enable ODBC support, you must define an XAR to Enterprise Server that uses the ODBC generic one-phase commit switch module. See Generic One-phase Commit for ODBC RM Switch Module for details.

Note: We provide MBDT for DB2 LUW, DB2 for z/OS, SQL Server, Oracle, and PostgreSQL. MBDT does not support the loading and unloading of true DBCS data (Chinese, Japanese and Korean) if the local client codepage is UTF-8.