Define Subqueries
With help of the following items you can define the behavior, in case the query returned null.
- Work with NULL value : UPLoader will not check the query result.
- Cancel upload: If query returns null, the upload stops immediately.
- DML operation: If query returns null, UPLoader executes the statement from the second textfield. Within this statement you also can reference the source file and parameters with the placeholders <<FileValX>> and <<ParamX>>. In relationship to the example above the statement may look like:
INSERT INTO providers (prv_id, name) values (prv_sequence.NEXTVAL, '<<FileVal1>>')
After execution of the statement UPLoader will repaet the query. If the result is null again, the upload stops.
