uppercase

Overview

The uppercase statement is used to modify the name of, and/or the values in, a column such that any lower case characters are replaced with their upper case equivalent.

Syntax

uppercase heading|values [and heading|values] in columnColName1 [... ColNameN]

Although the syntax shown includes the keyword column, either column or columns may be specified. Both work in an identical manner.

Details

The heading and values keywords determine the scope of the processing to be applied. The columns named in ColName1 ... ColNameN may or may not be fully qualified. If a column name is not fully qualified then the default DSET will be assumed.

Only lower case characters in a column name or value are converted. Numbers, punctuation and other symbols are ignored. Any blank values in a column are ignored.

Examples

uppercase heading in column servicegroup
uppercase heading and values in columns servicegroup VMWare.usage.resourcepool chargeinterval
uppercase values in column Region