SAS/Warehouse Administrator Metadata API- P48: 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. | 232 WHSASSTR A Chapter 3 Host L Yes Yes No Id C Req Req No Indexes L Yes Yes Yes Library L Yes Yes No Load Technique C Yes Yes No Metadata Created C Auto No No supplied Metadata Updated C Auto No No supplied Name C No No No Note L No No Yes NValue N Yes Yes No Table L Auto No No supplied Table Name C Yes Yes No Table Options L Default Default No New properties for WHSASSTR are as follows HOST specifies an SCL list of general identifying information about the host on which this data is accessed. LIBRARY specifies an SCL list of general identifying information about the SAS Library that contains this data store. TABLE OPTIONS specifies an SCL list of options that are used in creating or loading this table. The CREATE sublist contains the SQL options that are used to create the table. The LOAD sublist contains the DBLOAD statements that are used to load the table. See the Usage notes for details about the TABLE OPTIONS property and data set passwords. Using WHSASSTR Add Update Delete No Yes No WHSASSTR is a dependent type. To understand how it relates to other types see the physical storage models in Relationships Among Metadata Types on page 53. TABLE OPTIONS Property and SAS Data Set Passwords The actual data set passwords will only be returned using the _GET_METADATA_ method if the application is running as a secure application. The only method that is currently supported to run as a secure application is to run as an add-in generator. See SAS Warehouse Administrator Metadata Types A WHSCRFIL 233 SAS Warehouse Administrator User s Guide for documentation on running as an add-in generator. You can determine the presence of passwords however regardless of whether the application is secure. If the application is not secure and a password exists the appropriate data set password option will be returned with a value of xxxxxxxx 8 uppercase Xs . If the application is secure the actual password will be returned. The three supported password options are READ WRITE and .
