When you use SQL database servers, the following applies:

  • The SQL database server is multi-threaded. This means each server process can handle multiple client connections.
  • The SQL server uses the current OpenEdge convmap.cp file. This is the one the PROCONV environment variable, if set, points to; otherwise, this is the one in the OpenEdge directory.
  • The SQL server uses the code page of the connected database as its internal code page. Similarly, the SQL server uses the collation table of the connected database as its internal collation table. This means that all queries executed on the server (as opposed to on the client) depend on the internal code page and the internal collation table of the database.
  • The SQL database server uses the same PROMSGS file as PROSERVE. This file is the one specified by the PROMSGS environment variable, if it is set. Otherwise, this file is the promsgs file in the OpenEdge directory.