SAS Institute. The Power to Know

SAS(R) 9.2 Publishing Framework: Developer's Guide

Previous Page | Next Page

Publishing Packages

RETRIEVE_MDDB



Retrieves an MDDB entry from a package
Syntax
Arguments
Details

Syntax

CALL RETRIEVE_MDDB(entryId, libname, memname, rc);

Arguments

entryId

identifies the MDDB entry.

Type: Numeric
Direction: Input
libname

specifies the SAS library that will contain the retrieved MDDB.

Type: Character
Direction: Input
memname

specifies the name of the retrieved MDDB.

Type: Character
Direction: Input
rc

receives a return code.

Type: Numeric
Direction: Output

Details

An MDDB is a multidimensional database (not a data set) offered by SAS. An MDDB is a specialized storage facility that can be created by tools such as multidimensional data viewers, which populate the MDDB with data that is retrieved from sources such as a data warehouse. The matrix format of MDDBs allows the viewer to access data quickly and easily.

If the memname parameter is blank, then the RETRIEVE_MDDB CALL routine creates the MDDB using the original member name as it was defined at publish time.

The following example retrieves an MDDB entry WORK.OUTDATA from the package:

lib = 'work';
mem = 'outdata';
CALL RETRIEVE_MDDB(entryId, lib, mem, rc);

Previous Page | Next Page | Top of Page