DQL Statements › PICTURE Clause › Replacement Characters

Replacement Characters

The following is a list of the valid replacement characters you can include in an edit pattern. View the extended column display to determine the number of digits in the specified column.

9

Specifies that the corresponding digit position in the value of the column is to contain a decimal digit.

Z

Indicates that if a leading zero appears in the corresponding position in the value of the column, a blank character replaces the zero when the value is displayed. If a nonzero digit appears in the corresponding position in the value, the digit is displayed.

*

Indicates that if a leading zero appears in the corresponding position in the value of the column, an asterisk replaces it when the value is displayed. If a nonzero digit appears in the corresponding position, the digit is displayed.