Re: SQL Question

[Gary Guthrie <GaryGuthrie@xxxxxxxx>]

My guess is that when you compiled the program you accepted the default
value for the Commit parameter (*Chg) and that the file in question is
not within a collection. 

Check the job log and see if you have a messages CPF4328 followed by
SQL7008.

If so, then you either need to set things up properly for commitment
control, or specify Commit(*None) when you compile the program.

Gary Guthrie
NEWS/400 Technical Editor


THarteau@felkerbrothers.com wrote:
> 
> 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?
+---
| 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
+---