Help >

CalcObject Statement: NotEmit

Version 7.11

CalcObject Statement: NotEmit

    Syntax: NOTEMIT
    Placement: In RETURN Section only. Multiple NOTEMIT Statement 
       are allowed. NOTEMIT is meaningful only in a POSTCALCOBJECT 
       of ddlRelateEx().
    Description: NOTEMIT [i.e., not emit] causes the ddlRelateEx()
       API function to which it is connected not to emit the current 
       frame to the result set.
  
       The default behavior of ddlRelateEx() is to emit all qualifying
       frames to the result set.
 
       NOTEMIT can be used to create a simpler and more efficient
       translation of certain SQL CROSS JOINs; for example:
          SELECT * from TEST1 CROSS TEST2 HAVING TEST1.DATA < TEST2.DATA
       Translates to:
          CREATECALCOBJECT CrossCO A NULL "RETURN // -
             IF NOT (TEST1.DATA < TEST2.DATA)     // -
                NOTEMIT                           //
 
       NOTEMIT can also be used with INNER JOINs; but is not
       defined for OUTER JOINs.

Back to top