Default language.

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

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 Unload for Db2 13.1.

DELIMITED format


In this format, unload data files are in a delimited format.

Important

The UNLOAD command supports unloading data files in a delimited format only if you have applied PTF BQU0252.

When data is in a delimited format:

  • All fields in the input data set are character strings or external numeric values
  • Each column in a delimited file is separated from the next column by a column delimiter character

For each of the delimiter types that you can specify, you must ensure that the delimiter character is specified in the code page of the source data. You can specify the delimiter character as either a character or hexadecimal constant. You can specify either COLDEL '#' or COLDEL X'23'. For Unicode and ASCII encodings, you should specify the delimiter character in the utility statement as a hexadecimal constant, or the result can be unpredictable.

You can use the following delimiters with FORMAT(DELIMITED) on the UNLD command. For more information, see FORMAT-UNLD-syntax.

  • COLDEL specifies the column delimiter that is used in the unload file.
  • CHARDEL specifies the character string delimiter that is used in the unload file.
  • DECPT specifies the decimal point character that is used in the unload file.

You cannot specify the same character for more than one type of delimiter.

Related topic


 

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