Determining what code page your print jobs use and setting the correct environment variable

Before you transform a print job, you need to determine what code page it uses, then set the PSFDBLANG environment variable to that code page. If the job was created on an AIX or a Windows workstation, you can determine the code page that the job uses by finding out what code page is active on that system. On the system that the job was created on, open a Command Prompt window and type:

chcp
then press Enter. The system responds with
Active code page: xxx
where xxx represents a three- to five-digit number. Use this number to set the PSFDBLANG environment variable with these steps.

  1. On your InfoPrint Manager server system, click the WindowsStart button and select Settings –>Control Panel.
    Note: If you have more than one InfoPrint Manager server system, you need to set this environment variable on all of the servers that contain actual destinations that will use the db2afp transform.
  2. In the Control Panel window, double-click System.
  3. In the System Properties dialog, click Environment.
  4. In the Variable field, type PSFDBLANG.
  5. In Code pages and their associated PSFDBLANG values, locate the Code Page Value that you got from your system above.

    Code pages and their associated PSFDBLANG values

    Code Page Value PSFDBLANG Value Language
    932 J Japanese PC
    950 T Traditional Chinese PC
    33722 or eucJP JE Japanese EUC
    964 or eucTW CE Traditional Chinese EUC
    970 or eucKR KE Traditional Korean EUC
  6. Find the PSFDBLANG Value that corresponds to that code page and type it in the Value field of the System Properties dialog.
    Note: The PSFDBLANG Value is case-sensitive. Be sure to type it in all caps.
  7. Click OK.

The db2afp command assumes that all jobs use this code page as long as you do not specify either the -i flag or the -e flag when running the command from a Command Prompt window.