Re: series of overrides,just clarify

What is the value of the variable &TRNFILE. You can't use that name in your RPG. Normally your RPG would have to have been compiled over an existing file, whose name you know.

This dependence on *LAST member concerns me - I don't think you can rely on the order - you are better off generating a unique name, storing it in a data area, e.g., and using that everywhere. Or go to a single member with a key field (generated unique ID).

But maybe you have no choice in the matter.

I highly recommend that you read the relevant manuals.
-- "File Management" <http://publib.boulder.ibm.com/iseries/v5r1/ic2924/info/dm/rbal3mst.pdf> has all you'd want to about overrides and copying files,as well as some extra information about OPNQRYF.
-- "Database Programming" <http://publib.boulder.ibm.com/iseries/v5r1/ic2924/info/dbp/rbafomst.pdf> has details on using OPNQRYF, and other things.

HTH

Vern

At 11:42 AM 1/13/03 +0530, you wrote:

hAI ALL,
IAM USING the following  OVERRIDES IN MY CL PROGRAM....
pgm
dcl
dcl
/* override the input file  */
             OVRDBF     FILE(&TRNFILE) TOFILE(NFHPGMR/&TRNFILE) +
                          MBR(*LAST)
/* override the Procdate file  */
             OVRDBF     FILE(DASYSM001) TOFILE(NFHPGMR/DASYSM001) +
                          MBR(*LAST)

SOME CODE IN between


  /* OVERRIDE THE HEADER PURGE FILE */
              OVRDBF     FILE(DAHDRT001) TOFILE(NFHPGMR/DAHDRT001)
                           MBR(*LAST) SHARE(*YES)
              OPNQRYF    FILE((NFHPGMR/DAHDRT001 *LAST)) +
                           KEYFLD((DAHDRFCD *ASCEND) (DAHDRGRF +
                           *ASCEND) (DAHDRHFL *ASCEND))
              CALL       PGM(NFHPGMR/DAD0070) PARM(&RTCODE)
              CLOF       OPNID(DAHDRT001)
              DLTOVR     FILE(*ALL)

endpgm

will one override nullify other override ,can u just suggest me whether what
i ve written for requirment if right or nt? Iam going to use &trnfile and
dasysm001 in my rpg DAD0070 along with DAHDRT001...
will this logic of overriding this many files is right
?