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

Index
HP NonStop ODBC/MX Driver for Windows—691126-002
Index-3
I
I
IFNULL function, ODBC/MX 5-10
INSERT function 5-8
installation restrictions 1-8
installing
overview of 2-1
installing the client interface
requirements 2-1
step 1, download installation file 2-2
step 2, run InstallShield 2-2
step 3, add a data source 2-3
step 4, delete installation folder 2-3
INTEGER data type 5-10
INTERVAL... data type 5-11
IP address, ODBC/MX 1-2
L
LARGEINT data type 5-11
LCASE function 5-8
LEFT function 5-8
LENGTH function 5-8
LOCATE function 5-9
LOG function 5-8
LOG10 function 5-8
LONG VARBINARY data type 5-11
LONGVARCHAR data type 5-10
LOWER function 5-8
LTRIM function 5-9
M
managing
client data sources 3-1
/3-6
mapping, data types 5-13
messages 6-1/6-5
Microsoft escape clauses, support for 5-14
Microsoft ODBC
conformance to 5-1
Data Source Administrator 1-2
driver manage functions 5-2
driver manager description 1-1
driver manager restrictions 1-8
functions supported 5-2/5-7
Microsoft ODBC Data Source
Administrator 3-1
Microsoft SQL, conformance to 5-7
MINUTE function 5-9
MOD function 5-8
Module File Caching (MFC)
configuration of 4-1
design of 4-1
limitations of 4-2
troubleshooting 4-2
usage scenarios 4-2
MONTH function 5-9
MONTHNAME function 5-9
N
name types
See object name types
NonStop ODBC/MX
components, description of 1-1
data types not supported 1-11
features of 1-11
limitations of 1-12
restrictions 1-8
security 1-6
NOW function 5-9
NUMERIC data type 5-10
numeric functions supported 5-7
O
object name types
ANSI 1-6
, 1-7
ANSI for SQL/MP objects 1-7
ANSI for SQL/MX objects 1-7
Guardian in SQL commands 1-6
ODBC applications, connection
pooling 1-5/1-6










