Usage Notes - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-10
dita:mapPath
lsl1527114222348.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following table describes the things to consider when using the SET command.

SET Usage Notes 
Topic Usage Notes
Changing the Data Type The SET command also dynamically changes the data type to that of the assigned value if it had already been defined.

If the expression evaluates to a numeric value, the symbol is assigned an integer value, as in:

.SET FOONUM TO -151 ;

If the expression is a quoted string, the symbol is assigned a string value, as in:

.SET FOOCHAR TO '-151' ;

The minimum and maximum limits for floating point data types are:

4.0E-75 <=abs(float variable)<7.0E75

Declaring Variables Variables need not be declared in advance to be the object of the SET command. If a variable does not already exist, Teradata MultiLoad creates it.

Variables used to the right of TO in the expression must be declared in advance.

Variable Substitution Teradata MultiLoad variable can be substituted wherever substitution is allowed.