If you want to use jConnect to access system table information (database metadata), you must add the jConnect system objects to your database.
You can add the jConnect system objects to the database when creating, when upgrading, or at a later time. If, at a later time, you update your jConnect with a newer version, you must also run the latest version of jcatalog.sql.
You can install the jConnect system objects from Sybase Central or from Interactive SQL.
Connect to the database from Sybase Central as a DBA user.
In the left pane, select the database, and then from the File menu choose Upgrade Database.
The Upgrade Database wizard appears.
Follow the instructions in the wizard to add jConnect support to the database.
Connect to the database from Interactive SQL as a DBA user, and execute the following statement (path is your SQL Anywhere installation directory):
You can also add the jConnect system objects to a database from a command prompt by executing the following command:
dbisql -c "connection-string" install-dir\scripts\jcatalog.sql
In this command, connection-string is a suitable connection string that enables access to a database and server as a DBA user, and install-dir is your SQL Anywhere installation directory.