I'm trying to find a way of allowing our users to define SPs that process an array. I can see that the PL/SQL features can accomplish this, and I've found much acrimonious debate in the forums about whether this is a good idea or not. The DB2 workaround seems to be to declare a temporary table, populate that and then call the SP to work throught the data stored. But when I've declared a DGTT and then tried to define an SP to reference it, I get the SQL0526N message which is pretty explicitly saying you can't do this.
Is the solution just to define a 'real' table temporarily and reference that or is there some cleverer option available? We're currently LUW V9.7