END (stop execution)

END terminates PRL execution.

Syntax

END

Usage

Use END

  • to indicate PRL report termination
  • in the THEN clause of an IF statement to force termination of PRL execution

For example, to get only the first 50 selected records, use END with IF-THEN as follows:

SET Y = Y + 1
IF Y > 51 THEN END

(See the example for IF-and-THEN-do-statement-to-test-conditions.)

  • after DIAGNOSE

Example

SET TITLE = 'TRANSACTIONS THAT ABENDED'
SELECT TYPE 6D RECORDS FROM CMRDETL
USING T6ETRID -
        CMRDATE  -
        CMRTIME  -
        T6EABCD  -
        T6EOPID  -
        T6ETMID  -
        T6ERESP  -
        T6ECPUR
 REPORT
 END

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*