SAS Institute. The Power to Know

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

Previous Page | Next Page

Publishing Packages

RETRIEVE_SQLVIEW



Retrieves a PROC SQL view from a package
Syntax
Arguments
Details

Syntax

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

Arguments

entryId

identifies the PROC SQL view entry.

Type: Numeric
Direction: Input
libname

specifies the SAS library that will contain the retrieved PROC SQL view.

Type: Character
Direction: Input
memname

specifies the member name of the PROC SQL view.

Type: Character
Direction: Input
rc

receives a return code.

Type: Numeric
Direction: Output

Details

If the memname parameter is blank, then the RETRIEVE_SQLVIEW CALL routine creates the PROC SQL view by using the original member name as it was defined at publish time.

The following example retrieves the PROC SQL view WORK.OUTDATA from the package.

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

Previous Page | Next Page | Top of Page