Changes and Enhancements

This section describes changes to the SAS/Warehouse Administrator metadata API after Release 2.0.

• You can add and update the PATH property for the WHEFILE type.

• You can now use the metadata API to add, update, and delete process objects. For example, you can write a metadata API program that creates a data store and also creates all of the processes that are required to extract, transform, and load information into that data store. The following metadata types have been updated to support this feature:

  • WHCOLUMN

    • WHCOLDTL

    • WHCOLDAT

    • WHCOLODD

    • WHCOLOLP

    • WHCOLTIM

  • WHCTRNFM

  • WHEFILE

  • WHEXTATR

  • WHINDEX

  • WHOLAP

    • WOLPDIM

    • 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

      • 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.

• 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 write a SAS/Warehouse Administrator add-in that reads the column metadata that is associated with a WHERE clause or a row selector and uses this metadata to generate the appropriate code.

• You can now update the EXTENDED ATTRIBUTES property and other properties in the WHCOLTIM type. For example, you can use an add-in tool to add data mining attributes to a _LOADTM column, export the metadata for the table to Enterprise Miner and analyze the _LOADTM column in Enterprise Miner.

• The usage notes for the _UPDATE_METDATA_ method have been expanded. For details, see Using _UPDATE_METADATA_.

Copyright © 2012 by SAS Institute Inc., Cary, NC, USA. All rights reserved.