SQL/MP to SQL/MX Database and Application Migration Guide

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
4-28
Predicates
Predicates
All SQL/MP predicates are supported in SQL/MX statements. Table 4-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 4-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 4-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 4-34.
Table 4-8. SQL/MX and SQL/MP Predicates (page1of2)
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 4-29

Row-Value Constructors on page 4-30
Comparison Yes, but
changes
might be
required.
For possible changes, see:

Aggregate Predicates in WHERE and
HAVING Clauses on page 4-29

Row-Value Constructors on page 4-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 4-23.
IN Yes, but
changes
might be
required.
For possible changes, see:

Aggregate Predicates in WHERE and
HAVING Clauses on page 4-29

Row-Value Constructors on page 4-30
Table 4-7. SQL/MX and SQL/MP Functions (page3of3)
SQL/MP Functions
Implemented
in SQL/MX? Comments