Override Session Properties | Teradata Connector | QueryGrid - Overriding Session Properties - Teradata QueryGrid

QueryGrid™ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem
Designating a Teradata connector property as overridable in the QueryGrid portlet allows you to override configured Teradata connector properties when starting queries during an individual processing session.

When you override a Teradata connector property, the servername in the syntax statement indicates the foreign server the listed and overridable Teradata connector properties apply. The designated foreign server uses the value of the properties listed in the syntax statement until the occurrence (if any) of another servername.

  1. Under Fabric Configuration, select Fabrics.
  2. Select the fabric.
  3. Perform one of the following:
    Option Description
    To override a Teradata connector property in the Connectors tab
    1. Select the Connectors tab.
    2. Select "" next to the connector that has the property to override.
    3. Select Edit.
    4. Select "" next to Connector Software.
    5. Find the Teradata connector property to override and select the Overridable check box.
    6. Select OK.
    7. Select Save..
    To override a Teradata connector property in the Links tab
    1. Select the Links tab.
    2. Select "" next to the link that has the property to override.
    3. Select Edit.
    4. Select "" next to Initiating Connector or Target Connector.
    5. Find the Teradata link property to override and select the Overridable check box.
    6. Select OK.
    7. Select Save..
  4. Use the following syntax when running Teradata Database 16.00 or later to override the Teradata connector property during a session:
    set foreign server attr = ‘servername=<fs1>;<prop1>=<overrideVal1>;…;servername=<fs2>
    <prop1>=<overrideVal1>;…;’ for session volatile;
    For example:
    Set foreign server attr = ‘servername=fs1;readtimeout=500000;writetimeout=200000;servername=fs2;
    responsetimeout=250000;’ for session volatile;
  5. [Optional] To clear Teradata connector property overrides without closing a session, use the following syntax:
    Set foreign server attr = NONE for session volatile;