Sybase IQ 15.4 extends the power of external user defined table functions.
Sybase IQ 15.4 includes these features:
External Environment support for UDFs – Developers can use the Java environment to create stored procedures. Developers will be able to use standard Java APIs for processing arguments and returning values (result set) back to the server. Sybase IQ will extend the multiplex facilities for exploiting large clusters of computers from within the umbrella of SQL while making it possible for end users to write computational logic in languages other than SQL.
Support for table UDFs – Table functions can facilitate set-based customized computing by allowing the end user to implement logic that processes input data and produces relational sets as output which can then be consumed in a SQL query as if it was a table expression.
Table parameterized functions – Sybase IQ will extend the traditional table function approach to handle arbitrary rowsets as input and to allow user-specified partitioning and ordering requirements as arguments to table function invocations. Sybase IQ will extend the multiplex facilities for exploiting large clusters of computers from within the umbrella of SQL while making it possible for end users to write computational logic in languages other than SQL.