Neoview ODBC Drivers Manual (R2.4)

Table of Contents
About This Document.........................................................................................................7
Intended Audience.................................................................................................................................7
New and Changed Information in This Edition.....................................................................................7
Document Organization.........................................................................................................................7
Notation Conventions.............................................................................................................................8
General Syntax Notation...................................................................................................................8
Related Documentation........................................................................................................................10
Neoview Customer Library.............................................................................................................10
Publishing History................................................................................................................................11
HP Encourages Your Comments..........................................................................................................11
1 HP Neoview ODBC Driver Overview for Windows.................................................13
Driver Components..............................................................................................................................13
Drivers Supported.................................................................................................................................13
Data Sources..........................................................................................................................................14
Default Data Source.........................................................................................................................14
Client Data Sources..........................................................................................................................14
Connections...........................................................................................................................................14
Connecting a Client to a Data Source..............................................................................................14
Connection Pooling.........................................................................................................................14
Associating a Connection with a WMS Service...............................................................................16
Object Naming and Mapping...............................................................................................................16
ANSI Name Type.............................................................................................................................16
Password Length...................................................................................................................................16
Password Expiration.............................................................................................................................16
Release Considerations and Restrictions..............................................................................................17
SQLCancel Function........................................................................................................................18
Traces.....................................................................................................................................................19
Neoview Platform Specific Extensions and Attributes........................................................................19
Handling Larger Row Counts ........................................................................................................19
Specifying a Job ID or Session Name..............................................................................................19
Example......................................................................................................................................20
Specifying an Application Name.....................................................................................................20
Examples....................................................................................................................................21
INFOSTATS Command ........................................................................................................................22
Example of INFOSTATS..................................................................................................................22
Unsupported ODBC API Functions and Data Types...........................................................................23
API Functions..................................................................................................................................23
Data Types.......................................................................................................................................23
Restricted ODBC API Functions...........................................................................................................23
SQLBindParameter..........................................................................................................................23
SQLPutData.....................................................................................................................................23
2 HP Neoview ODBC Drivers Overview for UNIX......................................................25
Driver Components..............................................................................................................................25
Drivers Supported.................................................................................................................................26
Data Sources..........................................................................................................................................26
Default Data Source.........................................................................................................................26
Client Data Sources..........................................................................................................................27
Table of Contents 3