Skip to main content

%TSQL.sys.procedure

Class %TSQL.sys.procedure Extends %Persistent [ StorageStrategy = oddproc, System = 4 ]

Properties​

idSCHEMA​

Property idSCHEMA As %String(MAXLEN = 256);

idPROC​

Property idPROC As %String(MAXLEN = 256);

schema​

Property schema As %String(MAXLEN = 256);

name​

Property name As %String(MAXLEN = 256);

class​

Property class As %String(MAXLEN = 256);

description​

Property description As %String(MAXLEN = "");

execute​

Property execute As %String(MAXLEN = 4096);

procxmode​

Property procxmode As %String [ Calculated, SqlComputeCode = { set {*}=$case($g(^rINDEXSQL("tsql","procxmode",{class},{procedure})),1:"chained",2:"anymode",:"unchanged")}, SqlComputed ];

Sybase execution modes associated with stored procedures. Values are "chained", "unchained", and "anymode", for transaction modes, and '[No] Dynamic Ownership Chain' At this time, ownership chains are not supported This is only used for TSQL stored procedures with Dialect = Sybase

interface​

Property interface As %Integer;

interface -2 function procedure with a return value that may return result sets -1 function procedure without a return value that may return result sets 0 function procedure without a return value, no result sets 1 query (single result set) 2 function with a return value, no result sets

procedure​

Property procedure As %String;

Methods​

inc​

ClassMethod inc()