ODBC Server Reference Manual

Contents
HP NonStop ODBC Server Reference Manual—429151-002
ii
2. Architecture Overview (continued)
2. Architecture Overview (continued)
Server-Side View 2-13
Major Components 2-13
Message Flows 2-16
NonStop ODBC Server Objects and Relationships 2-19
Name Mapping 2-22
NonStop ODBC Server Catalogs 2-22
NonStop ODBC Server 2-27
SQL Communication Subsystem 2-30
NOSUTIL 2-37
NonStop SQL/MP Execution 2-40
Stored Procedure Execution 2-42
3. CORE SQL Language
NonStop ODBC Server Translation 3-1
Unsupported ODBC Features 3-2
Language Elements 3-2
Names 3-3
Data Types 3-8
Escape Clauses 3-11
Functions 3-14
String Functions 3-21
Search Conditions 3-24
Expressions and Operators 3-25
Aggregates 3-27
Wild-Card Characters 3-28
CASE Expression 3-29
CORE SQL Statements 3-31
ALTER TABLE 3-33
Example 3-34
Adding Multiple Columns 3-34
CORE SQL Compared With NonStop SQL/MP 3-34
CALL 3-35
Example 3-36
CORE SQL Compared With NonStop SQL/MP 3-36
CREATE INDEX 3-37
Examples 3-37
CORE SQL Compared With NonStop SQL/MP 3-38
CREATE TABLE 3-39