NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
P-30
PROGRAMS Table
PROGRAMS Table
The PROGRAMS table is a catalog table that describes object programs that have been
SQL-compiled. The following table describes the contents of the PROGRAMS table.
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
12 PROGRAMFORMATVERSION PFV of program (oldest version of SQL that
can execute program)
SMALLINT
UNSIGNED
13 PROGRAMCATALOGVERSION PCV of program (oldest version catalog that
can register program)
SMALLINT
UNSIGNED
14 FORCE CHAR(1) Y if FORCE specified
N if not
* Indicates primary key