Unloading Data 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 Figure 91 shows.

Figure 91. The Map-Definition Window