db2se shape_info command

The db2se shape_info command shows information about a shape file and its contents. For a specified database, this command can optionally display all compatible coordinate systems and spatial reference systems that are included in the shape file.

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 DB2GSE.ST_COORDINATE_SYSTEMS catalog view.

Command syntax

db2se shape_info command

Read syntax diagramSkip visual syntax diagramshape_info-fileNamefile_name -database database_name-userIduser_id-pwpassword

Command parameters

Where:
-fileName file_name
Specifies the full path name of the shape file that you want to display information about.

Db2 Spatial Extender first looks for an exact match of the name that you specify with the -fileName parameter. If Db2 Spatial Extender 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 database_name
Specifies the name of the database for which you want to find all compatible coordinate systems and spatial reference systems included in the file_name shape file.
-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.

Examples

The following example shows information about a shape file named MYFILE, which is located in the current directory.
db2se shape_info -fileName myfile
The following example shows information about a sample UNIX shape file named offices. The -database parameter finds all compatible coordinate systems and spatial reference systems in the named database (in this case, MYDB).
db2se shape_info -fileName ~/sqllib/samples/extenders/spatial/data/offices
                 -database myDB