Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

12.8. Procedures and Functions

A user can define one of the following functions:
  • Source Procedure ("CREATE FOREIGN PROCEDURE") - a stored procedure in source
  • Source Function ("CREATE FOREIGN FUNCTION") - A function that is supported by the source, where JBoss Data Virtualization will pushdown to source instead of evaluating in the JBoss Data Virtualization engine.
  • Virtual Procedure ("CREATE VIRTUAL PROCEDURE") - Similar to stored procedure, however this is defined using the JBoss Data Virtualization Procedure language and evaluated in the JBoss Data Virtualization engine.
  • Function/UDF ("CREATE VIRTUAL FUNCTION") - A user defined function, that can be defined using the Teiid procedure language or can have the implementation defined using a JAVA Class.
See "create procedure" in Section A.7, “Productions”.