Re: series of overrides,just clarify

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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