Release Bulletin Adaptive Server® Enterprise Version 12.5.2 for IBM AIX

sp_sproc_columns

There is a new column in the result set for the sp_sproc_columns catalog stored procedure called mode:

Column	Datatype	Description
mode	varchar(20)	The parameter mode information stored in syscolumns that contains: For SQL procedures – in, out, or “return value”. For SQLJ procedures (Java) – in, out, inout, or “return value”.

Column

Datatype

Description

mode

varchar(20)

The parameter mode information stored in syscolumns that contains: