User Tools

Site Tools


sqlanywhere_accelerator_synchronizer_login_dialog.htm
Navigation:  SQL Drivers > SQLAnywhere Accelerator >====== SQLAnywhere Accelerator Synchronizer Login Dialog ====== Previous pageReturn to chapter overviewNext page

Clarion's Dictionary Synchronizer Wizard (Enterprise Edition) lets you import an entire SQLAnywhere database definition into your Clarion Data Dictionary in a single pass. During this process, the Synchronizer Wizard opens an SQLAnywhere login dialog. This dialog collects the connection information for the SQLAnywhere database.

Fill in the following fields in the login dialog:

Database Select the SQLAnywhere database that contains the tables or views to import. If the Database list is empty, you may type in the name. See your server documentation or your DBA for information on database names.
Username Type your SQLAnywhere Username. See your server documentation or your DBA for information on Usernames.
Password Type your SQLAnywhere Password. See your server documentation or your DBA for information on Passwords.
Include System Files Select this option to include system tables in the list of importable objects.
Exclude System Files Select this option to exclude system tables from the list of importable objects.
Other Filter Select this option to provide a filter expression to limit the list of tables and views to import. The filter expression queries the SYSCATALOG view. The filter expression is limited to 1024 characters in length. The filter is case sensitive, so type your filter value accordingly.

Following is a list of the column names (and their Clarion datatypes) you can reference in your filter expression. See your SQLAnywhere documentation for information on these fields.

CREATOR STRING(128)
TNAME STRING(128)
DBSPACENAME STRING(128)
TABLETYPE STRING(10)
NCOLS LONG
PRIMARY_KEY STRING(1)
CHECK STRING(32767)
REMARKS STRING(32767)
sqlanywhere_accelerator_synchronizer_login_dialog.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1