Below the first stored procedure I have written.  It works as intended.
But, being my first one, I wanted to see if there are any obvious (or not so
obvious) flaws in it.  (Yes, there's a reason, perhaps not a good one, why I
have the OUT fields before the INOUT fields.)

CREATE PROCEDURE DB2DEV.GET_FEE_AMOUNT ( OUT amount DECIMAL(9,2),
                                        OUT descr VARCHAR(100),
                                        INOUT typ CHARACTER(3),
                                        INOUT subtype CHARACTER(3),
                                        INOUT bank DECIMAL(5,0),
                                        INOUT brch DECIMAL(3,0),
                                        INOUT acct DECIMAL(7,0)
                                        )
   READS SQL DATA
------------------------------------------------------------------------
-- SQL Stored Procedure
   -- amount Fee amount
   -- descr Fee description
   -- typ Fee type code
   -- subtype Fee subtype code
   -- bank Bank number
   -- brch Branch number
   -- acct Account number
------------------------------------------------------------------------
P1: BEGIN
   DECLARE cursor1 CURSOR WITH RETURN FOR
       SELECT FA.AMOUNT, FA.DESCR, FA.TYP, FA.SUBTYP, FA.BANK, FA.BRCH,
FA.ACCT
       FROM DB2DEV.FEE_AMOUNTS AS FA
       WHERE (FA.TYP = GET_FEE_AMOUNT.typ AND FA.SUBTYP =
GET_FEE_AMOUNT.subtype) AND ((GET_FEE_AMOUNT.brch <> 0 AND
GET_FEE_AMOUNT.acct <> 0 AND FA.BRCH = GET_FEE_AMOUNT.brch AND FA.ACCT =
GET_FEE_AMOUNT.acct) OR (GET_FEE_AMOUNT.brch <> 0 AND FA.BRCH =
GET_FEE_AMOUNT.brch AND FA.ACCT = 0) OR (GET_FEE_AMOUNT.bank <> 0 AND
FA.BANK = GET_FEE_AMOUNT.bank AND FA.BRCH = 0) OR (FA.BANK = 0 AND FA.BRCH =
0 AND FA.ACCT = 0))
       ORDER BY FA.ACCT DESC, FA.BRCH DESC, FA.BANK DESC
       FETCH FIRST 1 ROW ONLY;
   OPEN cursor1;
   -- Set defaults in case no rows result
   SET typ = NULL;
   SET subtype = NULL;
   SET bank = NULL;
   SET brch = NULL;
   SET acct = NULL;
   FETCH cursor1 INTO amount, descr, typ, subtype, bank, brch, acct;
   CLOSE cursor1;
END P1

Here is the DDL to create the table:
------------------------------------------------
-- DDL Statements for table "DB2DEV  "."FEE_AMOUNTS"
------------------------------------------------

CREATE TABLE "DB2DEV  "."FEE_AMOUNTS"  (
                 "TYP" CHAR(3) NOT NULL ,
                 "SUBTYP" CHAR(3) NOT NULL ,
                 "BANK" DECIMAL(5,0) NOT NULL ,
                 "BRCH" DECIMAL(3,0) NOT NULL ,
                 "ACCT" DECIMAL(16,0) NOT NULL ,
                 "AMOUNT" DECIMAL(9,2) NOT NULL ,
                 "DESCR" VARCHAR(100) )
                VALUE COMPRESSION
                IN "USERSPACE1" ;

-- DDL Statements for primary key on Table "DB2DEV  "."FEE_AMOUNTS"

ALTER TABLE "DB2DEV  "."FEE_AMOUNTS"
       ADD CONSTRAINT "CC1151514082302" PRIMARY KEY
               ("TYP",
                "SUBTYP",
                "BANK",
                "BRCH",
                "ACCT");

And here are some records in the table.

TYP SUBTYP BANK    BRCH  ACCT               AMOUNT      DESCR

--- ------ ------- ----- ------------------ ----------- -----------------
AAA 000         0.    0.                 0.        3.00 AAA000 default

AAA 000       111.    0.                 0.        2.95 AAA000 bank 00111

AAA 000         0.  234.                 0.        2.90 AAA000 brch 234

AAA 000         0.  234.            1234567.        2.85 AAA000 2341234567

AAA 000       456.    0.                 0.        2.80 AAA000 bank 00456

AAA 000         0.  345.                 0.        2.75 AAA000 brch 345

AAA 000         0.  345.            9876543.        2.70 AAA000 3459876543

AAB 000         0.    0.                 0.        2.00 AAB000 default

AAA 001         0.    0.                 0.       10.00 AAA001 default

The point of the SP is to return one and only one row, the one which best
matches the inputs, with non-zero values being prefered of zeroes.  For
example

db2 => call get_fee_amount ( ?, ?, 'AAA', '000', 00456, 345, 1234567)

 Value of output parameters
 --------------------------
 Parameter Name  : AMOUNT
 Parameter Value :  2.75

 Parameter Name  : DESCR
 Parameter Value : AAA000 brch 345

 Parameter Name  : TYP
 Parameter Value : AAA

 Parameter Name  : SUBTYPE
 Parameter Value : 000

 Parameter Name  : BANK
 Parameter Value :  0.

 Parameter Name  : BRCH
 Parameter Value :  345.

 Parameter Name  : ACCT
 Parameter Value :  0.

 Return Status = 0

Essentially, if there's a branch/account match we want to select that row;
next we try to match on just branch (with account 0); then we try bank match
with branch and account 0; then finally we default to bank, branch and
account all set to zero (assuming, of course, we'll always get a
type/subtype match; otherwise we're must be inputing the wrong
type/subtype!)

One thing I'm not satisfied with is the setting of the INOUT parms to NULL
prior to the FETCH.  I would rather only execute this if the FETCH returns
no result, but I wasn't able to get that to work correctly.

Anyway, thanks ahead of time for any thoughts/recommendations.

Frank

---
Frank Swarbrick
Senior Developer/Analyst - Mainframe Applications
FirstBank Data Corporation - Lakewood, CO  USA