Skip to Content

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.

+NUMFLDDLM

Use this parameter to override the default field delimiter character used for numeric data fields when unloading using UNLD FORMAT(ASCIIDEL).

The default action for placing a delimiter around numeric fields is not to delimit numeric fields. You can use most single characters as a delimiter except for the plus sign (+), a comma (,), or a blank. You do not need to use any character as a delimiter.

GUID-3F34E977-EF4D-494F-BA0B-92B535C9A7BE-low.png

Operands

null

(Default) Indicates a null value by specifying nothing between the parentheses: +NUMFLDDLM().

delimiter

A single character that represents the numeric field delimiter.

Information
Examples

In the following example, BMC AMI Unload does not delimit numeric strings:

+NUMFLDDLM()

In the following example, BMC AMI Unload delimits numeric strings with the USA dollar currency sign.

+NUMFLDDLM($)
Warning

Important

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

Related topic

BMC-AMI-Unload-parameters-ULDPARMS-DD 


 

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

BMC AMI Unload for Db2 12.1