User Tools

Site Tools


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

Clarion's Dictionary Editor Import Wizard lets you import Oracle table definitions into your Clarion Data Dictionary. When you select the Oracle 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 Oracle database.

Notes:

1.Before you can connect to the SQL database and import table definitions, the database must be started and must be accessible from your computer.

2.Only those indexes directly associated with the table as CONSTRAINTs are imported by the Oracle Accelerator driver. If you need more indexes, simply define them manually.

3.If the Oracle database INDEX flag is set to OFF, the Oracle Accelerator Import Wizard does not import CONSTRAINTS.

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

Host Select the Oracle host that contains the tables or views to import. If the Host list is empty, you may type in the host (a blank host specifies the Oracle 8 Personal database). See your DBA or network administrator for information on how the host is specified. For example, type 2: to connect to the local Personal Oracle (7.2 and earlier) database. X: prefixes an IPX host and TNS: prefixes a TCP/IP host. For Personal Oracle 8, leave the Host field blank.
Username Type your Oracle Username. See your server documentation or your DBA for information on applicable Usernames.
Password Type your Oracle Password. See your server documentation or your DBA for information on applicable Passwords.

Optionally, you type a complete connect string in the Username field using either of the following syntaxes:

username/password@Protocol:dbname

or

username@Protocol:dbname,password

For example, type:

scott/tiger@2:production1

in the Username field. Or, you may type just your username and the database name in the Username field, and type your password in the Password field.

For example, type:

scott@2:production1

in the Username field, then type

tiger

in the Password field. The Import Wizard displays the password as a series of asterisks. See your Oracle documentation for more information on Oracle connect string syntax.

Filter Optionally, provide a filter expression to limit the list of tables and views to import. The filter expression queries the ALL_CATALOG view. For example the filter: OWNER='SCOTT' returns only the tables which have SCOTT as the OWNER. . The filter expression is limited to 1024 characters in length.

TipBox.jpg

The filter is case sensitive, so type your filter value accordingly.

Following is a list of the ALL_CATALOG column names (and their Clarion datatypes) you can reference in your filter expression. See your Oracle documentation for more in formation on these columns.

OWNER CSTRING(31)
TABLE_NAME CSTRING(31)
TABLE_TYPE CSTRING(12)
Next > Press this button to open the Import Wizard's Import List dialog.
oracle_accelerator_table_import_wizard_login_dialog.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1