Chapter 3 Defining rules and queries 63
Using the adapter rule helper utilities
5
In the Limit tables and views for owner field, type the user (owner) name.
6 Click Load Table & View Names.
All the tables and views from the user database are populated in the Available
Tables and Views list.
7 From the Available Tables and Views list, select the table or view, and click Add.
The table or view is added to the Selected Tables and Views list.
8 Click Update Columns.
The rule menus with your table and view names are populated into the
EIE:VendorFieldNames form. This form provides the field names to the rule
menus in the data mapping windows.
Populating Oracle field information for external data
tables using a command line
The following steps describe how you populate Oracle fields for multiple external
data tables and single external data tables using a command line.
X To populate Oracle field information for multiple external data tables using
a command line
1 Type the following command:
rlohelper -ax <ARServername>-ar <ARPort> -al <ARUser> -ap <ARPassword> -
os <SID> -ol <DBUser> -op <DBPassword> -oh <OracleDBDirectory> -oa <SID>
-to <DBOwner> -d
2 After you execute the command, click Refresh Table List on the Database Field
Menus Console window.
The Available Tables and Views list should now be populated.
3 From the Available Tables and Views list, select the table or view, and click Add.
The table or view is added to the Selected Tables and Views list.
4 After the Selected Tables and Views list is populated with table names, then use
the following command to populate the table fields in the EIE:VendorFieldnames
form:
rlohelper -ax <ARServername>-ar <ARPort> -al <ARUser> -ap <ARPassword> -
os <SID> -ol <DBUser> -op <DBPassword> -oh <OracleDBDirectory> -oa <SID>
-c -d
