Usage Notes|SET| FastExport utility - Usage Notes - FastExport

Teradata® FastExport Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
FastExport
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-03-18
dita:mapPath
jaa1691573250507.ditamap
dita:ditavalPath
gel1618411995444.ditaval
dita:id
rto1478610027076
Product Category
Teradata Tools and Utilities

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

SET Command Usage Notes 
Topic Usage Notes
Declaring Variables Variables need not be declared in advance to be the object of the SET command. If a variable does not already exist, FastExport creates it.

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

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 as follows:

4.0E-75 <=abs(float variable)<7.0E75
Variable Substitution A FastExport variable can be substituted wherever substitution is allowed.

The utility variable can be substituted wherever substitution is allowed.

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 as follows:

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