SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

G-6

GOAWAY Command

GOAWAY is a TACL utility program that allows a user with super ID authority to delete

Guardian SQL files or shadow labels that cannot be removed with other commands or

utilities.

You execute GOAWAY from TACL with this command:

/IN cmdfile/

specifies an EDIT file that lists SQL objects, programs, or shadow labels to delete.

List one item per line, using syntax described for the filename [:S] option.

filename[:S]

is the name (or equivalent DEFINE) of an SQL object or program to delete, or the

name of a shadow label to delete.

The optional :S suffix specifies a shadow label.

If SMF is installed on your node, filename [:S] must not specify an object,

program, or shadow label on a $*.ZYS*. subvolume.

Considerations—GOAWAY



The GOAWAY utility deletes files or file labels but does not delete their

corresponding catalog entries.



If you enter GOAWAY without options, GOAWAY prints instructions and prompts

for filename [:S] entries.



GOAWAY must be licensed and can be used only by the super ID.



Do not use the GOAWAY utility as a substitute for DROP, PURGE, or CLEANUP

operations. Misuse of the GOAWAY utility can corrupt files.

Examples—GOAWAY



This example deletes the table mytable:

42> GOAWAY mytable



This example deletes the shadow label indexb:

43> GOAWAY indexb:S

GOAWAY [ /IN cmdfile/ ] [ filename[:S] ] ;