User Tools

Site Tools


mssql_accelerator_sql_import_wizard_login_dialog.htm
Navigation:  SQL Drivers > MSSQL Accelerator >====== MSSQL Accelerator SQL Import Wizard–Login Dialog ====== Previous pageReturn to chapter overviewNext page

Clarion's Dictionary Editor Import Wizard lets you import MSSQL table definitions into your Clarion Data Dictionary. When you select the MSSQL Accelerator from the driver drop-down list, the Import Wizard opens the Login/Connection dialog. The Login/Connection dialog collects the connection information for the MSSQL database.

NoteBox.jpg

If you are using a Trusted Connection (Integrated NT Security), you must establish a connection to the NT workstation running the MSSQL Server before you can connect to the MSSQL database and import table definitions. You can verify your connection by running the MSSQL ISQL_w Server utility installed with your MSSQL Client software.

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

Servername Select the workstation running the MSSQL database to import from. If the Servername list is empty, you may type in the name. See your DBA or network administrator for information on how the server is specified.
Username For Standard Security, type your MSSQL 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 MSSQL 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.
Database Select the MSSQL 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.
Filter Optionally, provide a filter expression to limit the list of tables and views to import. The filter expression queries the dbo.sysobjects table. The filter expression is limited to 1024 characters in length.Tip: 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. Generally, filtering on MSSQL system tables requires not only an intimate knowledge of the MSSQL system tables, but also of the MSSQL stored procedures. For example, to filter on table owner:

uid = user_id('DBO')

See your SQL server documentation for information on the MSSQL system tables and stored procedures.

name CSTRING(31)
id LONG
uid SHORT
type STRING(2)
userstat SHORT
sysstat SHORT
indexdel SHORT
schema_ver SHORT
refdate STRING(8)
crdate STRING(8)
version LONG
deltrig LONG
instrig LONG
updtrig LONG
seltrig LONG
category LONG
cache SHORT
Next > Press this button to open the Import Wizard's Import List dialog.
mssql_accelerator_sql_import_wizard_login_dialog.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1