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
Module File Caching (MFC)
HP NonStop ODBC/MX Driver for Windows—691126-002
4-2
MFC Usage Scenarios
MFC Usage Scenarios
The benefits of lower processor and memory utilization mentioned below are
applicable on the NonStop Server:
ODBC/MX applications using SQLPrepare() and SQLExecDirect() have the
benefit of lower processor utilization, lower memory consumption, and better
response time.
ODBC/MX applications using complex queries through prepare calls and
executedirect calls have higher benefit of lower processor utilization, lower memory
consumption, and better response time.
ODBC/MX applications, which have large number of statements that are SQL
compiled at the startup, can benefit from reduced (re-) startup time by using the
MFC feature. In situations, where servers are configured for automatic restart, the
startup time is reduced.
MFC Limitations
For information on MFC limitations, see the HP NonStop SQL/MX Connectivity Service
Manual.
Troubleshooting MFC
For information on troubleshooting, see the HP NonStop SQL/MX Connectivity Service
Manual.