DB2GSE.ST_SIZINGS catalog view

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

This catalog view returns the following information:
  • All the variables supported by Db2® Spatial Extender; for example, coordinate system name, geocoder name, and variables to which well-known text representations of spatial data can be assigned.
  • The allowable maximum length, if known, of values assigned to these variables (for example, the maximum allowable lengths of names of coordinate systems, of names of geocoders, and of well-known text representations of spatial data).
For a description of columns in this view, see the following table.
Table 1. Columns in the DB2GSE.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
Spatial Extender does not support this variable.
DESCRIPTION VARCHAR(128) Yes Description of this variable.