SAS/Warehouse Administrator 2.3 Metadata API- P7

SAS/Warehouse Administrator Metadata API- P7: 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. | Metadata API Class A _GET_METADATA. 27 5 COLUMNS ID NAME PRODNUM DESC product number 9 ID NAME PRODNAME DESC product name 11 ID NAME PRODID DESC product id abbreviation 13 ID NAME _LOADTM DESC DateTime Stamp of when row was loaded 15 7 TABLE NAME PRODUCT 3 Example 2 Return Information about One Column l_cols getniteml l_meta COLUMNS l_col getiteml l_cols 4 Get all information about column note get_all 1 parameter call send i_api _GET_METADATA_ l_rc l_col 1 returns list L_COL ID DESC DateTime Stamp of when row was loaded NOTE 4083 INDEXES 4085 INPUT OBJECTS 4087 OUTPUT OBJECTS 4089 EXTENDED ATTRIBUTES 4096 TABLE ID NAME Product detail table DESC Contains information about all products 4091 FORMAT DATETIME. INFORMAT DATETIME. INPUT SOURCES 4093 LENGTH 8 OUTPUT TARGETS 4095 TYPE N CVALUE 28 _GET_METADATA_OBJECTS_ A Chapter 2 METADATA CREATED METADATA UPDATED NAME _LOADTM NVALUE . 3719 04MAR1997 15 29 29 04MAR1997 15 29 29 GET_METADATA_OBJECTS_ Lists metadata objects when it is passed repository and type Category Navigation Method Syntax CALL SEND i_api _GET_METADATA_OBJECTS_ l_rc l_objs search_secondary include_subtypes 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. C specifies the passed reposid and typeid of metadata that is to be returned. For the general format of these IDs see Identifying Metadata on page 7. l_objs L spcifies the returned list of metadata objects. List format id name. search_ secondary N specifies the passed indicator. Optional. Specifies whether the returned list should include .