RE: SQL Question

["Phil" <sublime78ska@xxxxxxxxx>]

Is the file not journaled but the compiled pgm is expecting the file to be
journaled?  When you do it from strsql, the files don't need to be
journaled.

If you start debug (strdbg pgmname updprod(*yes)) then run the pgm you
should then get something meaningful in the joblog.  Or, place a break point
after the delete sql statement and then view the joblog or the sqlcod value.

It looks like you're deleting all the records in the file.  Why not just do
clrpfm in a cl.  I think then you won't have deleted records remaining in
the file.

Hth,

Phil

-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of THarteau@felkerbrothers.com
Sent: Thursday, June 14, 2001 10:39 AM
To: RPG400-L@midrange.com
Subject: 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
+---


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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
+---