The DB2GSE.ST_SIZINGS catalog view

The DB2GSE.ST_SIZINGS catalog view contains information about the allowable maximum lengths of values that you can assign to variables.

Use the DB2GSE.ST_SIZINGS catalog view to retrieve:
  • All the variables supported by IBM® Spatial Support for Db2 for z/OS®; 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 the 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
IBM Spatial Support for Db2 for z/OS does not support this variable.
DESCRIPTION VARCHAR(256) Yes Description of this variable.