delete from flat file

pts.
Tags:
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Gilly400
    Hi, Try running the command from the interactive SQL first (STRSQL) - if this works, use the same command in your RPG. Regards, Martin Gilbert.
    23,730 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: