%META:TOPICPARENT{name="ConfigureProgressTableview"}%
The following instructions will enable you to configure Multi-Tier Data Sources for tableview connectivity:
# Use a text editor to open your Session Rulebook. The default Rulebook is the {{{oplrqb.ini}}} file found in the /bin sub-directory of your server's OpenLink installation. For example:
{{{
vi /usr/lpp/openlink/bin/oplrqb.ini
}}}
# Locate the {{{[Environment PROGRESSXXX]}}} section which corresponds to your DSN's {{{Domain}}} or {{{Server Type}}}. For example:
{{{
[Environment PROGRESS82A]
}}}
# Set the Tableview attribute to the full path to your tableview.dat file. Ensure that there is no semicolon (";") in front of the Tableview attribute name. For example:
{{{
Tableview = /usr/lpp/openlink/bin/tableview.dat
}}}
# Save your changes and exit the file.
# Restart or reinitialize your Request Broker.
# Edit your client DSN.
# Remove any existing value from from the {{{Database}}} field in your DSN.
# Remove any existing value from the {{{DB Connect Options}}} field.
# Pass {{{-pf /full/path/to/your/tableview.pf}}} file in the {{{DB Connect Options}}} field. For example:
{{{
-pf /usr/lpp/openlink/bin/tableview.pf
}}}
# Test your connection.