NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
G-6
GOAWAY Command
•
The following C example uses dynamic SQL to retrieve the HOSV of the program
MYPROG and store it in an output SQLDA:
string2 = "GET HOST OBJECT VERSION OF PROGRAM MYPROG ";
EXEC SQL PREPARE s2 FROM :string2;
EXEC SQL EXECUTE s2 RETURNING USING DESCRIPTOR :mysqlda;
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 the following 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 ServerWare 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
•
The following example deletes the table mytable:
42> GOAWAY mytable
GOAWAY [ /IN cmdfile/ ] [ filename[:S] ] ;