Re: SQL Question

[Gary Guthrie <GaryGuthrie@xxxxxxxx>]

I can think of a couple of possibilities...

1) no need to call CL, bind CL, or call a command processor such as
QCmdExc

2) More importantly, ClrPFm has ramifications when journalling is in
effect. The journal simply contains a single entry noting the file has
been cleared. This impacts recovery. The SQL on the other hand, adds a
journal entry for each deletion. This has a positive impact on
auditability and recovery.

Gary Guthrie
NEWS/400 Technical Editor


alan shore wrote:
> 
> Is there any reason why you dont use CLRPFM istead?
> 
> THarteau@felkerbrothers.com> wrote
> Hi,
>      I want to purge all records from a file...
> 
>  C/EXEC SQL
>  C+ DELETE FROM ECHW
>  C/END-EXEC
> 
> Why does it work if I interactively type in
> 
> DELETE FROM V64BPCSTF/ECHW
> 
> but it won't work in the program?
+---
| 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
+---