Home > IT Answers > Database > delete from flat file
0 pts.
 delete from flat file
Embedded SQL, RPG, RPG Flat Files, Spool files
HI My flat file contains data copied from a spool file.The records in this file is used as reference to delete links from dir.Can i delete those records in the flat file for which there is no link in the dir(that is the link or text file object has been deleted from the dir) ?I tried using embedded SQL but the logic seems to be a problem.

Software/Hardware used:
ASKED: January 22, 2009  1:39 PM
UPDATED: February 2, 2009  5:15 PM
RELATED QUESTIONS
Answer Wiki:
1. Yes, you should be able to delete the records using SQL 2. Why bother - just get a new list of the directory and replace the file.
Last Wiki Answer Submitted:  January 22, 2009  2:39 pm  by  philpl1jb   44,180 pts.
All Answer Wiki Contributors:  philpl1jb   44,180 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

Hi,

Try running the command from the interactive SQL first (STRSQL) – if this works, use the same command in your RPG.

Regards,

Martin Gilbert.

Gilly400
 23,625 pts.