REMOVE DS Command

Purpose: To remove an Oracle table from ACCENT R, the table must have a corresponding Data Set object in your DBL and you must have been assigned drop permission on that table by the owner of the table on the Oracle Server. If you created the table, then you own the table and have drop permission. Also, you cannot remove an Oracle table until you have specified the name of the database with the USE ORACLE SERVER command.

If the table does not have a Data Set object in the DBL, you cannot remove it until you create an object for it using the CREATE DS command with the ENTRY ONLY option.

You can only remove an Oracle table from the ACCENT R ICL level or from a CM (Command Module). Use Interactive SQL *PLUS if you wish to manipulate tables in an Oracle Server which are not defined as SD and DS objects in a DBL.

Syntax

REMOVE [ENTRY FOR] DS \\table_name\\

ENTRY FOR	removes the Data Set object from the DBL, but does not remove the table from the Oracle database. This is useful if you find that your Schema Definition does not match the Oracle table. You could remove the Data Set object, correct the Schema Definition, and then ATTACH to the table with the CREATE DS command.
table_name	is the name of the Data Set object in the ACCENT R DBL and the name of the Oracle table. More than one table name may be specified in a single REMOVE DS command. Also, table names and Data Set names may be specified in the same REMOVE DS command.

Example

*REMOVE DS DISCOUNTS_ORA

The above command removes (drops) the DISCOUNTS_ORA table from the current working Oracle database (server).