HP NonStop ODBC/MX Driver for Windows 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.0 Supported Release Version Updates (RVUs) This manual supports J06.11 and all subsequent J-series RVUs and H06.
Document History Part Number Product Version 640329-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 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.
1. ODBC/MX Client Overview (continued) Contents 1. ODBC/MX Client Overview (continued) Limitations of ODBC/MX Driver 1-12 2.
5. ODBC/MX Conformance (continued) Contents 5. ODBC/MX Conformance (continued) 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.
Tables (continued) Contents Tables (continued) Table 5-20. Table 5-21. Table 5-22. Table 5-23.
What’s New in This Manual Manual Information HP NonStop ODBC/MX Driver for Windows 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.0 Supported Release Version Updates (RVUs) This manual supports J06.
What’s New in This Manual • • • New and Changed Information Added a note about IPv6 address under Configuring Client Data Sources using Connection String on page 3-2. Added a note about the NUMERIC data type on page 5-12. Added Timestamp Values with Fraction on page 5-15.
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.
Related Documentation About This Manual 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.
Related Documentation About This Manual 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.
Related Documentation About This Manual 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 Query Guide SQL/MX Queuing and Publish/ Subscribe Services SQL/MX Report Writer Guide DataLoader/MX Reference Manual SQL/MX Online Help Specialized
Notation Conventions About This Manual 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.
Change Bar Notation About This Manual 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.
Connection Mapping ODBC/MX Client Overview 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.
Enabling Connection Pooling ODBC/MX Client Overview 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.
Object Naming and Mapping ODBC/MX Client Overview 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.
Release Considerations and Restrictions ODBC/MX Client Overview 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.
Traces ODBC/MX Client Overview 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.0 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.0 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.
Step 1: Download and Run the Installation File Installation of the ODBC/MX Client Step 1: Download and Run the Installation File 1. Turn off all other applications running on the client workstation. Note. If Microsoft OutsideView32 is running, it must be stopped before you perform this installation. 2. Create a temporary client installation folder on the client workstation; for example: C:\ODBCTEMP.
Step 3: Add a Data Source Installation of the ODBC/MX Client Screen Button Description Start Copying Files Back Next Cancel Displays a summary of installed components. Question Yes No If data sources configured for a previous version of ODBC/MX are found, this screen is displayed. Click Yes to reconfigure all data sources for the current version of MXCS. Clicking No leaves data source configuration unchanged.
Uninstalling the Client Interface Installation of the ODBC/MX Client File Name Description tdm_oadm0300.dl NonStop ODBC/MX Client Adminstration DLL tdm_odbc0300.dll NonStop ODBC/MX Driver DLL tdm_odbcDrvMsg_intl0300.dll NonStop ODBC/MX Client Msg DLL tdm_OdbcTrace0300.dll NonStop ODBC/MX Client Trace DLL tdm_ores0300.dll NonStop ODBC/MX Driver Resource DLL tdm_tcpipv40300.dll NonStop ODBC/MX TCPIPV4 DLL tdm_tcpipv60300.dll NonStop ODBC/MX TCPIPV6 DLL tdm_translation.dll.
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 Tracing Client Data Sources 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.0 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() have the benefit of lower processor utilization, lower memory consumption, and better response time. ODBC/MX applications using complex queries through prepare calls have higher 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 API Functions ODBC/MX Conformance 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 API Functions ODBC/MX Conformance Table 5-3. Setting and Retrieving Driver Attributes ODBC Version Supported by ODBC/MX SQLSetConnectAttr 3.0 Yes Sets a connection attribute. SQLGetConnectAttr 3.0 Yes Returns the value of a connection attribute. SQLSetEnvAttr 3.0 Yes Sets an environment attribute. SQLGetEnvAttr 3.0 Yes Returns the value of an environment attribute. SQLSetStmtAttr 3.0 Yes Sets a statement attribute.
ODBC API Functions ODBC/MX Conformance 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 API Functions ODBC/MX Conformance 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 API Functions ODBC/MX Conformance 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.
SQL Conformance Level ODBC/MX Conformance Table 5-9. Terminating a Statement ODBC Version Supported by ODBC/MX SQLCloseCursor 3.0 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.0 Yes Commits or rolls back a transaction. Table 5-10.
SQL Scalar Functions ODBC/MX Conformance 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.
SQL Scalar Functions ODBC/MX Conformance 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 Data Types ODBC/MX Conformance 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 Data Types ODBC/MX Conformance Table 5-15.
Unsigned Data Types ODBC/MX Conformance 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.
SQL/MP Data Types and ODBC/MX Equivalents ODBC/MX Conformance SQL/MP Data Types and ODBC/MX Equivalents Table 5-17.
Stored Procedures ODBC/MX Conformance Table 5-18. Microsoft Escape Clauses Microsoft Escape Clause SQL/MX Equivalent { d 'date-literal' } DATE 'date-literal' { t 'time-literal' } TIME 'time-literal' { ts 'timestamp-literal' } TIMESTAMP 'timestamp-literal' 1 { oj join-expression } join-expression { INTERVAL sign interval-string interval-qualifier } INTERVAL sign interval-string interval-qualifier { fn scalar-function } scalar-function 2 { call Supported in current release procedure-name...
Transactions and Cursor Behavior with Multiple Statements ODBC/MX Conformance 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.
Timestamp Values with Fraction ODBC/MX Conformance 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.
Timestamp Values with Fraction ODBC/MX Conformance 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.
Timestamp Values with Fraction ODBC/MX Conformance 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.
Timestamp Values with Fraction ODBC/MX Conformance 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.987654 timestamp(6) or time(6) 987654 0.087654 timestamp(6) or time(6) 87654 0.007654 timestamp(6) or time(6) 7654 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.
Timestamp Values with Fraction ODBC/MX Conformance 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 Client Messages ODBC/MX 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 Client Messages ODBC/MX 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 Client Messages ODBC/MX 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—640329-001 Glossary- 2
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
D Index 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
H Index 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...
P Index 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
T Index 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
U Index 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—640329-001 Index -6
