Writer instructions | |
|---|---|
Page title | For most spaces, this page must be titled Space announcements. For spaces with localized content, this page must be titled Space announcements l10n. |
Purpose | Provide an announcement banner on every page of your space. |
Location | Move this page outside of your home branch. |
Guidelines | |
EXTERNAL format
This format is similar to the DSNTIAUL format in Db2, except that BMC AMI Unload unloads numeric fields in right-justified external format.
The NULL marker immediately precedes or follows nullable columns. This marker may consist of a single character or a string of up to four characters.
A NULL marker of binary zeros (X'00') indicates that the column value was not null when unloaded.
A NULL marker without binary zeros indicates that the column value was null when unloaded. The area in the output row represented by that column contains binary zeros.
The following table shows the maximum length for different numeric data types:
Data type | Maximum length |
|---|---|
SMALLINT | 6 bytes |
INTEGER | 11 bytes |
DECIMAL (p,s) | The precision plus 2 bytes |
FLOAT(21) | 15 bytes |
FLOAT(23) | 23 bytes |
BIGINT | 20 bytes |
DECFLOAT(16) | 23 bytes |
DECFLOAT(34) | 42 bytes |
(PTF BQU2139 applied) If you specify FORMAT EXTERNAL with DIRECT YES, BMC AMI Unload unloads string constants in SELECT statements as fixed-length strings. If you specify FORMAT EXTERNAL with DIRECT NO, BMC AMI Unload unloads string constants in SELECT statements as variable-length strings.
Related topics