Example: Setting Up Flat File Encoding Records

The example company primarily uses the flat file encoding character set CP1252, WIN-Latin 1, Western European. However, the Sales Order Entry program (P42101) uses the UTF8, Unicode character set, except when user JL5534221 runs version JDE0001 in the PDEVCLA environment; then the program uses the CP1250, WIN-Latin2, Central Europe character set. The same program occasionally, but not currently, uses the character set CP1254, WIN-Latin5, Turkish for environment PDEVASD2.

This table presents the information for the encoding records that the example company needs in the flat file encoding table:

User/Role

Application Name

Application Version Name

Environment

Encoding Name

Status

All

All

All

All

CP1252

Active

All

P42101

All

All

UTF8

Active

JL5534221

P42101

JDE0001

PDEVCLA

CP1250

Active

All

P42101

All

PDEVASD2

CP1254

Inactive

These steps provide instructions on how to set up flat file encoding records for the previous example:

Access the Work With Flat File Encoding form. In Solution Explorer, select the System Administration Tools, System Administration Tools, User Management, User Management Advanced and Technical Operations, Unicode Flat File Encoding Configuration.

  1. On the Work With Flat File Encoding form, click Add.

  2. On the Flat File Encoding Revisions form, complete these fields, and then click OK:

    • User / Role

      *PUBLIC includes all users and roles.

    • Environment

      *ALL includes all environments.

    • Program ID

      *DEFAULT includes all programs.

    • Version

      *DEFAULT includes all program versions.

    • Encoding Name

      Enter the following value: CP1252.

  3. Repeat the previous step to add the following records to the table:

    User/Role

    Environment

    Program ID

    Version

    Encoding Name

    *PUBLIC

    *ALL

    *DEFAULT

    *DEFAULT

    CP1252

    *PUBLIC

    *ALL

    P42101

    *DEFAULT

    UTF8

    JL5534221

    PDEVCLA

    P42101

    JDE0001

    CP1250

    *PUBLIC

    PDEVASD2

    P42101

    *DEFAULT

    CP1254

  4. Click Cancel to return to Work With Flat File Encoding.

  5. Click Find to display all of the flat file encoding records.

  6. Select the first record and from the Row menu, select Change Status to activate the recode.

  7. Repeat the previous step to activate the currently active records.

    This table displays the final configuration:

    User/Role

    Environment

    Program ID

    Version

    Encoding Name

    Status

    *PUBLIC

    *ALL

    *DEFAULT

    *DEFAULT

    CP1252

    AV

    *PUBLIC

    *ALL

    P42101

    *DEFAULT

    UTF8

    AV

    JL5534221

    PDEVCLA

    P42101

    JDE0001

    CP1250

    AV

    *PUBLIC

    PDEVASD2

    P42101

    *DEFAULT

    CP1254

    NA