Databases created on PCs or database servers store data in ANSI. To use these databases with EBCDIC-enabled subsystems such as IMS and CICS, you must have a database created with an alternate collating sequence.
You can run the Create Database tool
from the HCO for DB2 LUW user interface, or
(Windows platforms only)
using the
mfhco create command.
Note: If you use any of the IBM tools to create the database, all data will be returned to your application in ANSI collating sequence. IBM does provide some examples of how to create databases with alternate collating sequences but the EBCDIC to ANSI translation that IBM uses may be different from the translation used in this COBOL development system. Therefore it is very important that you use the Create Database tool to create the database.
