Request 6 - Evaluation and Advisory Services
- kurt.martin
Owned by kurt.martin
In this instance, we simply extract 8 years of CAWIS AAIR data using a variation of the query shown earlier in this article under “Recommendations” and email it to the requestor.
In this instance, the requestor is asking for flight hours from 2014 onward, by specific airport/airstrip
ACAP eligible airports 2013-2020 12JUL2022.xls
The revised code is available in the attachment ACAP.TXT
Its necessary to create a table containing a list of desired airstrips using the Z980 table
Data sample :
then we add the following code to the end of our flight hours query :
AND EXISTS (SELECT 1 FROM Z980_TERM_CONVERSION Z
WHERE Z.TERM_TYPE_CD = 'AIRPORT'
AND Z.FROM_TXT LIKE '%' || TRIM(Y02.AIRPORT_TXT) || '%') ;