Re: Physical File with 12 Members

[Booth Martin <booth@xxxxxxxxxxxx>]

Along these lines, a single new "Annual" file might make sense, with all 
the needed fields rolled up into a 12-element array with a key of Year & 
Account, with a logical of Account & Year.  This becomes easily 
maintained, and allows power users to write a lot of queries they'd find 
desirable.

This allows annual comparisons, rolling quarters, seasonal analysis, and 
trending analysis and simple drill downs. 

Disk memory is relatively cheap today; its an answer that might make you 
a hero in some quarters.  :)




Wayne McAlpine wrote:
> Assuming that you are trying to group quarterly data together, you could 
> use the OPNQRYF command to select from all members by months 1 to 3, 4 
> to 6, etc.  	
>
> Another thought, depending on the number of records involved, is to 
> simply copy the desired members into a single physical file in QTEMP.
>
> Srinivas Boggula wrote:
>   
> > Hi every one,
> >
> >
> >
> > I have PF file and I have 12 members in it
> >
> > My requirement is I have to retrieve records of first 3 members at a
> >
> > time. And then next 3 members records at a time and so on
> >
> >
> >
> >
> >
> > Please can any one give me solutions for this
> >
> >
> >
> > Regards,
> >
> > Srinivas
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ----------------------------------------------------------------DISCLAIMER---------------------------------------------------------
> >
> > Information transmitted by this EMAIL is proprietary to iGATE Group of Companies and is intended for use only by the individual 
> >
> > or entity to whom it is addressed and may contain information that is privileged, confidential, or exempt from disclosure under 
> >
> > applicable law. If you are not the intended recipient of this EMAIL immediately notify the sender at iGATE or mailadmin@xxxxxxxxx 
> >
> > and delete this EMAIL including any attachments
> >
> >
> >
> >