SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-38
DELETE DEFINE Command
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

These two SQLCI commands delete the DEFINE =CAT and delete the
=EMPLOYEE, =PARTLOC, and =PARTSUPP DEFINEs:
DELETE DEFINE =CAT;
DELETE DEFINE (=EMPLOYEE, =PARTLOC, =PARTSUPP);

This 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 =*;
{ define }
DELETE DEFINE { (define [ , define ] ... ) } ;
{ ** }
{ =* }