create_cs
Use the create_cs command to store information in the database about a new coordinate system.
When this command is processed, information about the coordinate system is added to the DB2GSE.ST_COORDINATE_SYSTEMS catalog view.
Authorization
The user ID under which the command is invoked must have either SYSADM or DBADM authority.
Command syntax
DSN5SCLP /create_cs DALLAS
-coordsysName cs_name
-definition define_string
[-organization organization]
[-organizationCoordsysId org_cs_id]
[-description description_string]
Parameter descriptions
All parameters are required and case-sensitive unless otherwise indicated.
- -coordsys_name
- Uniquely identifies the coordinate system. You must specify a non-empty value for this parameter.
- -definition
- Defines the coordinate system. You must specify a non-empty value
for this parameter. The vendor that supplies the coordinate system
usually provides the information for this parameter. You must surround the definition with quotation marks. If you use quotation marks within the definition, you must combine the quotation mark with a backslash. You can use additional symbols for concatenation. For example:
-definition "GEOGCS[\"GCS_Swiss_TRF_1995\",+ DATUM[\"D_Swiss_TRF_1995\",SPHEROID[\"GRS_1980\",+ 6378137,298.257222101]],PRIMEM[\"Greenwich\",0],+ UNIT[\"Degree\",0.0174532925199432955]] " + -organization DB2 - -organization
- Identifies the organization that defined the coordinate system
and provided the definition for it; for example, "European Petroleum
Survey Group (EPSG)." This parameter is optional.
If this parameter is not specified, the -organizationCoordsysId parameter must also be unspecified. If this parameter is specified, the -organizationCoordsysId parameter must be specified; in this case, the combination of the -organization and -organizationCoordsysId parameters uniquely identifies the coordinate system.
- -organizationCoordsysId
- Specifies a numeric identifier. The entity that is specified in
the organization parameter assigns this
value. This value is not necessarily unique across all coordinate
systems. This parameter is optional.
If this parameter is not specified, the -organization parameter must also be unspecified. If this parameter is specified, the -organization parameter must be specified; in this case, the combination of the -organization and -organizationCoordsysId parameters uniquely identifies the coordinate system.
- -description
- Describes the coordinate system by explaining its application. This parameter is optional.
Example
DSN5SCLP /create_cs DALLAS +
-coordsysName "COORD_SYS2" +
-definition "GEOGCS[\"GCS_Swiss_TRF_1995\",+
DATUM[\"D_Swiss_TRF_1995\",SPHEROID[\"GRS_1980\",+
6378137,298.257222101]],PRIMEM[\"Greenwich\",0],+
UNIT[\"Degree\",0.0174532925199432955]] " +
-organization DB2 -organizationCoordsysId 5601 +
-description Camp_Area_Astro