%TSQL.sp

hidden class %TSQL.sp extends %Library.RegisteredObject

Methods

final classmethod addtype(typename As %String, phystype As %String, identityORnulltype As %String = "") [ SQLProc = sp_addtype ]

Projected as the stored procedure: sp_addtype

Adds a type to the %TSQL.systypes table

Parameters:

typename: Is the name of the user-defined datatype.
phystype: Is the physical datatype on which to base the user-defined datatype.
identityORnulltype: Indicates that the user-defined datatype has the IDENTITY property. Enclose the identity keyword within single or double quotes. You can specify the IDENTITY property only for numeric datatypes with a scale of 0.; IDENTITY columns store sequential numbers, such as invoice numbers or employee numbers, that are generated by IRIS.
OR: Indicates how the user-defined datatype handles null value entries. Acceptable values for this parameter are null, NULL, nonull, NONULL, "not null", and "NOT NULL". Any nulltype that includes a blank space must be enclosed in single or double quotes.

final classmethod droptype(typename As %String) [ SQLProc = sp_droptype ]

Projected as the stored procedure: sp_droptype

Drops a type from the %TSQL.systypes table

Parameters:

final classmethod procxmode(procname As %String = "", tranmode As %String = "") [ SQLProc = sp_procxmode ]

Projected as the stored procedure: sp_procxmode

Displays or changes the execution modes associated with stored procedures.

Parameters:

procname: The name of the stored procedure with the transaction mode you are examining or changing.
tranmode: The new execution mode for the stored procedure. Values are "chained", "unchained", and "anymode", for transaction modes, and '[No] Dynamic Ownership Chain'..