db2> select * from MANUFACTURER

MANUFACTURER

AUDI

VW

db2> select * from INVENTORY fetch first 10 rows only

ID          SKU 

____

 STOCK

          2 16633             10

          3 16633             10

          5 16633              7

          8 951041            10

          9 951041            10

         12 951041             9

         14 951041            10

         15 951041            10

         17 16272              9

         19 16272             10

db2> select * from TYPES fetch first 10 rows only

ID          MANUFACTURER 

_

 MODEL                     TYPE

          2 VW             PASSAT (3B2)              1.6

          3 VW             PASSAT (3B2)              1.8

          5 VW             PASSAT (3B2)              1.8 T

          8 VW             POLO (6N1)                45 1.0

          9 VW             POLO (6N1)                50 1.0

         12 VW             POLO (6N1)                55 1.3

         14 VW             POLO (6N1)                55 1.4

         15 VW             POLO (6N1)                60 1.4

         17 AUDI           80 Avant (8C, B4)         2.0

         19 AUDI           80 Avant (8C, B4)         2.0 E

10.2  Stored procedures

An extension to SQL defined by ANSI (ISO/IEC 9075) is called SQL/PSM or 

persistent, stored modules 

and extends SQL to store application logic in the form 

of procedures, functions, or triggers as database objects. The programming style 

is a mix of conventional SQL statements combined with procedural logic; for 

example, IF, WHILE for flow control. PSMs allow us to do things we cannot do in 

SQL alone.

Reasons for implementing stored procedures may be:

320 

MySQL to DB2 UDB Conversion Guide