16
The database you are attempting to LOAD was DUMPed under a different sort order ID (%d) or character set ID (%d) than the ones running on this server (SortOrd = %d, CharSet = %d). If the sort orders differ, at least one of them is non-binary.
A database cannot be loaded into a server using load database unless the sort order of the server that dumped the database matches the sort order of the server into which the database is being loaded. Error 3120 occurs when you try to load a database on an Adaptive Server with a different sort order from that of the dumped database.
Use one of the following options to resolve the error:
Move the data using bcp rather than load.
Change the sort order of the Adaptive Server. Refer to “Configuring Character Sets, Sort Orders, and Languages” in the System Administration Guide: Volume 1 for instructions.
If the server into which you want to load the database is a new server:
Reinstall the server with the correct sort order.
Re-create the databases with the load option.
Retry the load.
All versions
