+DIGITS

The +DIGITS parameter specifies how to handle numerical columns. The DIGITS keyword, specified in //UTLPARMS, enforces compatibility between certain IBM Db2 SQL functions and BMC AMI Utilities SQL functions.

The CHAR( ) and DIGITS( ) functions differ in output from the standard Db2 SQL functions. To enforce compatibility between BMC AMI Utilities and Db2 versions of the product, these options automatically change the output of those functions to a format compatible with Db2.

Related topic

Global-parameters-UTLPARMS

Under the BMC AMI Utilities implementation, the DIGITS function generates an odd number of digits by taking the next highest odd precision of its argument, if even.

The following numerics exhibit the following behaviors with +DIGITS(CDB):

  • An INTEGER generates 11 digits
  • A SMALLINT generates 5 digits
  • A DECIMAL generates P+N digits, where P is the precision of the argument and n=0
  • If p is odd or n=1 otherwise

Important

This parameter is ignored under the following circumstances:

  • Execution of the BMC AMI Unload utility with UNLOAD command.
  • MODE(AUTO) is coded with UNLD command. 


Under the Db2 implementation or +DIGITS(IBM), numeric columns are generated as follows:

  • An INTEGER generates 10 digits
  • A SMALLINT generates 5 digits
  • A DECIMAL generates P digits, where P is the precision of the decimal

DIGITS_PTF_BQU1066.png

The values are defined as follows:

IBM

(Default) Uses IBM format

CDB

Uses BMC AMI Utilities format


Warning

If you are an existing customer of BMC AMI Utilities and have used +DIGITS( ) in any of your job streams, do not change the default. Changing the default may cause your existing jobs to fail or produce incorrect results. Also, coding the +DIGITS( ) option affects all products that use the WHERE clause processor.

Example
+DIGITS(CDB)

The BMC AMI Utilities approach is used to handle numeric values for this product job.

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*