Coding for Efficiency › When to Use SELECT and When to Use Type 7 Logic

When to Use SELECT and When to Use Type 7 Logic

Selection criteria can be applied to the entire run with the SELECT or BYPASS parameter or stated in the procedure logic for each report:

SELECT PRODUCT EQ 'CA-CULPRIT'
            vs.
017    PRODUCT EQ 'CA-CULPRIT'
027    PRODUCT EQ 'CA-CULPRIT'
037    PRODUCT EQ 'CA-CULPRIT'

Although it is quicker to write, the SELECT parameter uses more processing overhead than type 7 logic. SELECT only becomes efficient when six or more reports are batched together. Type 7 logic is more efficient than SELECT for a smaller number of reports.