Can Cause Corruption in System Tables. The ODBC documentation erroneously states that the version 2.0 Cloudscape ODBC Driver is compatible only with Cloudscape Version 2.0. It should say that the version 2.0 ODBC Driver is compatible with all versions of Cloudscape 2.0 or higher. Cloudscape allows you to specify the encryption provider and algorithm when you create an encrypted database. This is the expected behavior, but this warning may not be explicit enough in the documentation.
Defaults Bug no.
Here are some more explicit instructions on how to do this. Export the data the way you normally would. Drop the autoincrement default. Re-import the data the way you normally would. Re-add the autoincrement default.