Setting dynamic AE environment variables

AE environment variables can be set at query run time, including variables that affect the behavior of the AE runtime system.

Application-specific variables can also be set. They are set using an extra string in the last argument, usually a constant, to table or scalar SQL Functions. This feature is not supported for aggregates. If the argument comes from a table column, the column must have the same value in every row or the result is undefined. By default, the target AE receives the settings as the AE environment variables and not as an argument.

Example

SELECT * FROM demo, TABLE WITH FINAL(aedemo(f1,f2,f3,f4,
'NZAE_EXECUTABLE_PATH=/nz/export/ae/languages/java/6.13.0/jdk1.6.0_13/bin/java,
NZAE_NUMBER_PARAMETERS=1,NZAE_PARAMETER1=DataMatrix,MYAPP1="hello",MYAPP2=="good
bye"'));

The environment variables are passed within the last string argument. The SQL function must be registered with an extra string argument, such as varchar, or with arguments set to keyword "varargs" (variable number of arguments). The SQL function must also be registered with the option --dynamic2.