SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

G-1

Generalized Owner

A generalized owner of an SQL object or Guardian file is any user ID that has

ownership privileges for the file.

On the node where the file is located, the generalized owner includes the user ID that

owns the file, the group manager of the group that includes that user ID, and the super

ID. If the owner can purge the file from another node in the network (as specified with

the fourth character of the security string), the generalized owner also includes the

same user ID on other nodes, the group manager on other nodes, and the super ID on

other nodes.

For more information, see Security on page S-11.

GET CATALOG OF SYSTEM Statement

GET CATALOG OF SYSTEM is a DSL statement that returns the name of a local or

remote system catalog.

node

is the name of a node. The default is the local node.

INTO :var

(static SQL programs only) specifies a host variable in which to return the system

catalog name.

Considerations—GET CATALOG OF SYSTEM

In host language programs, GET CATALOG OF SYSTEM returns the fully qualified

system catalog name as 25 characters, left-justified, and padded with blanks. The

variable to receive the name must be compatible with the SQL data type CHAR(25).

For static SQL, specify the variable in the INTO clause of GET CATALOG. For dynamic

SQL, specify the variable in the RETURNING clause of the EXECUTE or specify an

output SQLDA in the RETURNING USING DESCRIPTOR clause of the EXECUTE.

GET CATALOG OF SYSTEM also sets SQLCODE to indicate status and fills in the

SQLCA. GET CATALOG OF SYSTEM has no EXPLAIN output.

GET CATALOG OF SYSTEM [ \node ] [ INTO :var ]