SetObjectOption Syntax - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248

API Definition

REPLACE PROCEDURE TDStats.SetObjectOptionJSON(
   IN jIn JSON(3000) CHARACTER SET UNICODE,
   OUT jOut JSON(3000) CHARACTER SET UNICODE)

JSON Keys

JSON Key IN/OUT Data Type Description
DatabaseName IN VARCHAR(128) Identifies the database containing the tables the specified option is being set for.
TableName IN VARCHAR(128) Identifies a particular table within DatabaseName the specified option is being set for.
ObjectListName IN VARCHAR(128) Specifies a previously defined list of objects to set the specified option for. See related API ObjectList APIs.
OptionName IN VARCHAR(64) Name of the table or database level option being set.
Valid values include:
  • 'NoBatching'
OptionValue IN VARCHAR(64) Value of the option being set.
Allowable values for the 'NoBatching' option are:
  • 'Y' – Generate a separate COLLECT STATISTICS statement for each individual statistic defined within a given table.
  • 'N' - Batch together all the individual statistics for a given table into the same COLLECT STATISTICS statement.
NumAdded OUT INTEGER Number of additions/updates made for the specified option.