Skip to Content

DSNTIAUL-formatted output (FORMAT DSNTIAUL)

To produce an output file in which the unloaded data matches the format of the IBM DSNTIAUL program, specify FORMAT DSNTIAUL.

Unlike the DSNTIAUL program, UNLOAD PLUS (using DIRECT YES) supports ASCII and Unicode output.

Warning

Important

FORMAT STANDARD does not produce output that matches that of DSNTIAUL.

Related topics

Output format

Operational considerations

When you specify FORMAT DSNTIAUL, UNLOAD PLUS performs the following functions:

  • Provides data for all data types in internal format except for the date, time, and timestamp data types, which it provides in external format
  • Pads all variable-length fields (VARCHAR, VARGRAPHIC, and VARBINARY) with X'00' to their maximum length
  • Creates fixed-length output records with a maximum length of 32760 bytes
Warning

Important

If UNLOAD PLUS processes a LONG VARCHAR or LONG VARGRAPHIC column type, the maximum formatted row length might exceed the allowable output record length of 32760. You can use the INTO option with a field specification to reduce the length of the LONG column and avoid this error. To reduce the number of records that UNLOAD PLUS discards when they exceed the shortened length, specify the TRIM or TRUNCATE function to remove trailing spaces, or truncate the field to fit.

  • Treats a string constant as a variable length

  • Puts a one-byte null indicator field after all nullable fields

    The null indicator field contains either X'6F' if the field is null or X'00' if it is not null.

Restrictions

Note the following restrictions when you specify FORMAT DSNTIAUL:

  • You cannot use this option when unloading LOB or XML data. UNLOAD PLUS terminates in this case.
  • When you specify FORMAT DSNTIAUL, UNLOAD PLUS sets the following options to the values shown:
    • FIXEDVARCHAR to YES
    • NULLCHAR to ‘?’
    • NULLTYPE to T1
    • CONSTRULES to STANDARD
  • When you specify FORMAT DSNTIAUL, UNLOAD PLUS ignores the TRIM option.

 

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

UNLOAD PLUS for DB2 13.1