The following table describes the things to consider when using the SET command.
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. |