Writer instructions | |
|---|---|
Page title | For most spaces, this page must be titled Space announcements. For spaces with localized content, this page must be titled Space announcements l10n. |
Purpose | Provide an announcement banner on every page of your space. |
Location | Move this page outside of your home branch. |
Guidelines | |
+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.
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
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
The values are defined as follows:
IBM | (SPE2010) (Default) Uses IBM format |
|---|---|
CDB | Uses BMC AMI Utilities format |
Related topic