Sybase Adaptive Server Anywhere - SYSPROCPARMS System View

SYSPROCPARMS system view
1064
SYSPROCPARMS system view
CREATE VIEW SYS.SYSPROCPARMS ( creator, parmname,
procname,
parmtype, parmmode, parmdomain, length, remarks )
AS
SELECT ( SELECT user_name FROM SYS.SYSUSERPERM
WHERE user_id = SYSPROCEDURE.creator ),
parm_name, proc_name, parm_type,
IF parm_mode_in = ’Y’ AND
parm_mode_out = ’N’ THEN ’IN’
ELSE IF parm_mode_in = ’N’
AND parm_mode_out = ’Y’ THEN ’OUT’
ELSE ’INOUT’ ENDIF ENDIF,
( SELECT domain_name FROM SYS.SYSDOMAIN
WHERE domain_id = SYSPROCPARM.domain_id ),
width, SYSPROCPARM.remarks
FROM SYS.SYSPROCPARM == SYS.SYSPROCEDURE
Presents the procedure parameters from SYSPROCPARM in a more
readable format.