Register generic procedures

When you register a stored procedure that uses generic arguments, you use the keyword ANY to declare character or numeric data types as generic.

An example follows:

MYDB.TESTSCH(USR)=> CREATE PROCEDURE itemfind(NUMERIC(ANY))
RETURNS CHAR(ANY) LANGUAGE NZPLSQL AS
BEGIN_PROC
  BEGIN
    /* Body of procedure... intentionally omitted from example*/
  END;
END_PROC;

In this example, the itemfind() procedure takes an input numeric data type of any valid size and returns char value of any size.