Adding a JDBC Property - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
sbq1486739977986.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
The Add JDBC Properties dialog displays when you add JDBC connection properties in the New Teradata Connection Profile or Teradata JDBC Connection Properties dialog. JDBC connection properties are defined by property value pairs.
  1. In JDBC Properties on the Add JDBC Property dialog box, select a JDBC property from the drop-down list. You can also select QUERY_BAND as a property to specify the query bands for a session.
  2. Select the value for the property in Select Property Value.
  3. [Optional] if the property you select requires a user-defined value, enter the value in the Enter JDBC Property Value dialog.
    1. In the JDBC Property Value field, type a value for the property.
    2. Click OK.
    Also the Enter JDBC Property Value dialog displays if you click Click to enter value in the Select Property Value field.
  4. [Optional] To manually enter a JDBC property that is not in the properties list, select the property called USER_ENTERED_PROPERTY and create a new property name value pair.
    1. In the New JDBC Property dialog, in Property Name, enter the name for the new JDBC property.
    2. In Property Value, enter the value for the new JDBC property.
    3. Click OK.
  5. Click OK. The JDBC property value pair is added to the JDBC Connection Properties.