After you define a user-defined field in a record, run a database row test to test the operation of any PowerExchange or user-defined functions on the field.
Run a database row test on a table in the data map that includes a column based on the user-defined field.
To test a user-defined field in a data map:
In the data map, add a column to a table that uses the user-defined field that you want to test as its base field.
Save the data map.
Run a database row test on the table.
Do not include the DISTINCT keyword in the SQL statement when you run a database row test for a data map that contains user-defined fields. If a query requires the DISTINCT keyword, create another table in the data map that contains the fields that are required for the query.
Review the output in the
Database Row Test Output
window.
For more information about using SQL for nonrelational sources, see the