INSERT_SQLVIEW

Inserts a PROC SQL view into a package.

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

packageID

Numeric, input.
Identifies the package.

libname

Character, input.
Names the library that contains the PROC SQL view.

memname

Character, input.
Names the PROC SQL view.

desc

Character, input.
Describes the PROC SQL view.

nameValue

Character, input.
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.

rc

Numeric, output.
Receives a return code.

Example

This example inserts the PROC SQL view FINANCE.PAYROLL into the package returned in packageId.

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

See Also

• PACKAGE_BEGIN
• PACKAGE_PUBLISH