Schema DDL Defining an item
U929-J-Z125-9-76 57
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007 24. Oktober 2007 Stand 09:30.23 Pfad: G:\vogt\fsc\ud s\Manuale\en\udsent_e\uds ent.k04
You can define the item to hold up to 18 digits.
If at least one of the following assertions applies to an unpacked numeric item, the item
cannot be accessed using SQL, nor can any new records of the reco rd type involved be
inserted:
– number of storage locations > 15
– scale factor < 0
– scale factor > number of storage locations
A positive scale factor specifies the number of digits to the right of the deci mal point, while
a negative scale factor specifies how many zeroes UDS/SQL must append to the item
contents when performing calculations.
V
Decimal point
symbol
specifies the position of the decimal point for the mask
defined by the digit symbols 9.
Default value is V after the last digit symbol of the
mask.
P
is specified if the decimal point is to be more than one
position outside the mask defined by digit symbols 9
and cannot be specified by ”V”.
P stands for a zero to be added by UDS/SQL between
the mask defined by digit symbols 9 and the decimal
point.
P can be repeated any number of times.
(integer) Repetition symbol
The digit symbol 9 and the decimal point symbol P can
be repeated. In order to avoid repeating the symbols,
the user can add a repetition factor integer after the
symbol to denote the number of times the symbol is to
be repeated.
Symbol Designation Explanation
Table 4:Symbols of mask-string when defining an unpacked numeric item (part 2 of 2)