This example changes the configured threshold type for table SemiDb.OrderTbl to NO THRESHOLD
BTEQ -- Enter your SQL request or BTEQ command:
CALL TDStats.UpdateStatThresholdSettingJSON('{"DatabaseName":"SemiDb","TableName":"OrderTbl","ThresholdType":"N"}',jout);
Result:
jOut
{"NumUpdated":6}