Default configuration keywords specific to SQL Server

In addition to the default DBTUNE keywords common to all DBMSs that were listed in the topic Types of configuration keywords, there are ten SQL Server-specific configuration keywords present by default in the SDE_dbtune table. Nine of them have to do with specifying geometry storage. The tenth, IMS_GAZETTEER, controls the XML column type used with an ArcIMS gazetteer metadata service.

Geometry storage keywords

The following three keywords contain two parameters: the GEOMETRY_STORAGE parameter to set the feature class geometry storage type and the UI_TEXT parameter to allow the keyword to be used when creating data in ArcCatalog and other ArcObjects applications.

As mentioned in the topic Types of configuration keywords, if you specify a keyword that only has a few parameters, the rest of the parameters are read from the DEFAULTS configuration keyword. Therefore, if you specify GEOMETRY when you create a feature class in a geodatabase in SQL Server, the software uses the values for the GEOMETRY_STORAGE parameter from the GEOMETRY keyword, then goes to the DEFAULTS keyword for values for all the other parameters, such as B_STORAGE.

See Composite keywords and geometry storage for details on setting up network, terrain, and topology keywords for nondefault geometry types.

IMS_GAZETTEER keyword

The IMS_GAZETTEER keyword is designed to be used when storing data associated with an ArcIMS Gazetteer Metadata Service. It specifies that XML documents be stored using ArcSDE XML, which is the only supported XML type for ArcIMS Metadata Services.

##IMS_GAZETTEER
XML_COLUMN_STORAGE   "SDE_XML"

END

When you run the gazetteer import script to load the gazetteer export files, the IMS_GAZETTEER keyword is used by default. For more information about ArcIMS Metadata Services and the gazetteer, refer to the ArcIMS Metadata Service section of the ArcIMS help.

Related Topics


11/18/2013