Skip to main content


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 schema as %String;
Property methods: schemaDisplayToLogical(), schemaGet(), schemaIsValid(), schemaLogicalToDisplay(), schemaLogicalToOdbc(), schemaNormalize(), schemaSet()


classmethod inc()


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

Inherited Members

Inherited Methods


Storage Model: CacheSQLStorage

Maps: 1

  • Map number 1 is named master

    thismap.Global: ^oddPROC

  • ^oddPROC({idSCHEMA},{idPROC})
    Node Delimiter Piece Name
    1 class
    2 description
    3 execute
    8 interface
    10 name
    14 procedure
    20 schema
FeedbackOpens in a new tab