How Do I Create Language Support for the DB2/400 Database? (Magic xpi 4.13)
The following procedures describe the necessary steps for adding Language Support for the DB2/400 Database Management System. These procedures are carried out on the Windows Operating System computer where the Magic xpi Studio and the Data Mapper utility are installed.
These steps are necessary for the Data Mapper utility to map data to or from a DB2/400 database. To map data using a DB2/400 database, the Windows computer must be in the same network as the IBM i server where the DB2/400 database is installed.
Make the following changes to the Magic.ini configuration file:
-
Go to the [MAGIC_DBMS] section of the Magic.ini file.
-
In the line that starts with AS400, find the LANGUAGE=AS2EB.ENG entry. If your system language is not English, change the *.ENG file extension to match the language supported by your DB2/400 database.
-
Add a comma (,) at the end of the AS400 line and then enter the correct ASCII/EBCDIC translation path to the end of the line. For example, for German add support/ACS400.GER.
-
In the line that starts with DB2/400, add a comma (,) at the end of the line and then enter the correct ASCII/EDBCDIC translation path at the end of the line. For example, for German add support/ACS400.GER.
![](/PublicKnowledge/servlet/rtaImage?eid=ka23z000000H06D&feoid=00ND0000005rAjf&refid=0EM3z000007lC82)
| The extension used in the ASCII/EDBCDIC translation path in steps 3 and 4 must be the same as the extension added to the LANGUAGE entry in step 2. |
-
Add another comma (,) and add the correct ACS file. For example, for German add support/ACS400.GER.
-
Find the [MAGIC_LOGICAL_NAMES] section.
-
Change the date_format property to the platform date format. For example, the IBM i platform date format is YYYY-MM-DD.
Make the following changes to the Windows Environment Variables:
-
Right-click the My Computer icon on your desktop and select Properties to open the Windows System Properties.
-
Click the Advanced tab.
-
Click Environment Variables.
-
In the User variables for <name of computer> section, Select iBOLT_LANGUAGE and click Edit.
-
If this variable is not in the list, click New and enter iBOLT_LANGUAGE in the Variable name field. You do not need to click Edit, just add the path described in the next step in the Variable value field and click OK to close the dialog box, then continue with the final step.
-
Add the correct ASCII/EDBCDIC translation path in the Variable value field. For example, if you are using German then add support/AS2EB.GER.
-
Click OK to close the dialog box.
-
Click OK to close the Windows Environment Variables dialog box.
You must check the following to be sure that the Data Mapper utility works properly:
On the IBM i machine where your DB2/400 database is installed make sure that the User Profile for the User entered in the Database entry in the Resources section does not contain the number 65535 in the Coded character set ID option.