Adding the Code Page Parameter to a Master File

How to:

You can place a parameter in a Master File to document the code page of the associated data source, for example, if your data source is on a database that uses a different code page than your WebFOCUS Reporting Server.

The parameter in the Master File assumes that the WebFOCUS Reporting Server has been correctly configured for the referenced code page. It does not control interpretation of the data.

Procedure: How to Add the Code Page Parameter to a Master File Using the Synonym Editor

You can set the code page for a Master File by modifying the CODEPAGE parameter in the Properties panel in the Synonym Editor in App Studio or the Data Management Console (DMC).

  1. Open a synonym in the Synonym Editor.
    • App Studio. In the Environments Tree panel, expand the Data Servers node, the server, and the application folder containing your data. Optionally, use the Environments Tree toolbar to filter for Synonyms. Right-click the Master File you wish to open and click Open.
    • Data Management Console. In the navigation pane, expand the LOOPBACK server node, Application Directories, and the application folder containing your synonyms. Optionally, click Synonyms in the Filter group on the ribbon to show only synonyms in the navigation pane. Right-click the synonym whose Master File you wish to open and click Open.
    The synonym opens in the Synonym Editor.
  2. Make sure the Field View tab is displayed in the Synonym Editor. Right-click the name of the synonym in the Display Name (Title) column (application/filename) and click Properties.
    The Properties panel opens.
  3. In the Properties panel, select a code page from the CODEPAGE drop-down menu.
    The code page will be applied to the Master File of the synonym.

Procedure: How to Add the Code Page Parameter to a Master File Using the Text Editor

Alternatively, you can manually add the code page definition to the Master File using the text editor in App Studio, the Data Management Console, or the Web Console.

  1. Open a Master File in the text editor.
    • App Studio. In the Environments Tree panel, expand the Data Servers node, the server, and the application folder containing your data. Optionally, use the Environments Tree toolbar to filter for Synonyms. Right-click the Master File you wish to open and click Open in Text Editor.
    • Data Management Console. In the navigation pane, expand the LOOPBACK server node, Application Directories, and the application folder containing your synonyms. Optionally, click Synonyms in the Filter group on the ribbon to show only synonyms in the navigation pane. Right-click the synonym whose Master File you wish to open and click Edit as Text.
    • Web Console. In the Web Console, click the Applications tab. In the navigation pane, expand the application folder that contains your synonym. Optionally, click Filter in the Application Preferences group on the ribbon, point to Synonyms, and click All Synonyms to show only synonyms in the navigation pane. Right-click the synonym whose Master File you wish to edit and click Edit as Text.

    The Master File opens in the text editor.

  2. Determine the code page you would like to apply.

    A complete list of code pages is available in Language and Default Code Pages for Windows, UNIX, and Linux.

  3. On the first line, after the SUFFIX parameter, type CODEPAGE= followed by the number of the code page that you want to apply and a comma.

Example: Adding the Code Page Parameter to a Master File

In this example, the user added code page documentation to the EMPLOYEE Master File. The selected code page value, 863 (IBM PC Canadian French), appears on line 5 in the text editor, on the first line of the Master File (each line ends with a dollar sign).


Image of text editor showing Master File with CODEPAGE definition

WebFOCUS

Feedback