NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-37
DELETE DEFINE Command
compiled program. The DEFINE for =SCAT must be in effect when you issue the
SQLCOMP command.
SQLCOMP /IN object-file, OUT list-file>/ CATALOG =SCAT
DELETE DEFINE Command
DELETE DEFINE is an SQLCI command that deletes DEFINEs. (DELETE DEFINE is
similar to the TACL command DELETE DEFINE and the OSS shell command
del_define.)
define
is the name of a DEFINE to delete.
** or =*
specifies that all DEFINEs are to be deleted.
Examples—DELETE DEFINE
•
The following two SQLCI commands delete the DEFINE =CAT and delete the
=EMPLOYEE, =PARTLOC, and =PARTSUPP DEFINEs:
DELETE DEFINE =CAT;
DELETE DEFINE (=EMPLOYEE, =PARTLOC, =PARTSUPP);
•
The following SQLCI command deletes all DEFINEs except =_DEFAULTS
specified within the SQLCI session. After the command executes, DEFINEs
inherited from the TACL or the OSS shell are no longer in effect for the SQLCI
session, although inherited DEFINEs remain in effect for the TACL or OSS shell.
DELETE DEFINE =*;
DELETE Statement
DELETE is a DML statement that deletes rows from a table or protection view.
{ define }
DELETE DEFINE { (define [ , define ] ... ) } ;
{ ** }
{ =* }