Installing jConnect system objects into a database

If you wish to use jConnect to access system table information (database metadata), you must add the jConnect system objects to your database.

By default, the jConnect system objects are added to a database for any database created using version 12.7, and to any database upgraded to version 12.7.

You can choose to add the jConnect objects to the database either when creating or upgrading, or at a later time.

You can install the jConnect system objects from Interactive SQL.

Adding the jConnect system objects to a version 12.7 database from Interactive SQL

Connect to the database from Interactive SQL as a user with DBA authority, and enter the following command in the SQL Statements pane:
```
read path\scripts\jcatalog.sql
```
where path is your Sybase IQ installation directory.

Tip You can also use a command prompt to add the jConnect system objects to a version 12.7 database. At the command prompt, type:

dbisql -c "uid=user;pwd=pwd" path\scripts\jcatalog.sql

where user and pwd identify a user with DBA authority, and path is your Sybase IQ installation directory.