I want to use the FORMAT attribute to display the data in a specified format.
Could anybody tell what do the the following format symbols means:
Hope this helps
I - Represents the number of characters needed to display the INTEGER portion of numeric data. In the case of a DEC(10,2) data type, I is equivalent to 9(8).
N - Represents FULL CURRENCY NAME. For U.S. applications, this is usually 'U.S. Dollars'.
G - Represents the GROUP SEPARATOR as defined in the SDF. In U.S. applications, this is usually a comma (,) character. It is used to separate digits of the whole number into groups of three or less. It always appears as the first character in a FORMAT string.