Try OpenEdge Now
skip to main content
Internationalizing Applications
Using Databases : Empty databases : Creating an empty database in a particular code page
 

Creating an empty database in a particular code page

This section describes a technique for producing an empty database in a particular code page, which is included here for completeness.
To create an empty database with a code page:
1. Create an empty database, using the OpenEdge Data Dictionary utility.
2. Within the OpenEdge distribution, select the OpenEdge/prolang directory for the target locale.
For example, the OpenEdge/prolang/cze directory contains files used for Czech databases, while the OpenEdge/prolang/utf directory contains files used for Unicode databases.
3. Within the OpenEdge/prolang directory you selected, select the collation data definition (.df) file whose name corresponds to the target locale.
These .df files define database collations (as opposed to .df files that define database schemas). For example, the OpenEdge/prolang/cze directory contains the following collation data definition files:
*cze1250.df, associated with the CZECH collation of code page 1250
*cze852.df, associated with the CZECH collation of code page 852
*cze8859.df, associated with the CZECH collation of code page ISO8859-1
Note: The OpenEdge/prolang/utf directory contains the collation data definition files for the International Components for Unicode (ICU) collations (such as ICU-cs.df used for Czech databases).
4. Confirm the collation name of the .df file you selected in Step 3 by viewing its contents using a text editor. Search for the COLLATION-NAME keyword. The character string that follows is the name of the .df file's collation.
5. Load the .df file whose collation name you confirmed in Step 4 into the empty database you created in Step 1 using the following steps:
a. Using the Data Administration tool, choose Admin > Load Data and Definitions (.df file). The Load Data Definitions dialog box appears.
b. Enter the name of the data definition file into the Input File field, then choose OK.
The Data Administration tool calls .df files collation tables. The default is _tran.df, which contains the UTF-8 BASIC collation.
6. Rebuild all the database's indexes by running the PROUTIL utility with the IDXBUILD qualifier. The syntax is:
proutil db-name -C idxbuild all
-cpinternal internal-code-page -cpstream stream-code-page
For the complete syntax of the PROUTIL utility, see OpenEdge Data Management: Database Administration.
The empty database is now associated with the desired code page.