db2se shape_info command

The db2se shape_info command displays information about the contents of a shape file. If you specify the name of a database, this command also lists all coordinate systems and spatial reference systems in the shape file that are compatible with the specified database.

Authorization

The user ID must have the necessary privileges on the Db2® server to read the shape files.

If the -database parameter is specified, the user ID must have SELECT privilege on the SYSCAT.ST_COORDINATE_SYSTEMS and SYSCAT.ST_SPATIAL_REFERENCE_SYSTEMS catalog view.

Command syntax

db2se shape_info command

Command parameters

-fileName

The fully-qualified name of the shape file for which information is to be displayed. Spatial Analytics first looks for an exact match of the name that you specify. If it does not find an exact match, it looks first for a file with the .shp extension, and then for a file with the .SHP extension.

The maximum length for this parameter is 256 characters.

-database

The name of the database for which a all compatible coordinate systems and spatial reference systems are to be listed.

-userId

The database user ID that has DATAACCESS authority for the specified database.

-pw

The password of the user ID that has DATAACCESS authority for the specified database.

-sa 1

The imported data is to be processed using the Spatial Analytics component.

Example

Display information about a shape file named MYFILE, which is in the current directory.

db2se shape_info -fileName MYFILE

Display information about the shape file named offices. Also, list all coordinate systems and spatial reference systems in the shape file that are compatible with the database MYDB.

db2se shape_info -fileName ~/sqllib/samples/extenders/spatial/data/offices -database MYDB -sa 1