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-40
Floating-Point Data Types
NonStop SQL/MX returns a warning indicating that you selected an unsupported data
type with undefined contents. If you try to use the unsupported data type in any sort of
expression, NonStop SQL/MX returns an error.
Interval Literals
As in NonStop SQL/MP, an SQL/MX interval literal is either year-month or day-time. If
you are using SQL/MX DML statements with SQL/MP tables, NonStop SQL/MX
recognizes fields created with the FRACTION keyword and maps them directly to the
fractional precision of the SECOND field.
These are INTERVAL literals:
INTERVAL '7' DAY
INTERVAL '2-7' YEAR TO MONTH
INTERVAL '5:2:15:36.33' DAY TO SECOND(2)
An SQL/MP interval with a literal of DAY TO FRACTION(2) becomes DAY TO
SECOND(2) in NonStop SQL/MX.
Floating-Point Data Types
NonStop SQL/MP supports floating-point data types of FLOAT, REAL, and DOUBLE
PRECISION. A column in an SQL/MP table declared with a floating-point data type is
stored in Tandem floating-point format, and all computations on it are done assuming
that.
SQL/MX tables store columns in IEEE floating-point format, as data types of FLOAT,
REAL, and DOUBLE PRECISION. Input and output of data from and to application
host variables can be in Tandem or IEEE floating-point.
NonStop SQL/MX can select data from both SQL/MX and SQL/MP tables. The
returned data from MXCI is always in IEEE format. The returned data in an embedded
program can be in IEEE or Tandem format.
NonStop SQL/MX does not allow any column of the partitioning key of a table or index
to be a floating-point data type. If no partitioning key is specified, the clustering key
becomes the partitioning key.
For information about floating-point data types, see the
SQL/MX Reference Manual.
Data Security Language (DSL) Statements
SQL/MP DSL statements are not supported in NonStop SQL/MX. Table 10-11 lists the
SQL/MP DSL statements: