Progress
Internationalization Guide


Creating an Empty Database In a Particular Code Page

Here is another technique for producing an empty database in a particular code. The technique is included here for completeness. To create an empty database with a code page, follow these steps:

  1. Create an empty database, using the Progress Data Dictionary utility.
  2. Within the Progress distribution, select the DLC/prolang directory for the target locale.
  3. For example, the DLC/prolang/cze directory contains files used for Czech databases,
    while the DLC/prolang/utf directory contains files used for Unicode UTF–8 databases.

  4. Within the DLC/prolang directory you selected, select the collation data definition (.df) file whose name corresponds to the target locale.
  5. These .df files define database collations (as opposed to .df files that define database schemas). For example, the DLC/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
  6. 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.
  7. 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:
    1. Using the Data Administration tool, choose Admin Load Data and Definitions (.df file). The Load Data Definitions dialog box appears.
    2. Enter the name of the data definition file into the Input File field, then choose OK.
    3. NOTE: The Data Administration tool calls .df files collation tables. The default is _tran.df.

  8. Rebuild the database’s indexes by running the PROUTIL utility with the IDXBUILD qualifier. The syntax is:
  9. SYNTAX
    proutil db-name -C idxbuild all
      -cpinternal internal-code-page
      -cpstream stream-code-page 
    

    For the complete syntax of the PROUTIL utility, see the Progress Database Administration Guide and Reference .

The empty database is now associated with the desired code page.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095