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
-cpinternal
ISO8859-1
Code page (internal)
ISO8859-1
-cpstream
IBM850
NA
IBM850
-cplog
IBM850
Log character set
ISO8859-1
-cpcase
BASIC
Case table
BASIC
-cpcoll
BASIC
Collation table
BASIC
-convmap
OpenEdge/convmap.cp
Conversion map
OpenEdge/convmap.cp
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.