Unload data by using functions
If you use a function in a query to unload data, you must associate a name with the result of that function.
In the following example, the returned value of the function TRIM
is assigned the name
field1
.
SELECT TRIM(col1) field1 FROM tab1
After submitting the query, you must attach
field1
to col1
of
the unload file manually, as the following figure shows.