Salesforce

How Do I Create Language Support for the DB2/400 Database? (Magic xpi 4.9)

Printable View
« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

How Do I Create Language Support for the DB2/400 Database? (Magic xpi 4.9)

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:

  1. Go to the [MAGIC_DBMS] section of the Magic.ini file.

  2. 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.

  3. 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.

  4. 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.

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.

  1. Add another comma (,) and add the correct ACS file. For example, for German add support/ACS400.GER.

  2. Find the [MAGIC_LOGICAL_NAMES] section.

  3. 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:

  1. Right-click the My Computer icon on your desktop and select Properties to open the Windows System Properties.

  2. Click the Advanced tab.

  3. Click Environment Variables.

  4. In the User variables for <name of computer> section, Select iBOLT_LANGUAGE and click Edit.

  5. 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.

  6. Add the correct ASCII/EDBCDIC translation path in the Variable value field. For example, if you are using German then add support/AS2EB.GER.

  7. Click OK to close the dialog box.

  8. Click OK to close the Windows Environment Variables dialog box.

Setting the User ID

You must check the following to be sure that the Data Mapper utility works properly:

  • To map data to or from a DB2/400 database you must enter information about the database in the Settings dialog box's Resources section. Make sure the name entered in the Resources section’s User field also exists on the IBM i machine where the DB2/400 database is located.

Setting Up the Magic xpi Server for IBM i

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.

Reference
Attachment 
Attachment