Home > Class Reference > HSLIB namespace > %TSQL.sys.procedure


persistent class %TSQL.sys.procedure extends %Library.Persistent

SQL Table Name: %TSQL_sys.procedure

Property Inventory

Method Inventory


property class as %String;
Property methods: classDisplayToLogical(), classGet(), classIsValid(), classLogicalToDisplay(), classLogicalToOdbc(), classNormalize(), classSet()
property description as %String;
Property methods: descriptionDisplayToLogical(), descriptionGet(), descriptionIsValid(), descriptionLogicalToDisplay(), descriptionLogicalToOdbc(), descriptionNormalize(), descriptionSet()
property execute as %String (MAXLEN = 4096);
Property methods: executeDisplayToLogical(), executeGet(), executeIsValid(), executeLogicalToDisplay(), executeLogicalToOdbc(), executeNormalize(), executeSet()
property idPROC as %String [ Required ];
Property methods: idPROCDisplayToLogical(), idPROCGet(), idPROCIsValid(), idPROCLogicalToDisplay(), idPROCLogicalToOdbc(), idPROCNormalize(), idPROCSet()
property idSCHEMA as %String [ Required ];
Property methods: idSCHEMADisplayToLogical(), idSCHEMAGet(), idSCHEMAIsValid(), idSCHEMALogicalToDisplay(), idSCHEMALogicalToOdbc(), idSCHEMANormalize(), idSCHEMASet()
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
Property methods: interfaceDisplayToLogical(), interfaceGet(), interfaceIsValid(), interfaceLogicalToDisplay(), interfaceNormalize(), interfaceSet()
property name as %String;
Property methods: nameDisplayToLogical(), nameGet(), nameIsValid(), nameLogicalToDisplay(), nameLogicalToOdbc(), nameNormalize(), nameSet()
property procedure as %String;
Property methods: procedureDisplayToLogical(), procedureGet(), procedureIsValid(), procedureLogicalToDisplay(), procedureLogicalToOdbc(), procedureNormalize(), procedureSet()
property procxmode as %String [ Calculated ];
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
Property methods: procxmodeCompute(), procxmodeDisplayToLogical(), procxmodeGet(), procxmodeIsValid(), procxmodeLogicalToDisplay(), procxmodeLogicalToOdbc(), procxmodeNormalize(), procxmodeSQLCompute()
property schema as %String;
Property methods: schemaDisplayToLogical(), schemaGet(), schemaIsValid(), schemaLogicalToDisplay(), schemaLogicalToOdbc(), schemaNormalize(), schemaSet()


classmethod inc() [ Language = objectscript ]


index (ID on idSCHEMA,idPROC) [IdKey, Type = key];
Index methods: IDCheck(), IDDelete(), IDExists(), IDOpen(), IDSQLCheckUnique(), IDSQLExists(), IDSQLFindPKeyByConstraint(), IDSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods


Storage Model: SQLStorage

Maps: 1

FeedbackOpens in a new window