SAS/Warehouse Administrator 2.3 Metadata API- P10

SAS/Warehouse Administrator Metadata API- P10: 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. | 42 _SET_PRIMARY_REPOSITORY_ A Chapter 2 Examples Example 1 Access a Primary Metadata Repository Access the sample primary metadata repository that is shipped with SAS Warehouse Administrator which is a warehouse environment called Sample Demo. path SASROOT whouse dwdemo _master repos_type WHDWENV Insert the Location information into the metadata list with a name of LIBRARY. l_inmeta makelist l_lib makelist l_inmeta insertl l_inmeta l_lib -1 LIBRARY Use the default Libname Engine to access a Local Path. l_lib insertc l_lib -1 ENGINE l_path makelist l_lib insertl l_lib l_path -1 PATH l_opts makelist l_lib insertl l_lib l_opts -1 OPTIONS l_path insertc l_path path -1 Set the primary repository. If a bad return code is returned then you cannot continue. call send i_api _SET_PRIMARY_REPOSITORY_ l_rc l_inmeta repos_type primary_repos_id l_meta l_inmeta dellist l_inmeta Y if l_rc 0 then do Accessed the primary repository correctly. Example 2 Using _GET_METADATA_ to list secondary repositories Get the list of all repositories under the primary repository l_meta is l_meta returned from _SET_PRIMARY_REPOSITORY_. l_reps makelist l_meta setniteml l_meta l_reps REPOSITORIES call send i_api _GET_METADATA_ l_rc l_meta returns list l_meta ID NAME Warehouse Administrator DESC Sample Demo Warehouse Environment. Metadata API Class A _SET_SECONDARY_REPOSITORY. 43 REPOSITORIES ID NAME Marketing Campaigns Data Warehouse DESC Sample Data Warehouse. 2455 2201 2271 See Also _SET_SECONDARY_REPOSITORY_ SET_SECONDARY_REPOSITORY_ Attaches to a secondary metadata repository Category Repository Methods Syntax CALL SEND i_api _SET_SECONDARY_REPOSITORY_ l_rc l_meta repos_id already 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 .