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.

+FIELDSEP

Use this parameter to override the default field separator character (a comma) between fields when unloading using UNLD FORMAT ASCIIDEL.

FIELDSEP.png

You can use any single character as a separator character except for a plus sign. You can use a blank as a separator.

The UNLD command option FORMAT ASCIIDEL FIELDSEP overrides this parameter.

Operands

,

(SPE2010) (Default) Comma is the default field separator

char

A single character representing a field separator

Information
Examples
+FIELDSEP(-)

BMC AMI Unload separates all fields with a hyphen.

In both of the following examples, BMC AMI Unload places a blank between all fields:

+FIELDSEP()
+FIELDSEP( )
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