ODBC Server Reference Manual

Contents

HP NonStop ODBC Server Reference Manual—429151-002

xvi

Tables (continued)

Table 3-9. Supported CORE SQL Statements by Type 3-32

Table 4-1. Statements Allowed in User-Defined Transactions 4-3

Table 4-2. How the NonStop ODBC Server Handles Transact-SQL Object

Names 4-6

Table 4-3. Rules for Object Names 4-8

Table 4-4. Conversion of Transact-SQL Data Types to NonStop SQL/MP Data

Types 4-12

Table 4-5. Datetime Fields 4-15

Table 4-6. Converting NonStop SQL/MP Data Types to Transact-SQL Data

Types 4-15

Table 4-7. Supported Transact-SQL Functions 4-18

Table 4-8. NonStop ODBC Server Support of Transact-SQL Dateparts 4-20

Table 4-9. Global Variables 4-27

Table 4-10. NonStop ODBC Server Support of Transact-SQL Operators 4-30

Table 4-11. NonStop ODBC Server Support of Aggregate Functions 4-31

Table 4-12. NonStop ODBC Server Support of Wild-Card Characters 4-34

Table 4-13. The Order in Which NULL Values Are Displayed 4-35

Table 4-14. NonStop ODBC Server Support of Transact-SQL Statements 4-36

Table 4-15. NonStop ODBC Server Support of Control-of-Flow Statements 4-39

Table 4-16. Supported Transact-SQL Statements by Type 4-40

Table 4-17. Dropping Mapping Tables, Objects, and Catalogs 4-66

Table 6-1. DDL Statements Available in Pass-Through Mode 6-8

Table 6-2. DCL Statements Available in Pass-Through Mode 6-11

Table 6-3. DML Statements Available in Pass-Through Mode 6-11

Table 6-4. Dynamic SQL Statements Available in Pass-Through Mode 6-12

Table 7-1. Tasks That Involve Customization and Catalog Utilities 7-3

Table 7-2.

Description of ZNUOBJ 7-8

Table 7-3.

Catalog Utility Statements 7-13

Table 7-4. Summary of Mapping Table Statements 7-38

Table 7-5. Result Set for the SQLColumns Procedure 7-122

Table 7-6. Result Set for the SQLPrimaryKeys Procedure 7-123

Table 7-7. Result Set for the SQLProcedureColumns Procedure 7-124

Table 7-8. Result Set for the SQLProcedures Procedure 7-125

Table 7-9. Result Set for the SQLSpecialColumns Procedure 7-125

Table 7-10. Result Set for SQLProcedureColumns Procedure 7-126

Table 7-11. Result Set for SQLTables Procedure 7-127

Table 8-1. Naming Conventions for the Mapping Tables 8-3

Table 8-2. Naming Conventions for the Mapping Table Columns 8-4