SAS/Warehouse Administrator 2.3 Metadata API- P8

SAS/Warehouse Administrator Metadata API- P8: 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. | 32 GET SUBTYPES Chapter 2 l_types dellist l_types returns list l_types WHDETAIL Detail Table WHLDETL Detail Logical Table WHSUMTBL Summary Table WHODDTBL Operational Data Definition WHODTTBL Operational Data Table WHTBLPRC Process Output Tables WHDATTBL Data Table WHOLPSTR OLAP Structure WHTBLPRC Process Output Table 47 Example 2 Get Subtypes Expanded Get all Subtypes of Tables l_types makelist call send i_api _GET_SUBTYPES_ l_rc WHTABLE l_types 1 num_types listlen l_types if l_rc 0 then do call putlist l_types end if else do msg getnitemc l_rc MSG 1 1 ERROR _GET_SUBTYPES_ Failed. list_rc dellist l_rc end else l_types dellist l_types returns list L_types WHDETAIL Detail Table WHLDETL Detail Logical Table WHSUMTBL Summary Table WHODDTBL Operational Data Definition WHODTTBL Operational Data Table WHTBLPRC Process Output Tables WHDATTBL Data Table WHTBLMAP Mapping Process Table WHTBLUSR User Exit Process Table Metadata API Class A _GET_TYPES. 33 WHTBLXFR Data Transfer Process Table WHTBLREC Record Selector Process Table WHOLPSTR OLAP Structure WHGRPOLP OLAP Group WHOLPTBL OLAP Table WHOLPMDD OLAP MDDB 47 GET_TYPES_ Lists metadata types that are in the metadata API Category Management Methods Syntax CALL SEND i_api _GET_TYPES_ l_rc l_types component Parameters Parameter Type Description i_api Class specifies the passed instance of . See Using the Metadata API Class on page 14. l_rc N specifies the return codes for the method. A nonzero code indicates failure and means that l_rc is an error list identifier. For the error list format see Error Codes on page 14. l_types L specifies the returned list of metadata types. List format type_id type_name. component C specifies the passed component name. Optional. Can limit the returned list to the metadata types within a specific component. Details component specifies the passed component name such as WHOUSE for the SAS Warehouse Administrator component. Optional. Can limit the returned list to the metadata types .