I have found that if you don't fully qualify almost every thing in
     Quiz you tend to have problems.  Also it works best if you start every
     quiz pass with a "CAN CLE" and "SET DEF". Not clearing out previous
     passes and not fully qualifing fields have given me several hours
     (days) of greif.


     CAN CLE
     SET DEF
     SET REPORT LIMIT 100  ; should this be 99999999
     ACCESS *ARCBOARD LINK (key_field) TO (key_field) of STUD-CRS-DETL-H &
                      LINK (key_field) TO (key_field) of STUD-INFO-DETL

     SELECT IF COMPONENT     OF (file-name) = "2"  AND &
               GRADE         OF (file-name) >="E5" AND &
               GRADE         OF (file-name) <="E8" AND &
               COURSE[3:4]   OF (file-name) = "00" AND &
               LASTTRAN[1:1] OF (file-name) = "Z"
     SORT ON SSN
     REPORT SSN COURSE OF (file-name) LASTTRAN OF (file-name)

     Extra note:  If you use a SELECT (file-name) IF ...
        on your select statement this will stop quiz from building the full
        record complex before discarding the record, this will help it run
        faster.

                                 _\\///_
                                (' o-o ')
     _________________________ooOo_( )_oOoo_________________________
     Abraham Zwygart
     Senior Programmer Analysts     Email: [log in to unmask]
     7933 N. E. 21st Avenue         Phone: (503) 972-1404 x 1232
     Portland, OR 97211             Fax:   (503) 972-1408

     The thoughts, comments, and opinions expressed herein are mine
     and do not reflect those of my employer(s), or anyone else.
     ________________________________Oooo___________________________
                              oooO  (    )
                             (    )  )  /
                              \  (   (_/
                               \_)


     ------------------------------------
     Our system makes use of two datasets, one for records a year old and
     older, another for newer information.

     I'm trying to do a query, incorporating information from both sets.

     In the first step, I'm writing data from the older set to a subfile,
     and in the second, I'm using, or trying to use that subfile, when I
     access our more recent data.  Unfortunately, I'm having no luck in
     several different approaches, so I'm asking for any help or ideas.

     This program creates the subfile, and works perfectly:

     > SET REPORT LIMIT 1000000
     > ACCESS ARC-DETL
     > SELECT IF ARC-COMPONENT="2" AND ARC-GRADE>="E5" AND ARC-GRADE<="E8"
     & > AND ARC-COURSE[3:4]="00" AND ARC-LASTTRAN[1:1]="Z"
     > SORT ON ARC-SSN
     > SET SUBFILE NAME ARCBOARD INDEX ARC-SSN KEEP
     > REPORT SUMMARY ARC-GRADE ARC-SSN ARC-COURSE ARC-LASTTRAN


     This is the start of the second program, which is not working at all.
     I've tried several different permutations of the ACCESS line to no
     avail:

     1     SET REPORT LIMIT 100
     2     ACCESS *ARCBOARD LINK TO STUD-CRS-DETL-H AND STUD-INFO-DETL
     3     SELECT IF COMPONENT="2" AND GRADE>="E5" AND GRADE<="E8" AND & 4
        COURSE[3:4]="00" AND LASTTRAN[1:1]="Z"
     5     SORT ON SSN
     6     REPORT SSN COURSE LASTTRAN


     Any help appreciated in advance.

     C. Freas