Hexagon Geospatial
MENU

GeoMedia Q&A

GeoMedia, a comprehensive and dynamic GIS, extracts compelling intelligence from geospatial data and integrates it to present actionable information.
Showing results for 
Search instead for 
Do you mean 

Reserved Words Governing Naming Conventions for Feature Names and Attribute Field Names

by psmith on ‎10-10-2017 03:19 PM - edited on ‎03-05-2019 07:59 AM by Moderator (561 Views)

Question

What are the naming conventions that are allowed / supported in GeoMedia Desktop applicatonsl for feature names and attribute fields?

Answer

GeoMedia Object Identifiers (GDO) must:
1. Contain only letters, numbers, and underscores
2. Begin with a letter

 

GDO has no notion of a view (vs. a table). Some data servers (most of the read-only ones) map identifiers found in their native data store, to something that is GDO compatible. Others (most of the read-write ones) do not, requiring that the user do so.

 

As for read-write feature stores, you will need to comply to the rules levied by the database type.  The reserved key words for Oracle can differ from those used by MS SQL for example. 

 

You should also pay attention to words that are reserved by GeoMedia s well as by the database you are trying to connect to. The words in the following list are the keywords in SQL Parser. They are considered GeoMedia Keywords. As such, they cannot be used in table or column names or anywhere else in a given warehouse. They can only be used as part of SQL queries.

 

 

GeoMedia Reserved Words:
AVG INTO TIME
BETWEEN IS TIMESTAMP
BY LIKE UNION
COMMIT MAX UPDATE
COUNT MIN VALUES
DATE NOT WHERE
DELETE NULL WITH
DESC ON TO_DATE
DISTINCT OR TO_CHAR
EXISTS ORDER TO_NUMBER
FLOAT ROLLBACK  
FROM SELECT  
GROUP SET  
HAVING SOME  
INSERT SUM  

 

Contributors