Try OpenEdge Now
skip to main content
Internationalizing Applications
Using SQL : Starting database servers

Starting database servers

You can start a database server in two ways:
*By invoking PROSERVE from a command line or from an OpenEdge client
*By using OpenEdge Explorer or OpenEdge Management , a graphical application
When an OpenEdge client invokes PROSERVE, PROSERVE starts a database server on behalf of the client. For a ABL client, PROSERVE starts a ABL database server. For an SQL client, PROSERVE starts an SQL database server.
If a client invokes PROSERVE with startup parameters, such as -cpinternal, -cpstream, and -cpcoll, PROSERVE passes these values to the ABL or SQL database server. The ABL database server uses these values. The SQL database server, however, ignores some of these values. Specifically, the SQL database server ignores values for -cpinternal and -cpcoll passed from PROSERVE, using instead the internal code page and collation table of the database. However, the SQL database server does use the values for -cpstream and for the other code-page-related startup parameters (other than -cpinternal and -cpcoll) passed from PROSERVE.
When you start a database server using OpenEdge Explorer or OpenEdge Management you can specify a code page and a collation by using the Explorer's administrative features.
The following table lists localizable startup parameters and settings for SQL and ABL database servers.
Table 9. Localizable startup parameters and settings
Command line startup parameters
Command line startup parameter defaults
Progress Explorer settings
Progress Explorer setting defaults
Code page (internal)
Log character set
Case table
Collation table
Conversion map
OpenEdge Explorer and OpenEdge Management also let you set the log file's font. This allows you to choose a font that displays international characters correctly.
To set the log file's font:
1. From OpenEdge Explorer or OpenEdge Management, view a log file.
2. From the Action menu, select Font.... Alternatively, click on the toolbar Font icon. The standard Windows Font Selection dialog box appears.
3. In the Font Selection dialog box, choose a font, then click OK. OpenEdge Explorer or OpenEdge Management displays the log file using the font you selected.