AS/400 QUICK Record Selection
Daniel Mielke
DMielke@aicfunds.com
Fri, 2 Nov 2001 15:58:05 -0500
Hello All,
I need help in selecting records for display. I want to select specific
records from a primary file based on records in associated reference files.
TEMP t-RAT-NAME char*20
TEMP t-RATLET-DOB zoned*8
FILE RATS occurs 9
select if 0 ne index(RATNAME of RATS,trunc(t-RAT-NAME)) &
and RATLET-DOB of RATLETS eq t-RATLET-DOB
FILE RATLETS reference
access via RAT-NO using RAT-NO of RATS
;There may be no RATLETS for a given RAT
;There is no index for RATNAME so the GET statement will be SEQUENTIAL
QUICK gives an Error stating that it can't find RATLET-DOB, and rightly so,
it hasn't been declared yet. How do I control the selection of a RATS
record based on data in the referenced file RATLETS?
I was thinking of modifying the FIND or POSTFIND procedures, but I'm not
sure how to start.
Help!
> BUY. HOLD. AND PROSPER.
>
> Daniel Mielke
> Senior User Analyst
> AIC Limited
> 1-888-710-4242 (4614)
> dmielke@aicfunds.com
> www.aicfunds.com
>
>