Skip to main content

%TSQL.sys.procedure

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

SQL Table Name: %TSQL_sys.procedure

Property Inventory

Method Inventory

Properties

property class as %String (MAXLEN = 256);
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 (MAXLEN = 256) [ Required ];
Property methods: idPROCDisplayToLogical(), idPROCGet(), idPROCIsValid(), idPROCLogicalToDisplay(), idPROCLogicalToOdbc(), idPROCNormalize(), idPROCSet()
property idSCHEMA as %String (MAXLEN = 256) [ 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 (MAXLEN = 256);
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 (MAXLEN = 256);
Property methods: schemaDisplayToLogical(), schemaGet(), schemaIsValid(), schemaLogicalToDisplay(), schemaLogicalToOdbc(), schemaNormalize(), schemaSet()

Methods

classmethod inc()

Indexes

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

Inherited Members

Inherited Methods

Storage

Storage Model: SQLStorage

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