DELETE STATEMENT:

The format of the delete statement is as shown below:

DELETE   file-name RECORD   [  ;   INVALID   KEY  imperative-statement  ]

Whenever the ACCESS MODE IS SEQUENTIAL the execution of the DELETE statement should be preceded by the execution of a READ statement on the file and the INVALID KEY phrase must not be specified.

 

 

Posted Date: 10/17/2012 8:16:36 AM | Location : United States

Ask an Expert

Related Discussions:- Delete statement, Assignment Help, Ask Question on Delete statement, Get Answer, Expert's Help, Delete statement Discussions

Write discussion on Delete statement
Your posts are moderated

Write your message here..

Related Questions

Program using occurs clause, PROGRAM USING OCCURS CLAUSE: We have to w... PROGRAM USING OCCURS CLAUSE: We have to write a simple program to demonstrate Occurs Clause. Get the employee details for 3 persons and compute the total salary. identifica

DBMS, Comparing features of oracle rdbms with Mysql Comparing features of oracle rdbms with Mysql

Rewrite statement - indexed files, REWRITE STATEMENT: As in the situat... REWRITE STATEMENT: As in the situation of a relative file, the REWRITE statement needs that the file should be opened in the I-O mode, and if the SEQENTIAL access mode is spec

Reserve clause and organization/access clause, RESERVE clause: This cl... RESERVE clause: This clause indicates the number of buffers to be used for the file. Integer-1 specifies this number. ORGANIZATION/ACCESS clause: These two clause

Nested if statement, NESTED IF STATEMENT:   The then and else stateme... NESTED IF STATEMENT:   The then and else statement of an IF statement can hold other IF statements. The involved IF statements in their turn may also hold other IF statements

Comparison of numeric operands - relational condition , Comparison of Numer... Comparison of Numeric Operands: We are well-known with the kind of the relational condition where both the operands are numeric. The comparison in this situation is algebraic

Example of file-control, Example of File-control: The assign clause as... Example of File-control: The assign clause assigns a specific physical peripheral device name to a file. The physical peripheral device are machine-dependent. We use the devic

Cobol programming, simplify smple interest simplify smple interest

Relational condition - cobol programming, RELATIONAL CONDITION:   We ... RELATIONAL CONDITION:   We know that a relational condition specifies a comparison between two operands and has the form.     Operand-1    relational-operator   operand-2

Rounded option, ROUNDED OPTION: Let us consider the DATA DIVISION entr... ROUNDED OPTION: Let us consider the DATA DIVISION entries which are as shown below: Now, subsequent to the execution of the statement ADD A B GIVING C, the C will hold