Variable EMITS (VarEmits) in UDFs

Details

Detail name Value
Changelog Number 27
Type New Feature
Status Resolved
Fix Versions EXASOL 6.0.0
Resolution Date 2017-03-16

Background
UDFs currently have the limitation of just allowing static return types (Input types can be dynamic already.) If a script returns different columns depending on the input parameters, a new script for each parameter has to be created although they just differ in the return types.

Improvement
Extend UDF syntax to permit UDFs with variable return values (variable EMITS).

Example usage: Load tables from remote systems with varying columns (see EXASOL-1829)