Re: SQL Question

["Wayne Achenbaum" <wache@xxxxxxxxxxx>]

Hi there, I am not positive of this but I had a similar problem like that.
All I had to do is compile the sqlrpg or sqlprgle by changing the commit
parm on the command crtsqlrpg(i) to commit(*none)
I think that was all I had to do.
Good luck
Wayne Achenbaum

---- Original Message -----
From: <THarteau@felkerbrothers.com>
To: <RPG400-L@midrange.com>
Sent: Thursday, June 14, 2001 9:08 AM
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
> +---
>


+---
| 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
+---