SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-102
DDL Clause Mapping
VALUE IS "default-string"
VALUE IS ALL "default-character"
The two forms of the DDL VALUE IS clause used with PIC N fields are:
VALUE IS N"default-string"
VALUE IS ALL N"default-character"
If the CHARACTER option, the NATIONAL option, or the NATIONAL DEFAULT
option is not specified, the VALUE IS clause is converted:
DEFAULT "default-string"
DEFAULT "default-character-repeated"
default-string
specifies a default value for the column. If the default-string value
specified in the DDL VALUE IS clause is longer than eight bytes, the value is
truncated to eight bytes and a warning is displayed.
default-character-repeated
specifies either a single-byte character (for PIC X, PIC A, or TYPE
CHARACTER fields) or a double-byte character (for PIC N fields) that is
repeated to make a total of eight bytes. If more than one character is specified,
only the first character is repeated.

If the CHARACTER option or the NATIONAL option is specified, the VALUE IS
clauses are converted:
DEFAULT _char-set-name "default-string"
DEFAULT _char-set-name "default-character-repeated"
character-set-name
specifies the character set designated by either the CHARACTER or
NATIONAL option in the CONVERT command.

If the NATIONAL DEFAULT option is specified, the PIC N VALUE IS clauses are
converted:
DEFAULT N"default-string"
DEFAULT N"default-character-repeated"

CONVERT ignores these clauses:

Level-66 RENAMES clauses

Level-88 CONDITION-NAME clauses

DISPLAY clauses

MUST BE clauses