SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
10-28
Predicates
Predicates
All SQL/MP predicates are supported in SQL/MX statements. Table 10-8 lists the
SQL/MP predicates that are supported in NonStop SQL/MX and describes the syntax
differences:
SUBSTRING Yes NonStop SQL/MP and NonStop SQL/MX differ
somewhat in how they handle particular types
of character strings. See Character Sets on
page 10-34.
SUM Yes No changes are required for NonStop SQL/MX.
TRIM Yes NonStop SQL/MP and NonStop SQL/MX differ
somewhat in how they handle particular types
of character strings. See Character Sets
on
page 10-34.
UPSHIFT Yes NonStop SQL/MP and NonStop SQL/MX differ
somewhat in how they handle particular types
of character strings. See Character Sets
on
page 10-34.
Table 10-8. SQL/MX and SQL/MP Predicates (page 1 of 2)
SQL/MP Predicates
Implemented
in SQL/MX? Comments
BETWEEN Yes, but
changes
might be
required.
For possible changes, see:
•
Aggregate Predicates in WHERE and
HAVING Clauses on page 10-29
•
Row-Value Constructors on page 10-30
Comparison Yes, but
changes
might be
required.
For possible changes, see:
•
Aggregate Predicates in WHERE and
HAVING Clauses on page 10-29
•
Row-Value Constructors on page 10-30
EXISTS Yes, but
changes
might be
required.
No changes are required for NonStop SQL/MX,
except for possible changes to the subquery.
For more information, see SELECT Statements
on page 10-23.
IN Yes, but
changes
might be
required.
For possible changes, see:
•
Aggregate Predicates in WHERE and
HAVING Clauses on page 10-29
•
Row-Value Constructors on page 10-30
Table 10-7. SQL/MX and SQL/MP Functions (page 3 of 3)
SQL/MP Functions
Implemented
in SQL/MX? Comments