Each row in the SYSPROCPARMS view describes a parameter to a procedure in the database.
The tables and columns that make up this view are provided in the SQL statement below. To learn more about a particular table or column, use the links provided beneath the view definition.
ALTER VIEW "SYS"."SYSPROCPARMS"( creator, procname,parmname,parm_id,parmtype,parmmode,parmdomain, length,scale,"default",user_type ) as select up.user_name,p.proc_name,pp.parm_name,pp.parm_id,pp.parm_type, if pp.parm_mode_in = 'Y' and pp.parm_mode_out = 'N' then 'IN' else if pp.parm_mode_in = 'N' and pp.parm_mode_out = 'Y' then 'OUT' else 'INOUT' endif endif,dom.domain_name,pp.width,pp.scale,pp."default",ut.type_name from SYS.ISYSPROCPARM as pp join SYS.ISYSPROCEDURE as p on p.proc_id = pp.proc_id join SYS.ISYSUSER as up on up.user_id = p.creator join SYS.ISYSDOMAIN as dom on dom.domain_id = pp.domain_id left outer join SYS.ISYSUSERTYPE as ut on ut.type_id = pp.user_type; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |