INSERT_SQLVIEW

Inserts a PROC SQL view into a package

Syntax

Example

Syntax

CALL INSERT_SQLVIEW(packageId, libname, memname, desc, nameValue, rc);

Required Arguments

packageID: identifies the package.

Type:Numeric, Input

libname: names the library that contains the PROC SQL view.

Type:Character, Input

memname: names the PROC SQL view.

Type:Character, Input

desc: describes the PROC SQL view.

Type:Character, Input

nameValue

identifies a list of one or more space-separated name/value pairs, each in one of the following forms:

name
name=value
name="value"
name="single value with spaces"
name=(value)
name=("value")
name=(value1, "value 2",… valueN)

Name/value pairs are site-specific; they are used for the purpose of filtering.

Type:Character, Input

rc: receives a return code.

Type:Numeric, Output

Example: Using INSERT_SQLVIEW

The following example inserts the PROC SQL view FINANCE.PAYROLL into the package that is returned in packageId.

libname = 'finance';
memname = 'payroll';
desc = 'Monthly payroll data.';
nameValue='';
CALL INSERT_SQLVIEW(packageId, libname,
   memname, desc, nameValue, rc);