DBCExtension.GLOP_Report Stored Procedure | Teradata Vantage - DBCExtension.GLOP_Report Stored Procedure - Advanced SQL Engine - Teradata Database

Purpose

Use the GLOP_Report procedure to output specific information about a particular GLOP set or all GLOP sets. It does not display the GLOP data. It provides a complete report consisting of as many result sets as needed depending on what is requested.

Definition

REPLACE PROCEDURE DBCExtension.GLOP_Report
   (IN Options CHAR(1),
    IN FindName VARCHAR(257))

where:

Options

What to report. Valid values are as follows. Any other value generates an error.

• 'A', which specifies to report on all sets.

  The user must have sufficient privileges to report on all GLOP sets; if not, it reports on the sets that belong to the user running the report.

• 'D', which specifies to report on a specific named data GLOP.
• 'S', which specifies to report on a specific set.

FindName

the name of the object to report information on for the given options.

For option 'A' this argument is a database name or a database name followed by the set name using dot notation (dbname.setname). A NULL in this field will report on all sets provided user has sufficient privileges.

For option 'S' this argument is the set name when the database is not specified or database name and set name using dot notation.

For option 'D' this argument is the data name when the database is not specified or the database name and data name using dot notation (dbname.dataname).

Authorization

An administrator who is reporting on any desired GLOP must have the SELECT privilege on the DBCExtension.GLOP_Set, DBCExtension.GLOP_Map, and DBCExtension.GLOP_Data tables.

To report on your own set when you do not have the SELECT privilege on the DBCExtension.GLOP_Set, DBCExtension.GLOP_Map, and DBCExtension.GLOP_Data tables, you must be the owner or creator of the GLOP or have the GLOP MEMBER privilege on the GLOP.

Usage Notes

Use this procedure to provide detailed information of specific GLOP sets or all of them.

CALL DBCExtension.GLOP_Report('S', 'sales_division');