iAnywhere.com - The Collation utility

The Collation utility

With the Collation utility, you can extract a collation (sorting sequence) into a file suitable for creating a database using a custom collation.

The file that is produced can be modified and used with Sybase Central or the -z option of dbinit to create a new database with a custom collation.

Exit codes are 0 (success) or non-zero (failure).

You must change the label on the following line in the collation file. If you do not, the custom collation will conflict with the original collation on which it is based.

Collation label (name)

For more information about custom collation sequences, see Creating a database with a custom collation.

You can access the Collation utility in the following ways:

From Sybase Central, using the Create Custom Collation wizard.
At a command prompt, using the dbcollat command.

Extracting a collation using the Create Custom Collation wizard
Extracting a collation using the dbcollat command-line utility