Propagating Mixed-Case Column Titles to a HOLD File

How to:

You can select the ASNAMES command in the Set tool to propagate custom column titles on the report output as field names to a HOLD Master File. To retain mixed-case column titles as field names, use the SET ASNAMES=MIXED command.


Top of page

x
Procedure: How to Propagate Mixed-Case Column Titles to a HOLD File
  1. From the Procedure Viewer in Developer Studio, click and hold a component connector (yellow diamond), then click the Set button on the Component Connector toolbox.

    The Set tool opens.

  2. Select ASNAMES from the Available Settings list and click Add.

    or

    Double-click ASNAMES.

    ASNAMES is added to the Used Settings list.

  3. Select a value from the Current Value list to set the ASNAMES command.

    You may select from the following options:

    • FOCUS. Uses the literal specified in an AS phrase as the field name and controls the way ACROSS fields are named only in HOLD files in FOCUS format. FOCUS is the default value.
    • MIXED. Uses the literal specified in an AS phrase for the field name, retaining the case of the AS name, and creates names for ACROSS fields that consist of the AS name value concatenated to the beginning of the ACROSS field value.
    • OFF. Does not use the literal specified in an AS phrase as a field name in HOLD files, and does not affect the way ACROSS fields are named.
    • ON. Uppercases the literal specified in an AS phrase and propagates it as the field name in the HOLD Master File. Creates names for ACROSS fields that consist of the AS name value concatenated to the beginning of the ACROSS field value and controls the way ACROSS fields are named in HOLD files of any format.

    The following image is an example of the ASNAMES command in the Set tool.

  4. Click OK to save the SET ASNAMES command and close the Set tool.

    The corresponding syntax is:

    SET ASNAMES = {FOCUS|MIXED|OFF|ON}

WebFOCUS