LABEL Command | Basic Teradata Query - LABEL (LB) - Basic Teradata Query

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-06-14
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
Product Category
Teradata Tools and Utilities

Purpose

Identifies the point at which BTEQ resumes processing, as specified in a previous GOTO command.

Syntax



Shorthand Syntax (Interactive Mode Only)
Command Shorthand
LABEL LB

where the following is true:

labelname
The user-defined name of the statement.The labelname value can be composed of any combination of the letters A..Z (upper or lower), the 0..9 numeric digits and underscores. Only the first 30 characters are significant. Special characters '$' and '#' are also accepted but may be subject to misinterpretation for scripts that are to be preprocessed by shell languages.

Usage Notes

The LABEL command identifies the target of a GOTO statement.

The LABEL command cannot be used in an SQL macro.

Example – LABEL

The following command example specifies OCCUPATION as the name of the statement at which BTEQ resumes processing as specified in a previous GOTO command:

.LABEL OCCUPATION