IDMSRADM › Input Parameter Statements › DELETE Statement

DELETE Statement

Purpose

Deletes one or all tables from an area.

Syntax

   ┌────────────────────────────────────────────────────┐
►►─▼─ DELete ─┬─────────────────────────────────────────┼────────────── . ─────►◄
              ├─ ALL ◄──────────────────────────────────┤
              ├─ TDN tbl-def-no ────────────────────────┤
              └─┬────────────────────┬─ PATh path-name ─┘
                └─ OWNer owner-name ─┘

Parameters

ALL

Deletes all tables from the area specified in the SET AREA statement.

This is the default.

TDN tbl-def-no

Specifies a table to delete with its table definition number.

By default, if you do not specify a table to delete, all tables in the area specified in the SET AREA statement are deleted.

OWNer owner-name

Specifies a table to delete with the name of the table's owner.

The owner can also be specified with the SET OWNER statement.

By default, if you do not specify a table to delete, all tables in the area specified in the SET AREA statement are deleted.

PATh path-name

Specifies a table to delete with the path name of the table.

By default, if you do not specify a table to delete, all tables in the area specified in the SET AREA statement are deleted.

Path-name consists of either the object name alone, if it is unique, or a string consisting of one or more folder names (if CA-ICMS is installed) and an object name separated by a period to uniquely identify the object.

If a folder name or object name contains a space, period, or single quotation mark, enclose it in double quotation marks (" ").

Usage

Deleting Tables by Owner and Path Names

To delete tables by owner and path

To delete tables by owner and path, specify the owner name and the path name instead of the table-definition number in the DELETE statement.

To delete multiple tables for one owner

To delete multiple tables for one owner, set a default owner name on the SET statement. You don't have to re-specify the owner name to delete subsequent tables for the same owner.

You can override the default by specifying an owner and path name in the DELETE statement. You can also change the default by specifying another SET command.

When specifying a path name, include as many folder names (separated by periods) as it takes to uniquely identify the object.

If the owner or path name contains a space, period, or single quote, then the owner or path name must be specified in double quotes.

Deleting post office objects

You can delete a post office object by specifying its table definition number.

Alternatively, to delete a post office object by owner and path, assign "POST OFFICE" to owner-name, followed by the path name for the post office object:

DELETE OWNER "POST OFFICE"
  PATH path-name

Deleting a Post Office

A post office is deleted automatically when all of its objects are deleted.

Examples

Example 1

Deleting table by default owner names

SET OWNER USER1.
DELETE PATH ABC.
SET OWNER USER2..
DELETE PATH DEF.
BYE.

Example 2

Deleting tables by owner and path names

SET OWNER USER1.
DELETE PATH "FOLDERA.ABC"
SET OWNER USER2.
DELETE PATH "TABLE ONE".
DELETE OWNER GSR PATH EMP.
BYE.

Example 3

Specifying commits

SET COMMIT 10.
SET OWNER USER2.
DELETE PATH DEPT.
DELETE TDN 702.
BYE.