SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-37
Considerations—LOAD
An interval is expressed as a multiple of the smallest unit in the INTERVAL type.
For example, if the column in the table is defined as HOURS TO SECONDS, the
value of the interval "1:2:3" is 3723, which is the number of seconds in 1 hour, 2
minutes, and 3 seconds.
SQL does not support the Enscribe data types COMPLEX and LOGICAL, but an
Enscribe field of either one of these data types is compatible with an SQL column
of data type CHARACTER with the same length as the field.
The SQL date-time and INTERVAL data types have no directly corresponding
Enscribe types. (SQL date-time and INTERVAL types existed before the DDL types
of the same name but are not currently equivalent for COPY and LOAD
operations.)
When you load an Enscribe field into an SQL DATETIME column, the Enscribe
field must have the BINARY 64 data type and must contain a Julian timestamp (a
64-bit value that contains the number of microseconds between 00:00 January 1,
4713 B.C. and the date and time it represents). SQL converts the Julian timestamp
into an SQL DATETIME value and then stores the DATETIME value in the
DATETIME column.

Implied DDL descriptions
When you load between an SQL table and a non-SQL object (in either direction)
and do not provide a DDL record for the non-SQL object, LOAD operates as if a
DDL record description constructed according to these rules was supplied, and
MOVEBYORDER is ON. The DDL record description contains one field for each
column in the table. The type of the DDL field is determined by the type of the SQL
column it corresponds to:
SQL Data Type Enscribe Data Type
CHAR (n) PIC X(n)
PIC X(n) PIC X(n)
CHAR VARYING (n)
or VARCHAR(n)
02 <field name>
03 LEN PIC S9(4) COMP
03 VAL PIC X(n)
The value of the LEN field describes how many
characters in the VAL field comprise the current
value of the field.
DECIMAL(n, s) PIC S9(n-s)V9(s).
1
DECIMAL(n,s)
UNSIGNED
PIC 9(n-s)V9(s).
NUMERIC(n,s) BINARY 16,s. if 1 <= n and n <= 4
BINARY 32,s. if 5 <= n and n <= 9
BINARY 64,s. if 10 <= n and n <= 18