ODBC Server Reference Manual

About This Manual
HP NonStop ODBC Server Reference Manual—429151-002
xxii
Organization of This Manual
•
Section 2, Architecture Overview, shows how the NonStop ODBC Server
reconciles the architecture of NonStop SQL/MP with the architecture of ODBC or
SQL Server. It describes how ODBC or SQL Server, NonStop SQL/MP, and the
NonStop ODBC Server manage the database and database objects, describe and
access database objects, implement security, handle transactions and data
consistency, allocate storage, support user access, and maintain data integrity.
•
Section 3, CORE SQL Language, describes names, data types, functions, and
other elements used in SQL statements, as well as the CORE SQL statements the
NonStop ODBC Server supports. This section presents the syntax for each
statement and describes how the statement differs from ODBC and NonStop
SQL/MP statements.
•
Section 4, Transact-SQL Language, describes names, data types, functions, and
other elements used in SQL statements, as well as the Transact-SQL statements
the NonStop ODBC Server supports. This section presents the syntax for each
statement and describes how the statement differs from SQL Server and NonStop
SQL/MP statements.
•
Section 5, Stored Procedures, describes the NonStop ODBC Server support of
stored procedures and gives guidelines for users who need to write stored
procedures, using either the C programming language or COBOL85.
•
Section 6, Using Pass-Through Mode, describes how to use pass-through mode to
execute NonStop SQL/MP statements, catalog utility commands, and trace
commands.
•
Section 7, Managing Customized Catalogs, describes how to customize a catalog
and how to maintain customized catalogs, including the use of NOSUTIL, the
NonStop ODBC Server utilities.
•
Section 8, HP NonStop ODBC Server Mapping Tables, describes the mapping
tables that the NonStop ODBC Server uses to implement an ODBC or SQL Server
database.
•
Section 9, UNIX Notes, contains information for users who are accessing the
NonStop ODBC Server from a UNIX workstation.
•
Appendix A, Summary of Support for ODBC Features, lists ODBC language
features and indicates which features the NonStop ODBC Server supports.
•
Appendix B, Summary of Support for SQL Server Features, lists SQL Server
language features and indicates which features the NonStop ODBC Server
supports.
•
Appendix C, Summary of Support for ODBC 2.10 Functions, lists ODBC functions
and indicates which functions the NonStop ODBC Server supports.
•
Appendix D, Summary of System Installation Defaults, lists the default values, set
at system installation time by the installation process, for named attributes of the
NonStop ODBC Server.