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

This example shows the create_cs command with all of the parameters specified.
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