Re: SQL Question

If you're really looking to purge every record in your file, a CLRPFM would
be a much smarter move - it's quicker and it'll free up all the deleted
record space also.  The only downside is the need for no objects lock on
the file.

Bill





THarteau@felkerbrothers.com@midrange.com on 06/14/2001 09:08:03 AM

Please respond to RPG400-L@midrange.com

Sent by:  owner-rpg400-l@midrange.com


To:   RPG400-L@midrange.com
cc:
Subject:  SQL Question


Hi,
     I want to purge all records from a file. I found a program written by
another programmer that looks like it should work, but it doesn't.  The
only code is the following:

 C/EXEC SQL
 C+ DELETE FROM ECHW
 C/END-EXEC

This is then repeated for more files.
Why does it work if I interactively type in

DELETE FROM V64BPCSTF/ECHW

but it won't work in the program?

<===================================================>

Terri Harteau

****************

"I'm not sure who he is, but I get the feeling he's got his hand in a lot
of things." - Kermit The Frog speaking about Jim Henson.

****************





+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---



--

NOTICE:  The information contained in this electronic mail transmission is
intended by Convergys Corporation for the use of the named individual or
entity to which it is directed and may contain information that is
privileged or otherwise confidential.  If you have received this electronic
mail transmission in error, please delete it from your system without
copying or forwarding it, and notify the sender of the error by reply email
or by telephone (collect), so that the sender's address records can be
corrected.


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---