Hi Navneth,
CLEAR
Sets a variable to its initial value.
Syntax
CLEAR <f>.
The variable <f>, which can have any data type, is set to an initial value appropriate to its type.
DELETE for Files
Deletes files on the application server
Syntax
DELETE DATASET <dsn>.
Deletes the file <dsn> from the file system of the application server.
DELETE for Database Table Entries
Deletes entries from database tables.
Syntax
DELETE FROM <dbtab> WHERE <cond>.
All of the lines in the database table that satisfy the conditions in the WHERE clause are deleted.
Syntax
DELETE <dbtab> FROM <wa>.
DELETE <dbtab> FROM TABLE <itab>.
This deletes the line that has the same primary key as the work area <wa>, or deletes all the lines in the database that have the same primary key as a line in the internal table <itab>. The work area <wa> or the lines of the internal table <itab> must have at least the same length as the work area of the database table.
DELETE for Cluster Databases
Deletes data clusters from cluster database tables.
Syntax
DELETE FROM DATABASE <dbtab>(<ar>) ID <key>.
Deletes the entire cluster in area <ar> with the name <key> from the cluster database table <dbtab>.
DELETE for the Cross-Transaction Application Buffer
Deletes data clusters from the cross-transaction application buffer.
Syntax
DELETE FROM SHARED BUFFER <dbtab>(<ar>) ID <key>.
Deletes the data cluster for the area <ar> with the name <key> stored in the cross-transaction application buffer for the table <dbtab>.
DELETE for Lines from an Internal Table
Deletes lines from internal tables of any type.
Syntax
DELETE TABLE <itab> FROM <wa>.
DELETE TABLE <itab> WITH TABLE KEY <k1> = <f 1>... <k n> = <f n>.
Deletes using the table key. All lines with the same key are deleted. The key values are taken either from a compatible work area <wa> or specified explicitly.
Syntax
DELETE <itab> WHERE <cond>.
Deletes using conditions. Deletes all table entries that satisfy the logical expression <cond>. The logical condition can consist of more than one comparison. In each comparison, the first operand must be a component of the line structure.
Syntax
DELETE ADJACENT DUPLICATE ENTRIES FROM <itab> [COMPARING... ].
Deletes adjacent duplicate entries, either by comparing the key fields or the comparison fields specified explicitly in the COMPARING addition.
DELETE for Lines from Index Tables
Deletes entries from index tables.
Syntax
DELETE <itab> [INDEX <idx>].
If you use the INDEX addition, the line with index <idx> is deleted from the table <itab>. Without the INDEX addition, you can only use the above statement within a LOOP. In this case, you delete the current line.
Syntax
DELETE <itab> [FROM <n1>] [TO <n 2>] [WHERE <cond>].
The system deletes all of the lines of <itab> whose index lies between <n 1 > and <n 2 > and who meet the conditions specified in the WHERE clause. If you do not specify a FROM addition, the system deletes lines