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.