GOTO - Basic Teradata Query - 16.20

Basic Teradata Query Reference

prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

Purpose

Skips over all intervening BTEQ commands and SQL statements until a specified label is encountered, then resumes processing as usual.

Syntax



where the following is true:

labelname
The user-defined name of the statement to which control transfers, as specified by a subsequent LABEL command.

For more information, see LABEL.

Usage Notes

The GOTO command only transfers control forward; it cannot transfer control to a statement that occurs before the GOTO command. If a LABEL command statement is not provided which matches the labelname, BTEQ terminates the script.

The GOTO command is frequently used with the IF...THEN... command.

Example – GOTO

This example uses GOTO commands to transfer control forward to the LABEL statements SECTIONA or SECTIONB:

database workforce;
select empno
,hours from charges
where  proj_id = 'oe1-0001'
order by empno;
.IF activitycount = 0 then .GOTO SECTIONA
.IF activitycount >= 1 then .GOTO SECTIONB
.label SECTIONA
.REMARK 'Zero Hours on Account'
.GOTO SECTIONC
.label SECTIONB
.REMARK 'Total Hours on Account'
.label SECTIONC
.logoff      
.exit