RE: SQL Question

Hi,
     I did try to qualify it with the library name, and it made no
difference. I don't get any error message, it just doesn't delete any
records.

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

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.

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






                                                                                
                
                    "Smith, Mike"                                               
                
                    <Mike_Smith@RGCReso        To:     
"'RPG400-L@midrange.com'"                
                    urces.com>                 <RPG400-L@midrange.com>          
                
                    Sent by:                   cc:                              
                
                    owner-rpg400-l@midr        Subject:     RE: SQL Question    
                
                    ange.com                                                    
                
                                                                                
                
                                                                                
                
                    06/14/2001 08:40 AM                                         
                
                    Please respond to                                           
                
                    RPG400-L                                                    
                
                                                                                
                
                                                                                
                



the only thing i can think of based on your post is that the library is not
in the library list
when you are running it from the program.  Maybe you want to qualify it in
the program, or make sure the library is in your lib list.

btw, what is the error your getting?

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




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