GOTO - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-02-20
dita:mapPath
kil1527114222313.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
psp1479308573013
Product Category
Teradata Tools and Utilities

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