Subquerys

Subquerys enables you to define a upload configuration TODO

How to define subquerys

To insert values that depend on data from the source file, use this query option.
On the dialog are two textfields. The first one is for entering the query. Within this query you can reference the source file and the parameters. Use the placeholders <<FileValX>> and <<ParamX>>. The placeholders are case sensitive, where X is the file cloumn or parameter index respectively.

Exemple:

Database	Source file
	provider name mat. name mat. desc mueller x1 xyz1 meier x2 xyz2 schulz x3 xyz3
Query
SELECT prv_id FROM providers WHERE name = '<<FileVal1>>'

With help of the lower section 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.