Routines can be divided into the following two programming language categories:

• Java routines
  Routines written in the Java language
  
• SQL routines
  Routines written in SQL
  

Routines can be divided into two classes, depending on the definition SQL:

• Procedures
• Functions

Organization of this section

1.8.1 Procedures

1.8.2 Functions

1.8.3 Results-set return facility