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 tab1After submitting the query, you must attach field1 to col1 of
the unload file manually, as the following figure shows.
Figure 1. The Map-Definition window