Progress
Startup Command and Parameter
Reference


Collation Table (-cpcoll)

Operating 
System
and
Syntax 
UNIX
Windows 
-cpcoll tablename 
Use
With 
Maximum
Value 
Minimum
Value 
Single-user
Default 
Multi-user
Default 
CS, DBS, OID
Basic
Basic

tablename

Name of a collation table within the convmap.cp file.

Use Collation Table (-cpcoll) to identify a collation table that Progress uses with the code page in memory. The code page is specified by the Internal Code Page (-cpinternal) parameter.

Progress uses the collation rules that you specify to compare characters and sort records if a BY clause cannot be satisfied by an index. The collation rules specified with the -cpcoll parameter take precedence over the collation specified for any database Progress accesses during the session, except when Progress uses or modifies pre-existing indexes. When you update or rebuild a database’s indexes, Progress uses the collation rules originally defined for that database.

If you do not use -cpcoll, Progress uses the language collation rules defined for the first database on the command line. If you do not specify a database on the command line, Progress uses the collation rules with the name “basic.”

To retrieve the value of this startup parameter at runtime, use the SESSION System handle.

See the Progress Internationalization Guide for more information on collation tables.


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