Default language.

Information
Limited support BMC 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.

+CSVSIGN


Use this parameter to add a sign before a positive number or replace it with a space. This parameter is applicable to the FORMAT CSV and FORMAT DELIMITED options when operating on numerical values having one of the following data types:

CSVSIGN.png

Operands

HYPHEN

(default) Places a hyphen (-) before negative numbers and no character before non-negative numbers

PLUS

Places a hyphen (-) before negative numbers and a plus symbol (+) before non-negative numbers

SPACE

Places a hyphen (-) before negative numbers and a space before non-negative numbers

When you specify +CSVSIGN(SPACE), BMC AMI Unload formats numbers as follows:

Number

Format

Non-negative

bn

Negative

-n

where:

  • b is a blank character.
  • n is a number.
Warning

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

 

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

BMC AMI Unload for Db2 12.1