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-45
Embedded SQL Statements
if (parts.partdesc_i > 0 ) handle_truncated_value();
...
In NonStop SQL/MP, the indicator variable is not set to the source length in the case of
truncation. It is set to 0 if it is a nonnull value and if the value is null, the indicator
variable is set to -1.
Embedded SQL Statements
Most embedded SQL/MP statements exist in NonStop SQL/MX. However, a few of the
statements, options, and clauses have been dropped because of SQL:1999 ANSI
changes.
Table 10-12. Embedded SQL Statements (page 1 of 2)
Embedded SQL/MP
Statements and Directives
Implemented
in SQL/MX? Comments
CLOSE Yes
DECLARE CURSOR Changed See Updatable Cursors
on page 10-46.
DESCRIBE Changed NonStop SQL/MX uses an SQL descriptor
area, as defined by ANSI SQL:1999. See
Descriptor Area
on page 10-48.
DESCRIBE INPUT Changed NonStop SQL/MX uses an SQL descriptor
area, as defined by ANSI SQL:1999. See
Descriptor Area
on page 10-48.
EXECUTE Changed No RETURNING clause in NonStop
SQL/MX.
EXECUTE IMMEDIATE Yes
FETCH Changed NonStop SQL/MX requires the number of
host variables in the fetch list to be the same
as the number of values returned in the
cursor specification.
FREE RESOURCES No
INCLUDE SQLCA No See Diagnostics Area
on page 10-53.
INCLUDE SQLDA No See Descriptor Area
on page 10-48.
INCLUDE SQLSA No See Statistics Area
on page 10-53.
INCLUDE STRUCTURES No See Descriptor Area
on page 10-48,
Diagnostics Area on page 10-53, Statistics
Area on page 10-53.
INSERT Changed No RETURNING clause in NonStop
SQL/MX. See INSERT Statements
on
page 10-22.
INVOKE Changed No FORMAT clause in NonStop SQL/MX.
See INVOKE Directive
on page 10-43.