Default language.

Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Load for Db2 13.1.

Field specification

Field specifications define the format and data type characteristics of the input data. This topic includes the following syntax diagrams:

field specification syntax

field_spec_SPE1907.png

defaultifvalue selection syntax

value_spec_spe1907.png


field selection syntax

field_selection syntax.png

data type specification syntax

See Data-type-keywords-for-BMC-AMI-Load.


value specification syntax

NGT_Load_value_spec.png

Additional considerations

The following considerations apply to field specifications:

  • If you include a field specification, the input fields and the clauses that make up the entire field specification can be in any position or sequence. 

  • If you omit the field specification, the input data must be in the required format for the specified FORMAT option. For example, if you specify FORMAT UNLOAD, the input must be in UNLOAD format.

    If you do not specify the FORMAT option, the input must be in DSNTIAUL format and must not have any nullable fields.

  • (PTF BQU2620 applied) On an EBCDIC MIXED YES subsystem, if you either omit the field specifications or omit the MIXED parameter at the field level, MIXED is assumed under the following rules:
    • EBCDIC is supplied as the encoding scheme 
    • The CCSID set for mixed data is supplied and matches the subsystem settings.
    • If the CCSID or encoding scheme are not present, default to CCSID and encoding scheme of the object, which must match the subsystem settings. 
    • You cannot change the character column attributes. That is, if the column is defined as MIXED, it must remain as MIXED.

  • If you include a field specification, you must include all columns that are defined as NOT NULL without defaults.

    Any column excluded from this clause because it is nullable receives a null value.

    Any column excluded from this clause because it is defined as NOT NULL WITH DEFAULT receives a default value.

  • As in Db2 LOAD, if the input file has unpadded variable-length fields, any fields that follow are misaligned. To avoid this issue, specify PAD when unloading the data.

For more information about field specifications, see the following topics:

Related topics

PAD

Syntax-diagrams-for-BMC-AMI-Load

INTO-TABLE-options 

 

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