alter_cs

Use the alter_cs command to update a coordinate system definition in the database.

When this command is processed, information about the coordinate system is updated in the DB2GSE.ST_COORDINATE_SYSTEMS catalog view.

Attention: Use care with this command. If you use this command to change the definition of the coordinate system and you have existing spatial data that is associated with a spatial reference system that is based on this coordinate system, you might inadvertently change the spatial data. If spatial data is affected, you are responsible for ensuring that the changed spatial data is still accurate and valid.

Authorization

The user ID under which the command is invoked must have either SYSADM or DBADM authority.

Command syntax

DSN5SCLP /alter_cs DALLAS
	-coordsysName cs_name
	[-definition def_string]
	[-organization org_name]
	[-organizationCoordsysId org_cs_id]
	[-description description_string]

Parameter descriptions

All parameters are required and case-sensitive unless otherwise indicated.

-coordsysName: Uniquely identifies the coordinate system. You must specify a non-empty value for this parameter.
-definition: Defines the coordinate system. This parameter is optional.
If you do not specify this parameter, the definition of the coordinate system is not changed.
-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 you do not specify this parameter, the organization of the coordinate system is not changed. If you specify this parameter, then you must also specify the -organizationCoordsysId parameter. The combination of the -organization and -organizationCoordsysId parameters uniquely identifies the coordinate system.
-organizationCoordsysId: Specifies a numeric identifier that is assigned to this coordinate system by the entity listed in the organization parameter. This parameter is optional.
If this parameter is not specified, the -organization parameter must also be unspecified; in this case, the organization's coordinate system identifier is not changed. 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.
If this parameter is not specified, the description information about the coordinate system is not changed.

Example

This example shows the alter_cs command with all of the parameters specified.

DSN5SCLP /alter_cs DALLAS +
-coordsysName COORD_SYS1 +
-definition GEOGCS[\"GCS_Swiss_TRF_1996\",DATUM[+
\"D_Swiss_TRF_1995\",SPHEROID[GRS_1980,+
6378137,298.257222101]],PRIMEM[\"Greenwich\",0],+\
UNIT[\"Degree\",0.0174532925199432955]] +
-organization ESRIX -organizationCoordsysId 56029 +
-description Camp_Area_AstroX