SYSGEO.ST_SIZINGS catalog view

Use the SYSGEO.ST_SIZINGS catalog view to retrieve information about supported variables and their maximum length.

This catalog view returns information about spatial variables, for example, coordinate system name and variables to which well-known text formats of spatial data can be assigned. This information includes the allowable maximum length, if known, of values assigned to these variables (for example, the maximum allowable lengths of names of coordinate systems).

For a description of columns in this view, see the following table.

Table 1. Columns in the SYSGEO.ST_SIZINGS catalog view
Name	Data type	Nullable?	Content
VARIABLE_NAME	VARCHAR(128)	No	Term that denotes a variable. The term is unique within the database.
SUPPORTED_VALUE	INTEGER	Yes	Allowable maximum length of the values assigned to the variable shown in the VARIABLE_NAME column. Possible values in the SUPPORTED_VALUE column are: A numeric value other than 0 The allowable maximum length of values assigned to this variable. 0 Either any length is allowed, or the allowable length cannot be determined. NULL The variable is not supported.
DESCRIPTION	VARCHAR(128)	Yes	Description of this variable.