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.

Related topics

Output file formats

FORMAT ASCIIDEL


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.

 

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