Using Array in SQL stored procedure in IBM i AS400.
This video explains how to create SQLUDT i.e. sql user defined data type of ARRAY and how to pass ARRAY between two stored procedure and how to use array and populate array in SQL stored procedure.
Use of CARDINALITY function.