SAS/Warehouse Administrator Metadata API- P2: 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. | 2 Changes and Enhancements A Chapter 1 WOLPHIR WOLPCRS WOLPCUB WHPHYSTR WHDMSST WHSASSTR WHPOBJECT WHJOB WHGRPJOB WHEVENT WHTFILE WHTXTFIL WHSCRFIL WHTXTCAT WHNOTE WHSRCCAT WHJOBCAT WHDW WHDWENV WHINFO WHINFOFL WHTABLE WHDATTBL WHDETAIL WHLDETL WHODDTBL WHODTTBL WHSUMTBL WHOLPSTC WHGRPOLP WHOLPTBL WHOLPMDD WHTBLPRC WHTBLMAP WHTBLREC WHTBLUSR WHTBLXFR WHPROCES WHPRCMAN WHPRCMAP WHPRCREC WHPRCUSR Introduction to the Metadata API A Changes and Enhancements 3 WHPRCXFR WHPRCLDR WHLDRDAT WHLDRDTL WHLDREXT WHLDRINF WHLDRIMF WHLDRLDT WHLDRMDB WHLDRODD WHLDRODT WHLDRSUM WHLDOTBL WHLDOMDD WHLDOPRX WHPRCSPR WHPRCPST WHSUBSET WHROWSEL The TABLE OPTIONS property of the WHDBMSST type has a new sublist the APPEND sublist. The APPEND sublist contains any SAS ACCESS LIBNAME data set options that are used to create or load the table such as BULKLOAD yes. Load process options for warehouse tables such as GENERATION LEVEL and DROP INDEXES are now surfaced through the WHPRCLDR type and all of its subtypes. For example you can write a SAS Warehouse Administrator add-in that reads the load options that are specified in a table s load process and uses these options to load the corresponding table. 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. You can now write OLAP objects through the metadata API. The following types have been updated WHMDDSTR WHOLPSTC WHGRPOLP WHOLPTBL WHOLPMDD WHCOLOLP WHOLPDIM WHOLPHIR WHOLPCRS WHOLPCUB. 4 Prerequisites A Chapter 1 Metadata for columns that are selected using point and click in the Expression Builder and that are used in either a WHERE clause or a row selector is now surfaced through the WHSUBSET and WHROWSEL types. For example you can .
