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.
Figure 1. The Map-Definition window
begin figure description - This figure is described in the surrounding text. - end figure description

Copyright© 2019 HCL Technologies Limited