ODBC Server Reference Manual

Contents
HP NonStop ODBC Server Reference Manual—429151-002
iv
3. CORE SQL Language (continued)
3. CORE SQL Language (continued)
Positioned UPDATE 3-61
Searched UPDATE 3-62
Example 3-63
CORE SQL Compared With NonStop SQL/MP 3-63
4. Transact-SQL Language
NonStop ODBC Server Translation 4-1
Using Transact-SQL Through the NonStop ODBC Server 4-2
Unsupported Features 4-3
Mapping of Table, View, and Index Names 4-3
DDL Statements Allowed in User-Defined Transactions 4-3
Specifying the Database Location 4-4
Batch Queries 4-4
Language Elements 4-5
Names 4-5
Data Types 4-12
Functions 4-17
Variables 4-26
Search Conditions 4-28
Expressions and Operators 4-29
Aggregates 4-31
Wild-Card Characters 4-33
NULL Values 4-34
Comments 4-35
Summary of Statements 4-35
Defaults, Rules, and Triggers 4-39
Miscellaneous Transact-SQL Statements 4-40
ALTER TABLE 4-42
Examples 4-42
Adding Multiple Columns 4-43
NonStop ODBC Server Compared With SQL Server 4-43
NonStop ODBC Server Compared With NonStop SQL/MP 4-44
BEGIN...END 4-44
Examples 4-44
NonStop ODBC Server Compared With SQL Server 4-45
NonStop ODBC Server Compared With NonStop SQL/MP 4-45
BEGIN TRANSACTION 4-45
Examples 4-45