Strange behaviour of sql program

["Schmidt, Mihael" <Mihael.Schmidt@xxxxxxxxxxx>]

Hello,

i got a strange behaviour of my program. I got a program which accesses a workfile in qtemp native and with sql. Before i compile the program i'm doing an override so that the compiler will find the file. The override is deleted and a duplicate object of the file is created in qtemp. I now execute the program. Strangly the sql accesses the original file and not the one in qtemp even with a qualified filename in the sql statement.

SQL : create table mylib/testy ( name char(20) );

FILL TABLE: ...

PGM :
     H DatFmt(*ISO) TimFmt(*ISO) DatEdit(*DMY.) Optimize(*None) DecEdit(*JOBRUN)
     H DftActGrp(*No) ActGrp(*Caller)

     Ftestz     UF   E             DISK

     D main            PR                  extpgm('testpgm')
     D main            PI

      /free
       read testz;
       dow (not %eof());
         read testz;
       enddo;

       exec sql delete from qtemp/testz;

       *inlr = *on;
       return;
      /end-free 

OVERRIDE: OVRDBF FILE(TESTZ) TOFILE(MYLIB/TESTY)
PGM CREATE COMMAND : CRTSQLRPGI OBJ(TESTPGM) SRCFILE(QRPGLESRC)
DELETE OVERRIDE: DLTOVR *ALL

CREATE TEMP FILE: CRTDUPOBJ OBJ(TESTY) FROMLIB(MYLIB) OBJTYPE(*FILE) TOLIB(QTEMP) NEWOBJ(TESTZ) DATA(*YES)

CALL MYLIB/TESTPGM

The result of this is that all data from the ORIGINAL file testy (in mylib and not testz in qtemp) is deleted.

Is this a bug? I don't think that is the behaviour one would expect.

We are on V5R4M5 here.

Thanx for any advice

Mihael Schmidt
Anwendungsentwicklung

Dirk Rossmann GmbH
Iserhägener Str.16
30938 Burgwedel
* +49 (05139) 898 - 4353

Handelsregister-Nr. HRB 120546, Amtsgericht Hannover
Ust-Id-Nr. DE 115055186
St.-Nr. 16 / 205 / 65401
Geschäftsführer: Dirk Roßmann, Alice Schardt-Roßmann, Roland Frobel, Klaus Praus