NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-7
Examples—Search Conditions
For example, the following predicate evaluates to null because the subquery returns
no value (there is no part number with more than 1500 units in stock):
PARTNUM = (SELECT PARTNUM
FROM ODETAIL
WHERE QTY_ORDERED > 1500)
Examples—Search Conditions
•
The following example searches for values in rows where the quantity is less than 9,
the delivery date is prior to November 2, 1991, and the order number in the
ORDERS table equals the order number in the ODETAIL table:
QTY_ORDERED < 9 AND DELIV_DATE <= 911101
AND ORDERS.ORDERNUM = ODETAIL.ORDERNUM
•
The following example searches for values where supplier number in the
SUPPLIER table equals supplier number in the PARTSUPP table, and part number
is less than 3000 or equal to 7102:
SUPPLIER.SUPPNUM = PARTSUPP.SUPPNUM
AND (PARTNUM < 3000 OR PARTNUM = 7102)
SECURE Command
SECURE is an SQLCI utility that changes security, ownership, and some file attributes
for tables, views, collations, SQL programs in Guardian files, and Enscribe files.
SECURE does not change the security or ownership of catalogs, catalog tables, or SQL
programs in OSS files.
qualified-fileset-list
is a qualified fileset list that specifies the SQL objects, SQL programs in Guardian
files, and Enscribe files for which to change security or ownership. See Qualified
Fileset List on page Q-1 for details.
SECURE qualified-fileset-list [ [,] option ] ... ;
option is:
{ "rwep" }
{ ALLOWERRORS [ ON | OFF | num ] }
{ CLEARONPURGE [ ON | OFF ] }
{ OWNER { group-name.user-name } }
{ { group-number, user-number } }
{ PROGID [ ON | OFF ] }
{ [ NO ] LISTALL }