EXIT

The EXIT operation allows you to stop the execution of a data pipeline with an empty result set or optionally a number of records with the currently available schema.

If this operation is used within an Inner Pipeline, the EXIT operation only applies to the current page of data when reading from a source system that supports paging. To avoid unintended behavior, consider using EXIT as an After Pipeline.

Aborts the execution of the data pipeline.

EXIT 
  { KEEP <n> }
;

KEEP	If specified, returns the schema of the data pipeline with N records (0: returns the schema only)

Example 1

-- Get data from an RSS Feed
SELECT * FROM HTTP [Rss Feed] (GET /econi.xml) APPLY TX (//item);

EXIT;

-- This section will not execute
APPLY PIPELINE
(
	PRINT 'Here!';
);