This section explains how to define stored procedures and stored functions.

Be sure to create the necessary RDAREA spaces before defining stored procedures and stored functions. For details about the operation of stored procedures and stored functions, see the HiRDB Version 9 System Operation Guide.

You can use SQL, Java, or C language to code stored procedures and stored functions. Those coded in SQL are called SQL stored procedures and SQL stored functions. Those coded in Java are called Java stored procedures and Java stored functions, and those coded in C language are called C stored procedures and C stored functions.

The stored procedures and stored functions are referred to collectively as stored routines. A stored routine whose owner is PUBLIC, meaning all users, is called a public routine.

For details about Java stored procedures and Java stored functions, see 9. Java Stored Procedures and Java Stored Functions. For details about C stored procedures and C stored functions, see 10. C Stored Procedures and C Stored Functions.

Note

If an error occurs while an SQL stored procedure or SQL stored function is being executed, processing of the SQL stored procedure or SQL stored function terminates at the point when the error occurred (the programs exits from control of the SQL stored procedure or SQL stored function). Therefore, error-handling processes cannot be specified in SQL stored procedures and SQL stored functions.

Organization of this section

4.3.1 Defining a stored procedure

4.3.2 Defining a stored function

4.3.3 Defining and deleting stored functions