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-45
Embedded SQL Statements
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 non-null 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, few of the
statements, options, and clauses have been dropped because of SQL:1999 ANSI
changes.
Table 4-12. Embedded SQL Statements (page1of2)
Embedded SQL/MP
Statements and Directives
Implemented
in SQL/MX? Comments
CLOSE Yes
DECLARE CURSOR Changed See Updatable Cursors
on page 4-46.
DESCRIBE Changed NonStop SQL/MX uses a SQL descriptor
area, as defined by ANSI SQL:1999. See
Descriptor Area
on page 4-48.
DESCRIBE INPUT Changed NonStop SQL/MX uses a SQL descriptor
area, as defined by ANSI SQL:1999. See
Descriptor Area
on page 4-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 4-52.
INCLUDE SQLDA No See Descriptor Area
on page 4-48.
INCLUDE SQLSA No See Statistics Area
on page 4-53.
INCLUDE STRUCTURES No See Descriptor Area
on page 4-48,
Diagnostics Area
on page 4-52, Statistics
Area on page 4-53.
INSERT Changed No RETURNING clause in NonStop
SQL/MX. See INSERT Statements
on
page 4-22.
INVOKE Changed No FORMAT clause in NonStop SQL/MX.
See INVOKE Directive
on page 4-43.
OPEN Changed NonStop SQL/MX uses a SQL descriptor
area, as defined by ANSI SQL:1999. See
Descriptor Area
on page 4-48.