SAS/Warehouse Administrator Metadata API- P21: The operating system and SAS version that are associated with a given host are now available through the WHHOST property. For example, you can write a SAS/Warehouse Administrator add-in that reads the host metadata that is associated with a given data store and then uses these values to generate code that is appropriate for the operating system and SAS version. | SAS Warehouse Administrator Metadata Types A WHDBMSST 97 generators. If the API application is not secure this property returns a blank value if no user ID has been registered and it returns XXXXXXXX if the user ID has been registered. Using WHDBMS Add Update Delete Yes Yes Yes WHDBMS is an independent type. To understand how it relates to other types see the physical storage models in Relationships Among Metadata Types on page 53. Note The USERID and PASSWORD attributes are only valid with the _GET_METADATA_ method when the API application is a secure application. Currently the only secure applications are those that are registered as add-in generators. a WHDBMSST Metadata type for DBMS physical stores Category Physical Storage Types Parent WHPHYSTR on page 204 Overview WHDBMSST models the metadata for database management system physical stores in SAS Warehouse Administrator. To specify DBMS format for a table in a warehouse from the SAS Warehouse Administrator Explorer 1 Select a table with the right mouse button. 2 Select Properties from the pop-up menu. 3 Go to the Physical Storage tab. 4 Select DBMS as the storage format. Properties The following table lists all of the properties for WHDBMSST and indicates how you can use each property with metadata API methods. In the table you can specify properties with a Yes in the Indirect Add column when you indirectly add one object through another as described in the documentation for the _UPDATE_METADATA_ method. Use this approach to add a new dependent object. For details see Using _UPDATE_METADATA_ on page 46. 98 WHDBMSST A Chapter 3 You can pass properties with a Yes in the Update column to the _UPDATE_METADATA_ method as described in the documentation for this method. Use this method to update properties of an existing object. For details see Using _UPDATE_METADATA_ on page 46. Req indicates that the property is required you must provide a value for this property when you use a given method. Default indicates that
