Java Stored Procedures and UDFs
Stored procedures and user-defined functions (UDFs) are programs that can contain SQL statements. You invoke a stored procedure from a client program by executing the SQL CALL statement. You invoke a UDF by specifying the UDF name, followed by its arguments, in an SQL statement. For more information on stored procedures, refer to Chapter 8, “Stored Procedures,” and for more information on UDFs, refer to Chapter 15, “Object Relational Programming.”
The word routine refers to either a stored procedure or a UDF. The term compiled Java stored procedure refers to a stored procedure that runs under VisualAge for Java. The term interpreted Java stored routine refers to a stored procedure or a user-defined function that ...
Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.