The DB2GSE.GEOMETRY_COLUMNS catalog view
This catalog view shows selected columns of the catalog table that contains information about layers.
When you create a layer, IBM® Spatial Support for Db2 for z/OS® registers it by recording its identifier and information relating to it in a catalog table. Selected columns from the catalog table comprise the DB2GSE.GEOMETRY_COLUMNS catalog view, which is described in the following table.
| Name | Data Type | Nullable? | Content |
|---|---|---|---|
| LAYER_CATALOG | VARCHAR(30) | Yes | NULL. There is no concept of LAYER_CATALOG in IBM Spatial Support for Db2 for z/OS. |
| LAYER_SCHEMA | VARCHAR(30) | No | Schema of the table or view that contains the column that was registered as this layer. |
| LAYER_TABLE | VARCHAR(128) | No | Name of the table or view that contains the column that was registered as this layer. |
| LAYER_COLUMN | VARCHAR(128) | No | Name of the column that was registered as this layer. |
| GEOMETRY_TYPE | INTEGER | Yes | Data type of the column that was registered as this layer. If the column has a user-defined subtype of any of the geometry types defined by spatial support, then this value will be null. |
| SRID | INTEGER | No | Identifier of the spatial reference system used for the values in the column that was registered as this layer. |
| STORAGE_TYPE | INTEGER | Yes | This field is not being used. The value always will be null. |