SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
P-31
PROGRAMS Table
the PROGRAMS catalog table. However, the operations listed in the subsections,
Operations That Invalidate a Program on page P-29, and Preventing Program
Invalidation Caused by DDL Operations on page P-29, invalidate specific execution
plans within an unregistered program.
For more information about program invalidation, see the SQL/MP Installation and
Management Guide.
PROGRAMS Table
The PROGRAMS table is a catalog table that describes object programs that have
been SQL-compiled. Table P-2 describes the contents of the PROGRAMS table.
Table P-2. The PROGRAMS Table (page 1 of 2)
Column Name Data Type Description
1 PROGRAMNAME * CHAR(34) Name of file that contains object code
2 GROUPID SMALLINT
UNSIGNED
Group number of file owner's user ID if
Guardian program, 0 if OSS program
3 USERID SMALLINT
UNSIGNED
User number of file owner's user ID if
Guardian program, 0 if OSS program
4 CREATETIME LARGEINT
SIGNED
Julian timestamp from first SQL-compile
5 SECURITYVECTOR CHAR(4) Program's security string if Guardian program,
$$$$ if OSS program
6 RECOMPILETIME LARGEINT
SIGNED
Julian timestamp from last explicit
SQL-compile
7 AUTOCOMPILE CHAR(1) Y if automatic recompilation allowed
N if not
8 VALID CHAR(1) Y if program is valid
N if not
9 PROGID CHAR(1) Y if process accessor ID of running program is
to be that of owner of program file
N if process accessor ID of running program is
to be that of user running program
$ if program in OSS file
10 CLEARONPURGE CHAR(1) Y if all data in file is to be physically deleted
from disk when file is purged
N if data in file is not to be physically deleted
from disk when file is purged
$ if OSS program
11 SECURITYMODE CHAR(1) S Safeguard security
G Guardian security
$ OSS program