Home > IT Answers > AS/400 > Clear a logical file
RamvishakRamesh
1,940 pts.
 Clear a logical file
Logical File
Is there any command to clear a Logical File?

Software/Hardware used:
ASKED: May 30, 2012  5:30 AM
UPDATED: May 31, 2012  9:39 PM
RELATED QUESTIONS
 
  Help
 Approved Answer - Chosen by RamvishakRamesh (Question Asker)

Logical File doesn't contain data and it provides only window to view the data from one or more Physical Files. So, I hope there is no matter to think of clearing Logical file.
Folks, correct me I am wrong.!!

ANSWERED:  May 30, 2012  9:39 AM (GMT)  by RamvishakRamesh
 
Other Answers:

Logical File doesn’t contain data and it provides only window to view the data from one or more Physical Files. So, I hope there is no matter to think of clearing Logical file.
Folks, correct me I am wrong.!!

Last Wiki Answer Submitted:  May 30, 2012  9:39 am  by  sudheer794   315 pts.
Latest Answer Wiki Contributors:  sudheer794   315 pts.
To see other answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You can use and SQL DELETE statement on the logical file

CharlieBrowne
 32,855 pts.
 

Charlie Brown is right but it will delete the data out of the physical file.

gfprogrammer
 210 pts.
 

DELETE statement works only on Non-join Logical Files.. as Gfprogrammer said it deletes the record from the physical file… correct me if am wrong!

sudheer794
 315 pts.
 

DELETE statement works only on Non-join Logical Files.

In recent releases, INSTEAD OF triggers have allowed JOIN VIEWs to be deleteable. Whether or not they can work for DDS JOIN LFs may depend how the DDS is written.

Tom

TomLiotta
 108,055 pts.