Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Spatial Data User's GuideThe HCL OneDB™ Spatial Data User's Guide contains information to assist you in using the HCL® OneDB® spatial extension. The HCL® OneDB® spatial extension adds custom data types and supporting routines to the server.
Appendixes
Load and unload shapefile dataUse the infoshp, loadshp, and unloadshp utilities for working with spatial data contained in ESRI shapefiles.
The infoshp utilityThe infoshp utility reports information extracted from headers of the .shp, .shx, and .dbf files that make up ESRI shapefiles. It also detects the presence of optional .prj files that may be associated with ESRI shapefiles and reports the coordinate system information. The infoshp utility can check for spatial_references table entries that are qualified to load one or more shapefiles. If no spatial reference exists that can be used to load the specified shapefiles, the infoshp utility can create a new entry in the spatial_references table for loading the shapefiles.

The infoshp utility

The infoshp utility reports information extracted from headers of the .shp, .shx, and .dbf files that make up ESRI shapefiles. It also detects the presence of optional .prj files that may be associated with ESRI shapefiles and reports the coordinate system information. The infoshp utility can check for spatial_references table entries that are qualified to load one or more shapefiles. If no spatial reference exists that can be used to load the specified shapefiles, the infoshp utility can create a new entry in the spatial_references table for loading the shapefiles.

Syntax

Info Info:

Operation modes

You use the -o flag to set the operation mode for the infoshp command. Set the -o flag to one of the following options:

check: Checks for spatial_references table entries that are qualified to load the specified shapefiles.
create: Creates a new entry in the spatial_references table for loading the specified shapefiles.
info: Reports information extracted from the headers of the .shp, .shx, .dbf, and optional .prj files associated with the specified shapefiles.

Command-line switches

You can use the infoshp command flags to specify the following options.

-D: The database name
-f: The path and name of one or more ESRI shapefiles to process
-p: (optional) The HCL® OneDB® password
If you specify the -p option, you must also specify the -u option.
-s (optional): The HCL OneDB server
Defaults to the value of the ONEDB_SERVER environment variable
-u (optional): The HCL OneDB user name
If you specify the -u option, you must also specify the -p option.
-V: Prints version information for this utility

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.