HP NonStop ODBC/MX Driver for Windows for SQL/MX Release 3.1 Abstract This manual describes how to install and configure HP NonStop™ ODBC/MX for Microsoft® Windows. This product enables applications developed for the Microsoft Open Database Connectivity (ODBC) application programming interface to use HP NonStop SQL/MX to access HP NonStop SQL databases on an HP NonStop system. Product Version HP NonStop ODBC/MX 3.1 Supported Release Version Updates (RVUs) This manual supports J06.
Document History Part Number Product Version Published 640329-001 HP NonStop ODBC/MX 3.0 February 2011 663858-001 HP NonStop ODBC/MX 3.
Legal Notices Copyright 2011 Hewlett-Packard Development Company L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license. The information contained herein is subject to change without notice.
HP NonStop ODBC/MX Driver for Windows for SQL/MX Release 3.1 Glossary Index Figures Tables Legal Notices What’s New in This Manual v Manual Information v New and Changed Information About This Manual vii Audience vii Related Documentation vii Notation Conventions xi HP Encourages Your Comments v xii 1.
Contents 2. Installation of the ODBC/MX Client Limitations of ODBC/MX Driver 1-12 2. Installation of the ODBC/MX Client Components of the MX connectivity service 2-1 Installing the Client Components 2-1 Installation Requirements 2-1 Step 1: Download and Run the Installation File Step 2: Install the Client Interface Components Step 3: Add a Data Source 2-3 Step 4: Delete the Installation Folder 2-3 Step 5: Restart the PC 2-3 ODBC/MX Driver Component 2-3 Uninstalling the Client Interface 2-4 2-2 2-2 3.
Contents 6. ODBC/MX Messages SQL/MP Data Types and ODBC/MX Equivalents 5-13 Microsoft Escape Clauses 5-13 Stored Procedures 5-14 Transactions and Cursor Behavior with Multiple Statements Timestamp Values with Fraction 5-15 5-15 6. ODBC/MX Messages ODBC/MX Driver Error Codes 6-1 ODBC/MX Client Messages 6-1 Glossary Index Figures Figure 1-1. Connection Data Flow 1-3 Tables Table 1-1. Table 5-1. Table 5-2. Table 5-3. Table 5-4. Table 5-5. Table 5-6. Table 5-7. Table 5-8. Table 5-9. Table 5-10.
Contents Table 5-21. Table 5-22. Table 5-23. Sample Values Inserted From a C/C++ Program and Their Corresponding Expected Values in Nanosecond 5-17 SYSTEM_DEFAULT Values Retrieved Using a C/C++ Program Sample Values Retrieved Using a C/C++ Program and Their Corresponding Expected Values in Nanosecond 5-20 HP NonStop ODBC/MX Driver for Windows for SQL/MX Release 3.
What’s New in This Manual Manual Information HP NonStop ODBC/MX Driver for Windows for SQL/MX Release 3.1 Abstract This manual describes how to install and configure HP NonStop™ ODBC/MX for Microsoft® Windows. This product enables applications developed for the Microsoft Open Database Connectivity (ODBC) application programming interface to use HP NonStop SQL/MX to access HP NonStop SQL databases on an HP NonStop system. Product Version HP NonStop ODBC/MX 3.
What’s New in This Manual Changes to the 640329-001 manual: Limitations of ODBC/MX Driver on page 1-12 Updated the following topics: Installing the Client Components on page 2-1 Uninstalling the Client Interface on page 2-4 Added ODBC/MX Driver Component on page 2-4. Added a note under Adding New Client Data Sources on page 3-2. Added a note about IPv6 address under Configuring Client Data Sources using Connection String on page 3-2.
About This Manual Audience This manual is for: ODBC application programmers who write 32-bit applications to access an NonStop SQL database. Other end users or application programmers who use ODBC/MX to access a NonStop SQL database. Related Documentation The SQL/MX library of manuals, which includes: Introductory Guides SQL/MX Comparison Guide for SQL/MP Users Describes SQL differences between SQL/MP and SQL/MX.
About This Manual Related Documentation Specialized Guides SQL/MX Installation and Management Guide Describes how to plan for, install, create, and manage an SQL/MX database. Explains how to use installation and management commands and utilities. SQL/MX Query Guide Describes how to understand query execution plans and write optimal queries for an SQL/MX database. SQL/MX Data Mining Guide Describes the SQL/MX data structures and operations to carry out the knowledge-discovery process.
About This Manual Related Documentation mentioned under the SQL/MX Online Help and Sample Programs document. This document can be accessed from the following documentation links available at the HP Business Support Center (BSC), http://www.hp.com/go/nonstop-docs: HP Integrity NonStop H-Series HP Integrity NonStop J-Series For more information about downloading online help, see the SQL/MX Installation and Management Guide.
About This Manual Related Documentation Programming Manuals Introductory Guides SQL/MX Comparison Guide for SQL/MP Users SQL/MX Programming Manual for C and COBOL SQL/MX Quick Start SQL/MX Programming Manual for Java SQL/MX Guide to Stored Procedures in Java Reference Manuals SQL/MX Reference Manual SQL/MX Messages Manual SQL/MX Glossary SQL/MX Queuing and Publish/ Subscribe Services SQL/MX Query Guide SQL/MX Report Writer Guide DataLoader/MX Reference Manual SQL/MX Online Help Specialized
About This Manual Notation Conventions Notation Conventions Hypertext Links Blue underline is used to indicate a hypertext link within text. By clicking a passage of text with a blue underline, you are taken to the location described. For example: This requirement is described under Backup DAM Volumes and Physical Disk Drives on page 3-2. General Syntax Notation This list summarizes the notation conventions for syntax presentation in this manual. UPPERCASE LETTERS.
About This Manual Change Bar Notation Nonitalic text. Nonitalic letters, numbers, and punctuation indicate text that is displayed or returned exactly as shown. For example: Backup Up. The CRE has many new message types and some new message type codes for old message types. In the CRE, the message type SYSTEM includes all messages except LOGICAL-CLOSE and LOGICAL-OPEN. Change Bar Notation Change bars are used to indicate substantive differences between this manual and its preceding version.
1 ODBC/MX Client Overview Applications developed for the Microsoft® Open Database Connectivity (ODBC) application programming interface (API) can use SQL/MX to access a NonStop SQL database on an HP NonStop server, through HP NonStop SQL/MX connectivity services (MXCS).
ODBC/MX Client Overview Default Data Source Default Data Source MXCS provides a preconfigured, default server data source on the server called TDM_Default_DataSource. You can stop and start the TDM_Default_DataSource using NSM/web, but you cannot delete it. The TDM_Default_DataSource has these functions: ODBC clients can connect to TDM_Default_DataSource and access a NonStop SQL database with no special configuration required.
ODBC/MX Client Overview Connection Mapping 3. The ODBC client application sends a connection request to the MXCS SQL server that was assigned by the association server. If the user information is not valid, the connection is rejected. 4. When the ODBC client application disconnects, the MXCS SQL server notifies the association server that it is available for connections from other ODBC clients and returns to the server data source pool.
ODBC/MX Client Overview Connection Pooling source name does not exist, the association server routes the connection to the default data source. If the default data source is not started, the connection request is rejected. After a data source name is assigned, the association server uses any MXCS SQL server that was previously used by the same userid.
ODBC/MX Client Overview Enabling Connection Pooling To use connection pooling, an ODBC client application must perform the following sequence: Step Client Action 1. Enable connection pooling Call SQLSetEnvAttr with the environment handle set to NULL and the SQL_ATTR_CONNECTION_POOLING attribute set to SQL_CP_ONE_PER_DRIVER or SQL_CP_ONE_PER_HENV. SQL_CP_OFF (the default) turns connection pooling off. 2.
ODBC/MX Client Overview Object Naming and Mapping Step Client Action 8. Retrieve and process data from the database When using connection pooling, an application must preserve the database context within the session and should not execute SQL/MX statements that change the name of the database or its context. 9. Disconnect and return the connection to the connection pool Call SQLDisconnect. 10. Free the environment and connection handles Call SQLFreeHandle for each handle.
ODBC/MX Client Overview Password Expiration catalog.schema.object-name ANSI names have a maximum of 128 characters for each part of the name (not including the dots). ANSI Names for SQL/MX Objects ANSI names for SQL/MX objects are registered in SQL/MX metadata residing in SQL/MX format tables. ANSI Names for SQL/MP Objects ANSI names (also called alias names) are logical names that map to physical Guardian names of existing SQL/MP objects.
ODBC/MX Client Overview Release Considerations and Restrictions Release Considerations and Restrictions Table 1-1. Release Considerations and Restrictions (page 1 of 3) ODBC driver manager ODBC/MX requires the Microsoft ODBC 3.5.1 (or later) driver manager. If you do not already have the 3.5.1 driver manager, ODBC/MX installs it for you. ODBC/MX client software An ODBC/MX client can be installed in the same workstation as other ODBC client software. R 2.3.
ODBC/MX Client Overview Release Considerations and Restrictions Table 1-1. Release Considerations and Restrictions (page 2 of 3) SQLCancel Function In an ODBC 2.0 application, ODBC/MX implements the SQLCancel function as an SQLFreeStmt with the SQL_CLOSE option. If the query is running, ODBC/MX tries to stop the server. If the attempt is successful, the client application receives an error and must reconnect. In an ODBC 3.
ODBC/MX Client Overview Traces Table 1-1. Release Considerations and Restrictions (page 3 of 3) SQLStatistics Function This function does not support pattern value arguments for table names, and returns index information for a specified table name in the SQL/MX catalog.
ODBC/MX Client Overview Unsupported ODBC API Functions and Data Types Unsupported ODBC API Functions and Data Types API Functions This release of ODBC/MX does not support the following ODBC 3.51 API functions. For descriptions of the ODBC API functions, see ODBC API Functions on page 5-2. SQLBulkOperations SQLFetchScroll - supported for SQL_FETCH_NEXT attribute only SQLSetScrollOption Data Types This release of MXCS does not support the following ODBC data types.
ODBC/MX Client Overview Limitations of ODBC/MX Driver The precision of the NUMERIC data type is extended up to 128 digits for signed and unsigned values. Limitations of ODBC/MX Driver The system running an R 3.x version of Windows ODBC/MX Driver does not connect to a NonStop system running an R 2.x version of ODBC/MX server objects. When you try to connect an R 3.x version of Windows ODBC/MX Driver to an R 2.x version of ODBC/MX server objects, the behavior is unpredictable.
2 Installation of the ODBC/MX Client Components of the MX connectivity service 2-1 Installing the Client Components 2-1 Uninstalling the Client Interface 2-4 Components of the MX connectivity service To fully install all components of connectivity service, you must install the following: MXCS server components on a NonStop system. ODBC/MX client interface on any Windows machine.
Installation of the ODBC/MX Client Step 1: Download and Run the Installation File Requirement Description MXCS software MXCS, version 2.0, installed in the server Network software TCP/IP Browser Microsoft Internet Explorer 4.0 or higher; version 5.0 is recommended. Note. You must be logged on with a userid that has administrative privileges. Step 1: Download and Run the Installation File 1. Turn off all other applications running on the client workstation. Note.
Installation of the ODBC/MX Client Step 3: Add a Data Source Screen Button Description Welcome Next Cancel License Agreement Yes No Displays the next screen Aborts the installation Choose Destination Location Browse Selects the folder into which the ODBC files are copied. The default location is: C:\.....\Hewlett-Packard\NonStop ODBCMX 3.x Select Program Folder Enter the name of a subfolder within the Program folder. The default is NonStop ODBCMX 3.x.
Installation of the ODBC/MX Client Step 4: Delete the Installation Folder Step 4: Delete the Installation Folder When the installation is complete, delete the temporary installation folder you created in Step 1. Step 5: Restart the PC HP recommends that you restart the PC before you use the ODBC/MX client interface. Note. Before using the client interface, the MXCS service must be started. For information on how to start the service, see the SQL/MX Connectivity Service Manual.
3 Configuring Client Data Sources on Windows Use the Microsoft ODBC Data Source Administrator to add, configure, and remove ODBC/MX data sources. For information about supported versions of Windows, see Client Components on page 1-1. Note.You can install and run ODBC/MX version 2.0 concurrently with MXCS version 1.8. However, to remove or reconfigure ODBC/MX version 1.8 data sources, the corresponding version of MXCS must be installed on your system.
Configuring Client Data Sources on Windows Reconfiguring Client Data Sources For more information about a screen, click Help. Note. The catalog and schema names that are defined for server data sources using NSM/web are not recognized by ODBC/MX for client data sources unless they are defined through the Microsoft ODBC Data Source Administrator. You must either define the catalog and schema names using the Microsoft ODBC Data Source Administrator, or use the fully qualified object name.
Configuring Client Data Sources on Windows Configuring Client Data Sources for Update Operations Configuring Client Data Sources for Update Operations To perform “update . . . on the current of” operations: Set the fetch buffer size to zero using the ODBC Cient Administrator. This forces fetching one row at a time instead of a buffered fetch.
Configuring Client Data Sources on Windows Configuring Client Data Sources using HP SSL 6. Click Apply then click OK. For more information about a screen, click Help. Start tracing on a client data source: 1. Bring up the Microsoft ODBC Data Source Administrator. You can usually find this by selecting the Start menu, Programs option, NonStop ODBCMX 3.x option, then select the MS ODBC Administrator option. 2. Select the Tracing tab. 3. Select the Custom Trace DLL (the trace file name) you want to use.
4 Module File Caching (MFC) 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 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.
Module File Caching (MFC) 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()APIs have the benefit of lower processor utilization, lower memory consumption, and better response time.
5 ODBC/MX Conformance This section contains tables that describe the ODBC/MX conformance to standard ODBC API functions and SQL conformance levels.
ODBC/MX Conformance ODBC API Functions ODBC API Functions ODBC/MX conforms with the ODBC interface core level. The following tables show the ODBC/MX support for each ODBC API function. The column headed ODBC Version lists the version of the Microsoft ODBC standard in which a function was first introduced. For example, if ODBC Version 1.0 is listed as supported, then the feature was first defined in version 1.0 of the Microsoft ODBC standard and ODBC/MX currently supports the function.
ODBC/MX Conformance ODBC API Functions Table 5-3. Setting and Retrieving Driver Attributes ODBC Version Supported by ODBC/MX SQLSetConnectAttr 3.x Yes Sets a connection attribute. SQLGetConnectAttr 3.x Yes Returns the value of a connection attribute. SQLSetEnvAttr 3.x Yes Sets an environment attribute. SQLGetEnvAttr 3.x Yes Returns the value of an environment attribute. SQLSetStmtAttr 3.x Yes Sets a statement attribute.
ODBC/MX Conformance ODBC API Functions Table 5-6. Submitting SQL Requests ODBC Version Supported by ODBC/MX SQLExecute 1.0 Yes Executes a prepared statement. SQLExecDirect 1.0 Yes Executes a statement. SQLNativeSql 1.0 Yes Returns the text of an SQL statement as translated by the driver. SQLDescribeParam 1.0 Yes Returns the description for a specific parameter in a statement. SQLNumParams 1.0 Yes Returns the number of parameters in a statement. SQLParamData 1.
ODBC/MX Conformance ODBC API Functions Table 5-7. Retrieving Results and Information About Results (page 2 of 2) ODBC Version Supported by ODBC/MX SQLExtendedFetch 1.0 Yes Fetches the specified rowset of data from the result set and returns data for all bound columns. No bookmarks are supported. SQLSetPos 1.0 Yes Positions a cursor within a fetched block of data and allows an application to refresh data in the row set or to update or delete data in the result set. SQLBulkOperations 3.
ODBC/MX Conformance ODBC API Functions Table 5-8. Obtaining Information About a Data Source’s System Tables (page 2 of 2) ODBC Version Supported by ODBC/MX SQLProcedureColumns 1.0 Yes Returns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures. SQLProcedures 1.0 Yes Returns the list of procedure names stored in a specific data source. SQLSpecialColumns 1.
ODBC/MX Conformance SQL Conformance Level Table 5-9. Terminating a Statement ODBC Version Supported by ODBC/MX SQLCloseCursor 3.x Yes Closes a cursor that has been opened on a statement handle. SQLCancel 1.0 Yes Closes a cursor that has been opened on a statement handle. Function Description Note: See the considerations underSQLCancel Function on page 1-9. SQLEndTran 3.x Yes Commits or rolls back a transaction. Table 5-10.
ODBC/MX Conformance SQL Scalar Functions Table 5-11. Numeric Functions (page 2 of 2) ODBC Function SQL/MX Equivalent Function ATAN2 ATAN2 CEILING CEILING COS COS COSH COSH COT Not supported in this release. DEGREES DEGREES EXP EXP FLOOR FLOOR LOG LOG LOG10 LOG10 MOD MOD PI PI POWER POWER RADIANS RADIANS RAND RAND ROUND Not supported in this release. SIGN SIGN SIN SIN SINH SINH SQRT SQRT TAN TAN TANH TANH TRUNCATE Not supported in this release. Table 5-12.
ODBC/MX Conformance SQL Scalar Functions Table 5-12. String Functions (page 2 of 2) ODBC Function SQL/MX Equivalent Function LOCATE LOCATE (ODBC LOCATE start parameter is not supported.) LTRIM TRIM...LEADING REPEAT REPEAT REPLACE REPLACE RIGHT RIGHT RTRIM TRIM...TRAILING SOUNDEX Not supported SPACE SPACE SUBSTRING SUBSTRING UCASE UPPER | UPSHIFT Note.
ODBC/MX Conformance ODBC Data Types Table 5-13. Time and Date Functions (page 2 of 2) ODBC Function SQL/MX Equivalent Function TIMESTAMPADD Not supported TIMESTAMPDIFF Not supported WEEK WEEK Table 5-14. System Functions ODBC Function SQL/MX Equivalent Function DATABASE Not supported in this release. IFNULL Not supported in this release. USER USER CONVERT Function ODBC/MX uses the SQL/MX CAST function to support the ODBC CONVERT function.
ODBC/MX Conformance ODBC Data Types Table 5-15.
ODBC/MX Conformance Unsigned Data Types Table 5-15. ODBC Data Types (page 3 of 3) ODBC Data Type SQL/MX Data Type SQL/MP Data Type Supported by ODBC/MX INTERVAL HOUR(p) TO SECOND(q) INTERVAL HOUR(p) TO SECOND(q) Yes INTERVAL MINUTE(p) TO SECOND(q) INTERVAL MINUTE(p) TO SECOND(q) Yes * The VARCHAR length can be up to 4059 for key-sequenced files or 4070 for entry-sequenced files. ** Starting with SQL/MX Release 3.0, the precision of the NUMERIC data type is extended to 128 digits.
ODBC/MX Conformance SQL/MP Data Types and ODBC/MX Equivalents SQL/MP Data Types and ODBC/MX Equivalents Table 5-17.
ODBC/MX Conformance Microsoft Escape Clauses Microsoft Escape Clauses ODBC/MX accepts Microsoft escape clauses and translates them into equivalent SQL/MX clauses. Table 5-18.
ODBC/MX Conformance Transactions and Cursor Behavior with Multiple Statements Transactions and Cursor Behavior with Multiple Statements Table 5-19. Transactions and Cursor Behavior Autocommit SQL/MX Behavior Action Required ON When any open statement reaches end of data or end of cursor, SQL/MX closes all other open statements. N.A. OFF N.A. The application must explicitly rollback or commit the transaction. All open statements are closed at that time.
ODBC/MX Conformance Timestamp Values with Fraction Table 5-20. Sample Values Inserted From a C/C++ Program and Their Corresponding Expected Values in Microsecond (page 1 of 2) Value Specified in the Fraction of the Client Program Column Type Expected Value in the Column of the SQL/MX Table 987654 timestamp(6) or time(6) 0.987654 87654 timestamp(6) or time(6) 0.087654 7654 timestamp(6) or time(6) 0.007654 654 timestamp(6) or time(6) 0.000654 54 timestamp(6) or time(6) 0.
ODBC/MX Conformance Timestamp Values with Fraction Table 5-20. Sample Values Inserted From a C/C++ Program and Their Corresponding Expected Values in Microsecond (page 2 of 2) Value Specified in the Fraction of the Client Program Column Type Expected Value in the Column of the SQL/MX Table 87654 timestamp(1) or time(1) 0.0 7654 timestamp(1) or time(1) 0.0 654 timestamp(1) or time(1) 0.0 54 timestamp(1) or time(1) 0.0 4 timestamp(1) or time(1) 0.
ODBC/MX Conformance Timestamp Values with Fraction Table 5-21. Sample Values Inserted From a C/C++ Program and Their Corresponding Expected Values in Nanosecond (page 2 of 2) Value Specified in the Fraction of the Client Program Column Type Expected Value in Column of the SQL/MX Table 54321 timestamp(4) or time(4) 0.0000 4321 timestamp(4) or time(4) 0.0000 987654321 timestamp(3) or time(3) 0.987 87654321 timestamp(3) or time(3) 0.087 7654321 timestamp(3) or time(3) 0.
ODBC/MX Conformance Timestamp Values with Fraction Table 5-22. SYSTEM_DEFAULT Values Retrieved Using a C/C++ Program Value in the Column of the SQL/MX Table Column Type Value in the Fraction of the Client Program 0.000654 timestamp(6) or time(6) 654 0.000054 timestamp(6) or time(6) 54 0.000004 timestamp(6) or time(6) 4 0.98765 timestamp(5) or time(5) 98765 0.08765 timestamp(5) or time(5) 8765 0.00765 timestamp(5) or time(5) 765 0.00065 timestamp(5) or time(5) 65 0.
ODBC/MX Conformance Timestamp Values with Fraction Table 5-23. Sample Values Retrieved Using a C/C++ Program and Their Corresponding Expected Values in Nanosecond Value in the Column of the SQL/MX Table Column Type Value in the Fraction of the Client Program 0.987654 timestamp(6) or time(6) 987654000 0.087654 timestamp(6) or time(6) 87654000 0.007654 timestamp(6) or time(6) 7654000 0.000654 timestamp(6) or time(6) 654000 0.000054 timestamp(6) or time(6) 54000 0.
6 ODBC/MX Messages Topic Page ODBC/MX Driver Error Codes 6-1 ODBC/MX Client Messages 6-1 ODBC/MX Driver Error Codes ODBC/MX Client Messages To display the messages for the SQLSTATE numbers in the following tables, click one of the following starting SQLSTATE numbers: 01000 08001 21001 40001 S0001 S1000 S1010 S1100 SQLSTATE Messages 01000 General Warning. 01000 General Warning. Connected to the default data source. 01002 Disconnect error. Transaction rolled back. 01004 Data truncated.
ODBC/MX Messages ODBC/MX Client Messages SQLSTATE Messages 08002 Connection in use. 08003 Connection not open. 08004 Data source rejected establishment of connection since the MXCS server is connected to a different client now. 08004 Data source rejected establishment of connection for implementation defined reasons. 08005 Communication failure. 08006 Transaction rolled back. 08007 Connection failure during transaction. 08S01 Communication link failure.
ODBC/MX Messages ODBC/MX Client Messages SQLSTATE Message 40001 Attempt to initiate new SQL server operation with data pending. 42000 Syntax error or access rule violation. 70100 Operation aborted (server did not process cancel request). HY721 TranslationDLL Truncation: DataSourceToDriver. HY721 TranslationDLL Truncation: DriverToDataSource. HY722 TranslationDLL Error: DataSourceToDriver. HY723 TranslationDLL Error: DriverToDataSource. IM001 Driver does not support this function.
ODBC/MX Messages ODBC/MX Client Messages SQLSTATE Message S1005 Parameter number out of range. S1006 Invalid conversion specified. S1007 Row count not available from the data source. S1008 Operation cancelled. S1009 Invalid argument value. SQLSTATE Message S1010 Function sequence error S1012 Invalid transaction operator code specified. S1015 No cursor name available. S1090 Invalid string or buffer length. S1091 Descriptor type out of range. S1092 Option type out of range.
Glossary driver manager. The Microsoft ODBC component that manages access to Database Management System (DBMS) drivers for ODBC applications. The driver manager loads and unloads drivers and passes calls for ODBC functions to the correct driver. ODBC/MX requires the Microsoft 3.51 (or later) driver manager. Open Database Connectivity (ODBC). An interface specification for an API that defines a standard set of routines that an ODBC application can use to access data in a data source.
Glossary Open Database Connectivity (ODBC) HP NonStop ODBC/MX Driver for Windows for SQL/MX Release 3.
Index A ABS function 5-7 ACOS function 5-7 adding data sources to client 2-3, 3-1 alias names, adding 1-7 ANSI name type 1-7 API functions, ODBC supported 5-2/5-7 architecture 1-1 ASCII function 5-8 ASIN function 5-7 association server, functions of 1-2 ATAN function 5-7 ATAN2 function 5-8 autocommit 5-15 B BIGINT data type 5-11 BINARY data type 5-11 BIT data type 5-11 Bring 3-4 C CAST function 5-10 catalog restrictions 1-8 CEILING function 5-8 CHAR data type 5-10 CHAR function 5-8 client adding new data
Index D D Data Source Administrator, Microsoft ODBC 3-1 data sources default TDM_Default_DataSource 1-2 functions for connecting to 5-2 functions for obtaining information 5-2 functions for system tables 5-5 mapping client to server names 1-3 tools for managing 1-1 data sources, client adding 3-1 adding to client interface 2-3 connecting to 1-2 managing 3-1/3-3 overview of 1-2 reconfiguring 3-2, 5-15 removing 3-3 tracing 3-3, 3-4 Data Types unsigned 5-12 data types unsigned 5-12 data types not supported 1
Index H H HOUR function 5-9 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...
Index P object name types (continued) ANSI for SQL/MX objects 1-7 Guardian in SQL commands 1-6 ODBC applications, connection pooling 1-5/1-6 ODBC Data Source Administrator, Microsoft 3-1 ODBC data types supported 5-10 ODBC/MX See NonStop ODBC/MX ODBC/MX driver description 1-1 functions for setting and retrieving attributes 5-3 P performance improvements using connection pooling 1-4 PI function 5-8 pooling connections 1-4 POWER function 5-8 PUBLIC_ACCESS_SCHEMA schema 1-8 Q QUARTER function 5-9 R RADIAN
Index T SQLDrivers function 5-2 SQLEndTran function 5-7 SQLExecDirect function 5-4 SQLExecute function 5-4 SQLExtendedFetch function 5-5 SQLFetch function 5-4 SQLFetchScroll function 5-4 SQLForeignKeys function 5-5 SQLFreeHandle function 5-7 SQLFreeStmt function 5-6 SQLGetConnectAttr function 5-3 SQLGetCursorName function 5-3 SQLGetData function 5-4 SQLGetDescField function 5-3 SQLGetDescRec function 5-3 SQLGetDiagField function 5-5 SQLGetDiagRec function 5-5 SQLGetEnvAttr function 5-3 SQLGetFunctions fun
Index U TRUNCATE function 5-8 U UCASE function 5-9 uninstalling client interface 2-4 update 3-3 UPPER function 5-9 UPSHIFT function 5-9 USER function 5-10 V VARBINARY data type 5-11 VARCHAR data type 5-10 W WEEK function 5-10 HP NonStop ODBC/MX Driver for Windows for SQL/MX Release 3.
