Đang chuẩn bị liên kết để tải về tài liệu:
SAS/Warehouse Administrator 2.3 Metadata API- P11

Không đóng trình duyệt đến khi xuất hiện nút TẢI XUỐNG Tải xuống

SAS/Warehouse Administrator 2.3 Metadata API- P11: 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 _UPDATE_METADATA. 47 When you pass a list for a property of an object through the _UPDATE_METADATA_ method and the existing property list is empty for the object or if the list can be a list of objects UPDATE will add for independent types or create and add for dependent types the object to the existing list. For example given an existing job WHJOB with several output tables associated with it an existing detail table WHDETAIL will also be associated with that job when it is passed in the output tables property in the l_meta list for the update of WHJOB. As another example given an existing OLAP table WHOLPTBL with several extended attributes WHEXTATR associated with it a new extended attribute will be created and associated with when it is passed in the extended attributes property in the l_meta list for the update of WHOLPTBL. When you pass a list for a property through the _UPDATE_METADATA_ method and the property can only be a list with a single object UPDATE will replace the existing object with another existing object that is being passed in l_meta. For example given that an OLAP table has an existing library WHLIBRY associated with it a call to the _UPDATE_METADATA_ method for the OLAP table WHOPLTBL will replace the library with another existing library when it is passed in the l_meta list for the update of WHOLPTBL. Examples Example 1 Add New Columns to the Selected Table l_meta makelist object_id is the ID of an existing Data Table object. l_meta insertc l_meta object_id -1 ID Define a column. The COLUMNS property contains a sublist per column. l_cols makelist l_col makelist l_cols insertl l_cols l_col -1 l_meta insertl l_meta l_cols -1 COLUMNS col_id repos_id . WHCOLUMN l_col insertc l_col col_id -1 ID l_col insertc l_col SaleDate -1 NAME l_col insertc l_col Date of Sale -1 DESC l_col insertc l_col N -1 TYPE l_col insertn l_col 8 -1 LENGTH l_col insertc l_col DATE7. -1 FORMAT l_col insertc l_col DATE7. -1 INFORMAT Update any .