SQL/MX Comparison Guide for SQL/MP Users

Contents
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
ii
4. Embedded SQL
Identifiers (continued)
Date-time Literals 3-6
Interval Literals 3-8
Expressions and Functions 3-8
Numeric Value Expressions and Functions 3-9
Datetime Functions 3-9
Interval Value Expressions 3-10
Mathematical Functions 3-10
Sequence Functions 3-10
Aggregate Functions 3-11
Predicates 3-11
LIKE Predicate 3-11
Sort Operations 3-12
SQL DML Statements 3-12
Nonaudited Tables 3-13
INSERT Statement 3-14
SELECT Statement 3-15
UPDATE Statement 3-16
Access Options and Isolation Levels 3-16
Isolation Levels Contrasted Between NonStop SQL/MP and NonStop
SQL/MX 3-16
STABLE Access 3-17
Transaction Management 3-18
Starting and Ending a Transaction 3-18
SET TRANSACTION Statement 3-19
CONTROL TABLE Directive 3-21
CONTROL QUERY Directive 3-23
Query Caching
3-24
Query Type Comparison
3-27
Versioning 3-29
4. Embedded SQL
Host Variable Declarations 4-1
SETSCALE Function 4-1
Variable-Length Character Data in Embedded SQL C Programs 4-2
INVOKE Directive 4-3
Data Type Conversion 4-3
Host Variables With Date-time Data Types 4-3
Indicator Variables 4-3