SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
P-28
Print Item
Index Keys
Syskeys (system-defined primary keys)
User-Defined Keys (user-defined primary keys)
Print Item
A print item identifies an item to print in an SQLCI report writer report, optionally
accompanied by instructions for formatting the item. A print item can generally be a
column identifier for a column in the current SELECT list (a column name, column
position number, alias, or detail alias), a literal, an arithmetic expression, or a report
clause (for example, SKIP, SPACE, or TAB).
A print list is a set of one or more print items in a report writer command, separated by
commas:
print-item [ , print-item ] ...
For the complete syntax of a print item, see DETAIL Command on page D-47. See the
specific command in which you intend to specify a print item for any special restrictions
for that command.
PROGID File Attribute
PROGID is a Guardian file attribute that determines the process accessor ID (PAID) of
a process started from the program file. PROGID applies only to program files.
PROGID
sets the PAID of a process started from the file to the Guardian user ID of the file's
owner.
NO PROGID
sets the PAID of a process started from the file to the Guardian user ID of the user
that starts the process.
The default when a program is created is NO PROGID.
Program Invalidation
An SQL-compiled program that is registered in a catalog is either valid or invalid. A
valid program is one that can execute with the current description of the database and
that is marked as valid in the file label of the program file and in the PROGRAMS
catalog table.
[ NO ] PROGID