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.

Important

In this format, a SYSPUNCH or SYSCNTL file (if allocated) contains a LOAD statement for the generated file.

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.

Related topics

Output file formats

DSNTIAUL-format 

DIRECT

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

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.



 

  • 13.1
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*