Request 6 - Evaluation and Advisory Services

PBI #113973

In this instance, we simply extract 08 years of CAWIS AAIR data using a variation of the query shown earlier in this article under “Recommendations” and email to the requestor.

The revised code is available in the attachment ACAP.TXT

In this instance, 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) || '%') ;