select substr(A.SPECIFIC_SCHEMA,1,10) AS "LIB", substr(A.SPECIFIC_NAME,1,12) AS "PROC", ORDINAL_POSITION AS "POS", PARAMETER_MODE AS "MODE", substr(PARAMETER_NAME,1,11) AS "PARMNAME", substr(DATA_TYPE,1,12) AS "TYPE", case when DATA_TYPE IN ('REAL', 'BIGINT', 'DOUBLE PRECISION', 'DECIMAL', 'INTEGER', 'NUMERIC', 'SMALLINT', 'NUMERIC') then trim(CHAR(NUMERIC_PRECISION)) CONCAT ', ' CONCAT trim(CHAR(NUMERIC_SCALE)) else CHARLEN CONCAT ' ' END CASE from qsys2/sysprocs A join qsys2/sysparms B on A.SPECIFIC_SCHEMA = B.SPECIFIC_SCHEMA and A.SPECIFIC_NAME = B.SPECIFIC_NAME where A.SPECNAME = 'SOMEPROC'