Progress
Database Administration
Guide and 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

The 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 run time, 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