QTP in AXIANT 4GL

[Syed Shahul Hameed Mustaffa]

Dear Gurus,

Quick Intro: I'm migrating PH/MPEIX application to AXIANT-4GL/WINDOWS.

The following QTP statement,

access TRANSFER-D  in cwdb                        &
         link to COW-D   in cwdb                 &
         link to COW-LOC-D    in cwdb            &
         link UNIT-NO of COW-LOC-D to UNIT-M  in cwdb

select TRANSFER-D if                              &
         TRNFR-DATE ge TRAN-DT-FR      and       &
         TRNFR-DATE le TRAN-DT-TO      and       &
         TRNFR-TYPE eq "U"             and       &
         TRNFR-SUB-TYPE eq "U"         and       &
         TRNFR-NEW-NO ge UNIT-NO-FR    and       &
         TRNFR-NEW-NO le UNIT-NO-TO

 is retrieving all the records of all the tables linked first and
then select specific records out of the entire set. I am have a
relational db (SQL SERVER). Is there any way stop this sequential
access of all records and only select those records I need.

Thanks & Best Regards,
SYED