db2se alter_cs command

The db2se alter_cs command updates a coordinate system definition.

You can use this command to update the definition string, the organization name, the organization coordinate system identifier, and the description in a coordinated system defined by the db2se create_cs command or the ST_CREATE_COORDSYS stored procedure. The information about the coordinate system is available through the DB2GSE.ST_COORDINATE_SYSTEMS catalog view.

Authorization

The user ID must have DBADM and DATAACCESS authority on the spatially enabled database to run this command.

Command syntax

db2se alter_cs command

Command parameters

Where:

database_name: Specifies the name of the database for which you want to alter the coordinate system.
-userId user_id: Specifies the database user ID that has DATAACCESS authority on the database indicated by database_name.
-pw password: Specifies the password for user_id.
-coordsysName coordsys_name: Uniquely identifies the coordinate system. The maximum length for this parameter is 128 characters.
The coordsys_name value is converted to uppercase unless you enclose it in double quotation marks.
-definition def_string: Defines the coordinate system. The vendor that supplies the coordinate system usually provides the information for this parameter. The maximum length for this parameter is 2048 characters.
-organization org_string: Defines the name of the organization that defined the coordinate system and provided the definition for it; for example, "European Petroleum Survey Group (EPSG)." The maximum length for this parameter is 128 characters.
The combination of the org_string and org_cs_id uniquely identifies the coordinate system.
-organizationCoordsysId org_cs_id: Specifies a numeric identifier. The entity that is specified in org_string assigns this value. This value is not necessarily unique across all coordinate systems.
The combination of the org_string and org_cs_id uniquely identifies the coordinate system.
-description description_string: Describes the coordinate system by explaining its application. The maximum length for this parameter is 256 characters.

Usage notes

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.

Examples

The following example updates the definition of a coordinate system named MYCOORDSYS with a new organization name.

db2se alter_cs mydb -coordsysName mycoordsys -organization myNeworganizationb