ODBC/MX Driver for Windows Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)
Table Of Contents
- HP NonStop ODBC/MX Driver for Windows
- Legal Notices
- Contents
- What’s New in This Manual
- About This Manual
- 1 ODBC/MX Client Overview
- 2 Installation of the ODBC/MX Client
- 3 Configuring Client Data Sources on Windows
- Accessing the Microsoft ODBC Data Source Administrator from a Client Workstation
- Adding New Client Data Sources
- Reconfiguring Client Data Sources
- Configuring Client Data Sources using Connection String
- Configuring Client Data Sources for Update Operations
- Configuring Driver for IPV6
- Removing Client Data Sources
- Tracing Client Data Sources
- 4 Module File Caching (MFC)
- 5 ODBC/MX Conformance
- ODBC API Functions
- SQL Conformance Level
- SQL Scalar Functions
- ODBC Data Types
- Unsigned Data Types
- Partial Date/Time Values
- SQL/MP Data Types and ODBC/MX Equivalents
- Microsoft Escape Clauses
- Stored Procedures
- Transactions and Cursor Behavior with Multiple Statements
- Timestamp Values with Fraction
- SQL Interval Insertion Property
- SQL Datetime Retrieval Property
- 6 ODBC/MX Messages
- Glossary
- Index
HP NonStop ODBC/MX Driver for Windows—691126-002
4-1
4 Module File Caching (MFC)
MFC Overview
Before the H06.18/J06.07 RVU, the ODBC/MX driver did not cache the NonStop
SQL/MX prepared statements. As a result, applications recompiled the same SQL/MX
statements, causing higher host processor and memory utilization, which lead to poor
performance.
The Module File Caching (MFC) feature shares the SQL/MX prepared statement plans
among the SQL/MX database connections. It helps in reducing the SQL/MX
compilation time during the steady state of the ODBC application, thereby reducing
resource consumption.
MFC Design
For information on the MFC design, see the HP NonStop SQL/MX Connectivity Service
Manual.
Configuring MFC
For information on configuring MFC, see the HP NonStop SQL/MX Connectivity
Service Manual.
MFC Overview 4-1
MFC Design 4-1
Configuring MFC 4-1
MFC Usage Scenarios 4-2
MFC Limitations 4-2
Troubleshooting MFC 4-2
Note. Module File Caching is supported only on systems running J06.07 and later J-series
RVUs and H06.18 and later H-series RVUs. Starting with SQL/MX Release 3.2, MFC supports
the BigNum data type in parameterized queries.