Physical file that is seen as a Logical file

["Rich Dotson" <rich_dotson@xxxxxxxxxxx>]

I have a SQLRPG program that has the following code in it:

* Build the Totals summary file.
C/EXEC SQL INSERT INTO TEB12M3
C+   SELECT EHECLK, EHETYP, WENDYY, WENDMD, SUM(MONHRS), SUM(TUEHRS),
C+   SUM(WEDHRS), SUM(THRHRS), SUM(FRIHRS), SUM(SATHRS), SUM(SUNHRS)
C+     FROM TEB31M
C+     GROUP BY EHETYP, EHECLK, WENDYY, WENDMD
C/END-EXEC

When this statement is executed the following message appears in the job 
log:

   12/16/99   09:28:59   QSQINS         QSYS        0DA4     QSQINS       
QSYS
essage . . . . :   View or logical file TEB12M3 in WWWPRDDAT read-only.
Cause . . . . . :   Update, delete, or insert is not allowed. TEB12M3 in 
library WWWPRDDAT can be used only for read operations. A view or logical 
file can be used only for read operations if one or more of the following 
conditions are true:  <Lines Deleted>

Recovery  . . . :   Change the statement to insert, delete, or update data 
into the base table of view TEB12M3.  All columns of the table that do not 
allow null values or default values must be assigned a value when inserting 
a row into a table or view. Try the request again.

The file TEB12M3 is a physical file and has not been changed for over 2 
years.  I can type the SQL statement into the interactive SQL session and it 
executes without any problems.

Any suggestions?

Rich Dotson
RT3 Consulting Services, Inc.
P.O. Box 126
Lorain, OH  44052-0126

Phone: 1-216-556-1710
eMail: rich_dotson@hotmail.com  or
       rich_dotson@centurytel.net

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---