BTEQ - RETCANCEL in Teradata

The RETCANCEL command, used in conjunction with the RETLIMIT command, cancels a request when the value specified by the RETLIMIT command is exceeded.

Syntax:
.SET RETCANCEL ON | OFF


The following example shows the RETCANCEL command used in conjunction with several RETLIMIT commands:
.set retcancel
.set retlimit 1000
.set retlimit 100000000000

*** Warning: Number too large
*** Warning: Extra text found after command .
The text ’00’ not processed (ignored) .