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.

ASCIIDEL format


The BMC AMI Unload ASCIIDEL format unloads all fields to character format. This keyword is available only with the UNLD command.

Important

The ASCIIDEL keyword does not automatically generate a LOAD statement in a SYSPUNCH DD.

By default, BMC AMI Unload delimits character fields within double quotation marks. It does not delimit numeric fields and separates each field with a comma.

Example

The following unload statement:

UNLD DATA FORMAT(ASCIIDEL) FROM TABLE NGT.TABLE1

produces the following output file:

1    5    10   15   20   25   30   35   40
            +----+----+----+----+----+----+----+----+---
ROW 1:      'TODD',16,123.45,'USE UNLOAD!!'
ROW 2:      'MATTEO',32,9500.00,''
ROW 3:      'IRINA',48,,''

By default, null character data is represented by an empty string, or enclosed by two double quotation marks. Null numeric fields receive no data, as is shown in ROW 3.

Use BMC AMI Unload parameters to change delimiters, as shown in the following table:

Using parameters to change delimiters

Parameter

Function

To change the field delimiters for numeric data

To change the field delimiters for character data

To change the character used to separate fields from the default of comma (,) to any other character

These parameters affect all the unload statements in the job. You can also change them for a specific unload statement by using the UNLD keywords FIELDSEP, CHARFLDDLM, or NULLSTRING. For more information, see ASCIIDEL.

 

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