16.10 - FixSRandomRange - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Allows RANDOM function compatibility between systems managed by Teradata Unity that are running different versions of Teradata Database.

Prior releases of Teradata Database had an issue with the RANDOM function, RANDOM(lower_bound,upper_bound), whereby, in rare instances, the function could return a value that was one greater than the specified upper_bound. Although this issue has been fixed, in Unity-paired systems, RANDOM function behavior must be consistent between systems. This field ensures that the RANDOM function behaves identically for systems managed by Teradata Unity, regardless of the version of Teradata Database each system is running.

Field Group

General

Valid Settings

Setting Description
TRUE Ensures consistent and correct results for RANDOM function operations when multiple systems managed by Teradata Unity have the FixSRandomRange field available.
FALSE Maintains consistency of RANDOM function results between multiple systems managed by Teradata Unity when the FixSRandomRange field is not available on all systems.

Default

TRUE on systems initialized (sysinited) on Teradata Database15.0 or for which this issue with the RANDOM function has been fixed.

FALSE on systems upgraded from prior releases and not re-initialized, where this RANDOM issue still exists.

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

If all systems being managed by Teradata Unity have FixSRandomRange available in DBS control, it should be set to TRUE on all systems. Otherwise, it should be set to FALSE on all systems where the field is available.

Related Topics

For more information on… See…
the RANDOM function SQL Functions, Operators, Expressions, and Predicates
Teradata Unity Teradata Unity User Guide