Clarion Community Help

Navigation: SQL Drivers > SQLAnywhere Accelerator >====== SQLAnywhere Accelerator SQL Import Wizard–Login Dialog ======

Clarion's Dictionary Editor Import Wizard lets you import SQLAnywhere table definitions into your Clarion Data Dictionary. When you select the SQLAnywhere Accelerator from the driver drop-down list, the Import Wizard opens a login dialog. This dialog collects the connection information for the SQLAnywhere database.

Fill in the following fields in the Login/Connection dialog:

Database	Select the SQLAnywhere engine that contains the tables 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 engines.
Username	For Standard Security, type your Username. For Trusted Security (Integrated NT Security) no Username is required. See your server documentation or your DBA for information on applicable Usernames and security methods.
Password	For Standard Security, type your Password. For Trusted Security (Integrated NT Security) no Password is required. See your server documentation or your DBA for information on applicable Passwords and security methods.
Filter	Optionally, 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)

Disconnect from Server when Import is finished	Check this box to disconnect from the server after importing (or canceling). Generally, you should clear this box when importing multiple definitions in order to maintain your connection to the server between imports.
Next >	Press this button to open the Import Wizard's Import List dialog.