delobj – Delete Objects from Database

The delobj command deletes objects from the database.

For more information on using the delobj command to delete specific object types, see the Character-based Querying and Reporting Tools User Guide.

The delobj command has the following format:

delobj dbname|vnode::dbname[/server_class] objectspec | all [-silent]
[-uusername] [-Ggroupid]

• dbname

  Specifies the name of the database and, if required, the vnode and server_class, as described in Standard Flags and Parameters.

• objectspec

  Describes the object or objects to be deleted from the database. Either an objectspec or the word -all can be specified. You can optionally specify the silent -u and -G flags.

  Details on specifying this parameter are described in Object Specification.

  -all

  Specifies that all objects owned by the effective user are to be deleted. You can optionally specify the silent -u and -G flags.

• -silent

  Runs in silent mode, suppressing status messages.

• -uusername

  Specifies the effective user for the session, as described in Standard Flags and Parameters.

• -Ggroupid

  Specifies a group identifier, as described in Standard Flags and Parameters.

  On VMS, enclose the –Ggroupid parameter in double quotes.

Object Specification for delobj Command—Specify Objects to Delete

The object specification names one or more objects to be deleted from the database using the delobj command. You can specify one type of object only.

The objectspec parameter has the following format:

-report|-form|-joindef|-graph|-application|-qbfname {objname} [-wildcard]
[-include filename]

• -report

  Indicates that the object names refer to reports.

• -form

  Indicates that the object names refer to forms.

• -joindef

  Indicates that the object names refer to join definitions.

• -application

  Indicates that the object names refer to applications.

• -qbfname

  Indicates that the object names refer to QBFNames.

• objname

  Specifies one or more object names of the specified type.

  An object name can contain SQL wildcard characters (%, _, [  ]), with the backslash (\) as the escape character. For details, see the pattern matching description in the SQL Reference Guide.

• -wildcard

  Expands wild cards. The default is not to expand wild cards.

• -include filename

  Specifies the name of an ASCII file that contains object names. This parameter is an alternative to listing multiple objname parameters on the command line.

  The file can consist of one or more ASCII lines with the following format characteristics:

  • Each line can be up to 256 bytes (not characters) in length. Longer lines may cause errors.
  • A line can contain a combination of object names, comment, and white space (blanks and tabs).
  • A comment begins with the character # and continues to the end of the line. Each line terminates with an ASCII carriage return (CR), line feed (LF), or form feed (FF) character.

delobj Examples

This command deletes the empreport report from the empdata database:

delobj empdata -report empreport

This command deletes the videoapp application from the video database, specifying user name Adder:

delobj video -uAdder -application videoapp

This command deletes the forms listed in a prepared namefile:

delobj video -form -include namefile

The namefile contains the following:

wa1 wa2 wa3 wa4 wa5 wa6 wa7 wa8 wa9 wa10 wa11 wa12 wa13
wr1 wr2 wr3 wr4 wr5 wr6 wr7 wr8 wr9 wr11 wr12 wr13
wr14 wr15 wr16 #Includes all wr names except wr10.

In the following examples, assume objects: qbfname_1, qbfnameA1, and qbfnameB1.

The following command deletes all three objects using the underscore as a wildcard character:

delobj dbname -qbfname qbfname_1 -wildcard

The previous command without the -wildcard flag deletes the qbfname qbfname_1 only:

delobj dbname -qbfname qbfname_1

The previous command is identical to the following command, which escapes the underscore character, preventing it from being used as a wildcard character, even though the -wildcard flag is specified:

delobj dbname -qbfname qbfname\_1 -wildcard