SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-38
Considerations—LOAD

When both the source and target of LOAD are SQL tables, the rules for null
values are the same as in any DML statement. When you perform a LOAD
command on one SQL table and one non-SQL object, you must give special
attention to null values, because Enscribe does not have a null value distinct
from all other values of a field.
LOAD implements a convention for indicating that a field of a non-SQL object
has the null value. The Enscribe DDL language defines NULL to be an attribute
of data fields. The NULL attribute is a one-byte value, specified either as an
integer value from 0 to 255 or as a single character in quotes. The convention
that LOAD implements is that an Enscribe field has the null value if each byte
of the field contains the value specified by the NULL attribute of that field.
For example, if the Enscribe DDL description of a file contains a field defined
as:
02 F1 PIC X(10) NULL 0.
SMALLINT BINARY 16.
SMALLINT UNSIGNED BINARY 16 UNSIGNED.
INT BINARY 32.
INT UNSIGNED BINARY 32 UNSIGNED.
LARGEINT BINARY 64.
PIC 9(d)V9(s) PIC 9(d)V9(s).
PIC S9(d)V9(s) PIC S9(d)V9(s).
1
PIC 9(d)V9(s) COMP same as NUMERIC(d+s,s) UNSIGNED
PIC S9(d)V9(s) COMP same as NUMERIC(d+s,s)
FLOAT FLOAT 64.
FLOAT(n) FLOAT 32. if 1 <= n and n <= 22
FLOAT 64. if 23 <= n and n <= 54
DOUBLE PRECISION FLOAT 64
REAL FLOAT 32
DATETIME, DATE, TIME,
or TIMESTAMP
BINARY 64
INTERVAL BINARY 16. if column size = 2
BINARY 32. if column size = 4
BINARY 64. if column size = 8
1
The Enscribe data type makes the sign a separate character, that is, the sign is not embedded.
SQL Data Type Enscribe Data Type