guides:programming:programmers_reference_manual:oconv_keyword

OConv

Use the keyword OConv to specify a new or alternate output conversion (output format) for a column. The override specification can be any valid output conversion or formatting specification. Output conversions are most typically used to format columns containing data for money, date, time, or logical (Boolean) values (example: Y and N).

COLUMN Oconv "output_format"

OConv has the following parameter.

ParameterDescription
output_formatSpecify a valid output format for output_format

For information about available formats, refer to OConv().

In this example, the column INV_DT will be displayed with a date conversion that prints four digits for the year, and delimits month, day, and year with "/" (slash).

List INVOICE INV_DT OConv "D4/"

The phone number will be displayed right justified, with the area code enclosed in parentheses.

List CUSTOMER PHONE OConv "R(###) ###-####"
  • guides/programming/programmers_reference_manual/oconv_keyword.txt
  • Last modified: 2024/06/19 20:20
  • by 127.0.0.1