INFORMATION.SCHEMA.ROUTINES
persistent class INFORMATION.SCHEMA.ROUTINES extends %Library.Persistent [ Final ]
SQL Table Name: INFORMATION_SCHEMA.ROUTINES
Returns one row for each stored procedure and function that can be accessed by the current user in the current namespace.Property Inventory
- ASLOCATOR
- CHARACTERMAXIMUMLENGTH
- CHARACTEROCTETLENGTH
- CHARACTERSETCATALOG
- CHARACTERSETNAME
- CHARACTERSETSCHEMA
- COLLATIONCATALOG
- COLLATIONNAME
- COLLATIONSCHEMA
- CREATED
- Classname
- DATATYPE
- DATETIMEPRECISION
- DTDIDENTIFIER
- EXTERNALLANGUAGE
- EXTERNALNAME
- ISDETERMINISTIC
- ISIMPLICITLYINVOCABLE
- ISNULLCALL
- ISUDTDEPENDENT
- ISUSERDEFINEDCAST
- LASTALTERED
- MAXDYNAMICRESULTSETS
- MODULECATALOG
- MODULENAME
- MODULESCHEMA
- MethodQueryName
- NEWSAVEPOINTLEVEL
- NUMERICPRECISION
- NUMERICPRECISIONRADIX
- NUMERICSCALE
- PARAMETERSTYLE
- RESULTCASTASLOCATOR
- RESULTCASTFROMDTDIDENTIFIER
- ROUTINEBODY
- ROUTINECATALOG
- ROUTINEDEFINITION
- ROUTINENAME
- ROUTINESCHEMA
- ROUTINETYPE
- SCHEMALEVELROUTINE
- SECURITYTYPE
- SPECIFICCATALOG
- SPECIFICNAME
- SPECIFICSCHEMA
- SQLDATAACCESS
- SQLPATH
- TOSQLSPECIFICCATALOG
- TOSQLSPECIFICNAME
- TOSQLSPECIFICSCHEMA
- USERDEFINEDTYPECATALOG
- USERDEFINEDTYPENAME
- USERDEFINEDTYPESCHEMA
Parameters
parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted.
Tables are projected to SQL as READONLY.
Properties
property ASLOCATOR as %String (MAXLEN = 3, VALUELIST = ",YES,NO") [ Calculated , SqlFieldName = AS_LOCATOR ];
Returns YES or NO based on if the return value of the function is a LOB oref value and not the actual data value of the LOB.
AS_LOCATOR have the following meanings:
AS_LOCATOR have the following meanings:
- YES - The return value of the routine being described is an stream oref.
- NO - The return value of the routine being described is not an stream oref.
- null - The routine is a class query procedure.
Property methods: ASLOCATORCompute(), ASLOCATORDisplayToLogical(), ASLOCATORGet(), ASLOCATORIsValid(), ASLOCATORLogicalToDisplay(), ASLOCATORLogicalToOdbc(), ASLOCATORNormalize(), ASLOCATORSQLCompute()
property CHARACTERMAXIMUMLENGTH as %Integer [ Calculated , SqlFieldName = CHARACTER_MAXIMUM_LENGTH ];
Maximum length in characters, if the return type is a character type. If not a character type, returns null.
Property methods: CHARACTERMAXIMUMLENGTHCompute(), CHARACTERMAXIMUMLENGTHDisplayToLogical(), CHARACTERMAXIMUMLENGTHGet(), CHARACTERMAXIMUMLENGTHIsValid(), CHARACTERMAXIMUMLENGTHLogicalToDisplay(), CHARACTERMAXIMUMLENGTHNormalize(), CHARACTERMAXIMUMLENGTHSQLCompute()
property CHARACTEROCTETLENGTH as %Integer [ Calculated , SqlFieldName = CHARACTER_OCTET_LENGTH ];
Reserved for future use. For InterSystems IRIS, CHARACTER_OCTET_LENGTH is always NULL.
Property methods: CHARACTEROCTETLENGTHCompute(), CHARACTEROCTETLENGTHDisplayToLogical(), CHARACTEROCTETLENGTHGet(), CHARACTEROCTETLENGTHIsValid(), CHARACTEROCTETLENGTHLogicalToDisplay(), CHARACTEROCTETLENGTHNormalize(), CHARACTEROCTETLENGTHSQLCompute()
property CHARACTERSETCATALOG as %String (MAXLEN = 3) [ Calculated , SqlFieldName = CHARACTER_SET_CATALOG ];
Reserved for future use. For InterSystems IRIS, CHARACTER_SET_CATALOG is always NULL.
Property methods: CHARACTERSETCATALOGCompute(), CHARACTERSETCATALOGDisplayToLogical(), CHARACTERSETCATALOGGet(), CHARACTERSETCATALOGIsValid(), CHARACTERSETCATALOGLogicalToDisplay(), CHARACTERSETCATALOGLogicalToOdbc(), CHARACTERSETCATALOGNormalize(), CHARACTERSETCATALOGSQLCompute()
property CHARACTERSETNAME as %String (MAXLEN = 3) [ Calculated , SqlFieldName = CHARACTER_SET_NAME ];
Reserved for future use. For InterSystems IRIS, CHARACTER_SET_NAME is always NULL.
Property methods: CHARACTERSETNAMECompute(), CHARACTERSETNAMEDisplayToLogical(), CHARACTERSETNAMEGet(), CHARACTERSETNAMEIsValid(), CHARACTERSETNAMELogicalToDisplay(), CHARACTERSETNAMELogicalToOdbc(), CHARACTERSETNAMENormalize(), CHARACTERSETNAMESQLCompute()
property CHARACTERSETSCHEMA as %String (MAXLEN = 3) [ Calculated , SqlFieldName = CHARACTER_SET_SCHEMA ];
Reserved for future use. For InterSystems IRIS, CHARACTER_SET_SCHEMA is always NULL.
Property methods: CHARACTERSETSCHEMACompute(), CHARACTERSETSCHEMADisplayToLogical(), CHARACTERSETSCHEMAGet(), CHARACTERSETSCHEMAIsValid(), CHARACTERSETSCHEMALogicalToDisplay(), CHARACTERSETSCHEMALogicalToOdbc(), CHARACTERSETSCHEMANormalize(), CHARACTERSETSCHEMASQLCompute()
property COLLATIONCATALOG as %String (MAXLEN = 3) [ Calculated , SqlFieldName = COLLATION_CATALOG ];
Reserved for future use. For InterSystems IRIS, COLLATION_CATALOG is always NULL.
Property methods: COLLATIONCATALOGCompute(), COLLATIONCATALOGDisplayToLogical(), COLLATIONCATALOGGet(), COLLATIONCATALOGIsValid(), COLLATIONCATALOGLogicalToDisplay(), COLLATIONCATALOGLogicalToOdbc(), COLLATIONCATALOGNormalize(), COLLATIONCATALOGSQLCompute()
property COLLATIONNAME as %String (MAXLEN = 3) [ Calculated , SqlFieldName = COLLATION_NAME ];
Reserved for future use. For InterSystems IRIS, COLLATION_NAME is always NULL.
Property methods: COLLATIONNAMECompute(), COLLATIONNAMEDisplayToLogical(), COLLATIONNAMEGet(), COLLATIONNAMEIsValid(), COLLATIONNAMELogicalToDisplay(), COLLATIONNAMELogicalToOdbc(), COLLATIONNAMENormalize(), COLLATIONNAMESQLCompute()
property COLLATIONSCHEMA as %String (MAXLEN = 3) [ Calculated , SqlFieldName = COLLATION_SCHEMA ];
Reserved for future use. For InterSystems IRIS, COLLATION_SCHEMA is always NULL.
Property methods: COLLATIONSCHEMACompute(), COLLATIONSCHEMADisplayToLogical(), COLLATIONSCHEMAGet(), COLLATIONSCHEMAIsValid(), COLLATIONSCHEMALogicalToDisplay(), COLLATIONSCHEMALogicalToOdbc(), COLLATIONSCHEMANormalize(), COLLATIONSCHEMASQLCompute()
property CREATED as %TimeStamp [ Calculated ];
For InterSystems IRIS, CREATED is always NULL.
Property methods: CREATEDCompute(), CREATEDDisplayToLogical(), CREATEDGet(), CREATEDIsValid(), CREATEDLogicalToDisplay(), CREATEDNormalize(), CREATEDOdbcToLogical(), CREATEDSQLCompute()
property Classname as %String (MAXLEN = 255) [ SqlFieldName = CLASSNAME ];
Name of the class that projected the Stored Procedure
Property methods: ClassnameDisplayToLogical(), ClassnameGet(), ClassnameIsValid(), ClassnameLogicalToDisplay(), ClassnameLogicalToOdbc(), ClassnameNormalize(), ClassnameSet()
property DATATYPE as %String (MAXLEN = 30) [ Calculated , SqlFieldName = DATA_TYPE ];
Data type of the return value of the function. Returns null if the procedure has no return value.
Property methods: DATATYPECompute(), DATATYPEDisplayToLogical(), DATATYPEGet(), DATATYPEIsValid(), DATATYPELogicalToDisplay(), DATATYPELogicalToOdbc(), DATATYPENormalize(), DATATYPESQLCompute()
property DATETIMEPRECISION as %Integer [ Calculated , SqlFieldName = DATETIME_PRECISION ];
Reserved for future use. For InterSystems IRIS, DATETIME_PRECISION is always NULL.
Property methods: DATETIMEPRECISIONCompute(), DATETIMEPRECISIONDisplayToLogical(), DATETIMEPRECISIONGet(), DATETIMEPRECISIONIsValid(), DATETIMEPRECISIONLogicalToDisplay(), DATETIMEPRECISIONNormalize(), DATETIMEPRECISIONSQLCompute()
property DTDIDENTIFIER as %String (MAXLEN = 3) [ Calculated , SqlFieldName = DTD_IDENTIFIER ];
Reserved for future use. For InterSystems IRIS, DTD_IDENTIFIER is always NULL.
Property methods: DTDIDENTIFIERCompute(), DTDIDENTIFIERDisplayToLogical(), DTDIDENTIFIERGet(), DTDIDENTIFIERIsValid(), DTDIDENTIFIERLogicalToDisplay(), DTDIDENTIFIERLogicalToOdbc(), DTDIDENTIFIERNormalize(), DTDIDENTIFIERSQLCompute()
property EXTERNALLANGUAGE as %String (MAXLEN = 3) [ Calculated , SqlFieldName = EXTERNAL_LANGUAGE ];
Reserved for future use. For InterSystems IRIS, EXTERNAL_LANGUAGE is always NULL.
Property methods: EXTERNALLANGUAGECompute(), EXTERNALLANGUAGEDisplayToLogical(), EXTERNALLANGUAGEGet(), EXTERNALLANGUAGEIsValid(), EXTERNALLANGUAGELogicalToDisplay(), EXTERNALLANGUAGELogicalToOdbc(), EXTERNALLANGUAGENormalize(), EXTERNALLANGUAGESQLCompute()
property EXTERNALNAME as %String (MAXLEN = 3) [ Calculated , SqlFieldName = EXTERNAL_NAME ];
Reserved for future use. For InterSystems IRIS, EXTERNAL_NAME is always NULL.
Property methods: EXTERNALNAMECompute(), EXTERNALNAMEDisplayToLogical(), EXTERNALNAMEGet(), EXTERNALNAMEIsValid(), EXTERNALNAMELogicalToDisplay(), EXTERNALNAMELogicalToOdbc(), EXTERNALNAMENormalize(), EXTERNALNAMESQLCompute()
property ISDETERMINISTIC as %String (MAXLEN = 3) [ Calculated , SqlFieldName = IS_DETERMINISTIC ];
Reserved for future use. For InterSystems IRIS, IS_DETERMINISTIC is always NULL.
Property methods: ISDETERMINISTICCompute(), ISDETERMINISTICDisplayToLogical(), ISDETERMINISTICGet(), ISDETERMINISTICIsValid(), ISDETERMINISTICLogicalToDisplay(), ISDETERMINISTICLogicalToOdbc(), ISDETERMINISTICNormalize(), ISDETERMINISTICSQLCompute()
property ISIMPLICITLYINVOCABLE as %String (MAXLEN = 3) [ Calculated , SqlFieldName = IS_IMPLICITLY_INVOCABLE ];
The values of IS_IMPLICITLY_INVOCABLE have the following meanings:
- YES - The user-defined cast function is implicitly invocable.
- NO - The user-defined cast function is not implicitly invocable.
- null - The routine is not a user-defined cast function.
Property methods: ISIMPLICITLYINVOCABLECompute(), ISIMPLICITLYINVOCABLEDisplayToLogical(), ISIMPLICITLYINVOCABLEGet(), ISIMPLICITLYINVOCABLEIsValid(), ISIMPLICITLYINVOCABLELogicalToDisplay(), ISIMPLICITLYINVOCABLELogicalToOdbc(), ISIMPLICITLYINVOCABLENormalize(), ISIMPLICITLYINVOCABLESQLCompute()
property ISNULLCALL as %String (MAXLEN = 3, VALUELIST = ",YES,NO") [ Calculated , SqlFieldName = IS_NULL_CALL ];
The values of IS_NULL_CALL have the following meanings:
- YES - The routine is a function and returns null if any of its parameters are null.
- NO - The routine is a function and its return value is determined by invoking the routine.
- null - The routine being described is a class query procedure.
Property methods: ISNULLCALLCompute(), ISNULLCALLDisplayToLogical(), ISNULLCALLGet(), ISNULLCALLIsValid(), ISNULLCALLLogicalToDisplay(), ISNULLCALLLogicalToOdbc(), ISNULLCALLNormalize(), ISNULLCALLSQLCompute()
property ISUDTDEPENDENT as %String (MAXLEN = 3, VALUELIST = ",YES,NO") [ Calculated , SqlFieldName = IS_UDT_DEPENDENT ];
Reserved for future use. For InterSystems IRIS, IS_UDT_DEPENDENT is always NULL.
Property methods: ISUDTDEPENDENTCompute(), ISUDTDEPENDENTDisplayToLogical(), ISUDTDEPENDENTGet(), ISUDTDEPENDENTIsValid(), ISUDTDEPENDENTLogicalToDisplay(), ISUDTDEPENDENTLogicalToOdbc(), ISUDTDEPENDENTNormalize(), ISUDTDEPENDENTSQLCompute()
property ISUSERDEFINEDCAST as %String (MAXLEN = 3, VALUELIST = ",YES,NO") [ Calculated , SqlFieldName = IS_USER_DEFINED_CAST ];
The values of IS_USER_DEFINED_CAST have the following meanings:
- YES - The routine is a function that is a user-defined cast function.
- NO - The routine is a function that is not a user-defined cast function.
- null - The routine being described is a class query procedure.
Property methods: ISUSERDEFINEDCASTCompute(), ISUSERDEFINEDCASTDisplayToLogical(), ISUSERDEFINEDCASTGet(), ISUSERDEFINEDCASTIsValid(), ISUSERDEFINEDCASTLogicalToDisplay(), ISUSERDEFINEDCASTLogicalToOdbc(), ISUSERDEFINEDCASTNormalize(), ISUSERDEFINEDCASTSQLCompute()
property LASTALTERED as %TimeStamp [ Calculated , SqlFieldName = LAST_ALTERED ];
For InterSystems IRIS, LAST_ALTERED is always NULL.
Property methods: LASTALTEREDCompute(), LASTALTEREDDisplayToLogical(), LASTALTEREDGet(), LASTALTEREDIsValid(), LASTALTEREDLogicalToDisplay(), LASTALTEREDNormalize(), LASTALTEREDOdbcToLogical(), LASTALTEREDSQLCompute()
property MAXDYNAMICRESULTSETS as %SmallInt [ Calculated , SqlFieldName = MAX_DYNAMIC_RESULT_SETS ];
Reserved for future use. For InterSystems IRIS, MAX_DYNAMIC_RESULT_SETS is always NULL.
Property methods: MAXDYNAMICRESULTSETSCompute(), MAXDYNAMICRESULTSETSDisplayToLogical(), MAXDYNAMICRESULTSETSGet(), MAXDYNAMICRESULTSETSIsValid(), MAXDYNAMICRESULTSETSLogicalToDisplay(), MAXDYNAMICRESULTSETSNormalize(), MAXDYNAMICRESULTSETSSQLCompute()
property MODULECATALOG as %String (MAXLEN = 3) [ Calculated , SqlFieldName = MODULE_CATALOG ];
Reserved for future use. For InterSystems IRIS, MODULE_CATALOG is always NULL.
Property methods: MODULECATALOGCompute(), MODULECATALOGDisplayToLogical(), MODULECATALOGGet(), MODULECATALOGIsValid(), MODULECATALOGLogicalToDisplay(), MODULECATALOGLogicalToOdbc(), MODULECATALOGNormalize(), MODULECATALOGSQLCompute()
property MODULENAME as %String (MAXLEN = 3) [ Calculated , SqlFieldName = MODULE_NAME ];
Reserved for future use. For InterSystems IRIS, MODULE_NAME is always NULL.
Property methods: MODULENAMECompute(), MODULENAMEDisplayToLogical(), MODULENAMEGet(), MODULENAMEIsValid(), MODULENAMELogicalToDisplay(), MODULENAMELogicalToOdbc(), MODULENAMENormalize(), MODULENAMESQLCompute()
property MODULESCHEMA as %String (MAXLEN = 3) [ Calculated , SqlFieldName = MODULE_SCHEMA ];
Reserved for future use. For InterSystems IRIS, MODULE_SCHEMA is always NULL.
Property methods: MODULESCHEMACompute(), MODULESCHEMADisplayToLogical(), MODULESCHEMAGet(), MODULESCHEMAIsValid(), MODULESCHEMALogicalToDisplay(), MODULESCHEMALogicalToOdbc(), MODULESCHEMANormalize(), MODULESCHEMASQLCompute()
property MethodQueryName as %String (MAXLEN = 255) [ SqlFieldName = METHOD_OR_QUERY_NAME ];
Name of the class method or class query that projected this procedure
Property methods: MethodQueryNameDisplayToLogical(), MethodQueryNameGet(), MethodQueryNameIsValid(), MethodQueryNameLogicalToDisplay(), MethodQueryNameLogicalToOdbc(), MethodQueryNameNormalize(), MethodQueryNameSet()
property NEWSAVEPOINTLEVEL as %String (MAXLEN = 3, VALUELIST = ",YES,NO") [ Calculated , SqlFieldName = NEW_SAVEPOINT_LEVEL ];
Reserved for future use. For InterSystems IRIS, NEW_SAVEPOINT_LEVEL is always NULL.
Property methods: NEWSAVEPOINTLEVELCompute(), NEWSAVEPOINTLEVELDisplayToLogical(), NEWSAVEPOINTLEVELGet(), NEWSAVEPOINTLEVELIsValid(), NEWSAVEPOINTLEVELLogicalToDisplay(), NEWSAVEPOINTLEVELLogicalToOdbc(), NEWSAVEPOINTLEVELNormalize(), NEWSAVEPOINTLEVELSQLCompute()
property NUMERICPRECISION as %SmallInt [ Calculated , SqlFieldName = NUMERIC_PRECISION ];
Numeric precision of the return value. For the nonnumeric types, returns NULL.
Property methods: NUMERICPRECISIONCompute(), NUMERICPRECISIONDisplayToLogical(), NUMERICPRECISIONGet(), NUMERICPRECISIONIsValid(), NUMERICPRECISIONLogicalToDisplay(), NUMERICPRECISIONNormalize(), NUMERICPRECISIONSQLCompute()
property NUMERICPRECISIONRADIX as %Integer [ Calculated , SqlFieldName = NUMERIC_PRECISION_RADIX ];
Numeric precision radix of the return value. For nonnumeric types, returns NULL.
Property methods: NUMERICPRECISIONRADIXCompute(), NUMERICPRECISIONRADIXDisplayToLogical(), NUMERICPRECISIONRADIXGet(), NUMERICPRECISIONRADIXIsValid(), NUMERICPRECISIONRADIXLogicalToDisplay(), NUMERICPRECISIONRADIXNormalize(), NUMERICPRECISIONRADIXSQLCompute()
property NUMERICSCALE as %Integer [ Calculated , SqlFieldName = NUMERIC_SCALE ];
Scale of the return value. For nonnumeric types, returns NULL.
Property methods: NUMERICSCALECompute(), NUMERICSCALEDisplayToLogical(), NUMERICSCALEGet(), NUMERICSCALEIsValid(), NUMERICSCALELogicalToDisplay(), NUMERICSCALENormalize(), NUMERICSCALESQLCompute()
property PARAMETERSTYLE as %String (MAXLEN = 3) [ Calculated , SqlFieldName = PARAMETER_STYLE ];
Reserved for future use. For InterSystems IRIS, PARAMETER_STYLE is always NULL.
Property methods: PARAMETERSTYLECompute(), PARAMETERSTYLEDisplayToLogical(), PARAMETERSTYLEGet(), PARAMETERSTYLEIsValid(), PARAMETERSTYLELogicalToDisplay(), PARAMETERSTYLELogicalToOdbc(), PARAMETERSTYLENormalize(), PARAMETERSTYLESQLCompute()
property RESULTCASTASLOCATOR as %String (MAXLEN = 3, VALUELIST = ",YES,NO") [ Calculated , SqlFieldName = RESULT_CAST_AS_LOCATOR ];
Reserved for future use. For InterSystems IRIS, RESULT_CAST_AS_LOCATOR is always NULL.
Property methods: RESULTCASTASLOCATORCompute(), RESULTCASTASLOCATORDisplayToLogical(), RESULTCASTASLOCATORGet(), RESULTCASTASLOCATORIsValid(), RESULTCASTASLOCATORLogicalToDisplay(), RESULTCASTASLOCATORLogicalToOdbc(), RESULTCASTASLOCATORNormalize(), RESULTCASTASLOCATORSQLCompute()
property RESULTCASTFROMDTDIDENTIFIER as %String (MAXLEN = 3) [ Calculated , SqlFieldName = RESULT_CAST_FROM_DTD_IDENTIFIER ];
Reserved for future use. For InterSystems IRIS, RESULT_CAST_FROM_DTD_IDENTIFIER is always NULL.
Property methods: RESULTCASTFROMDTDIDENTIFIERCompute(), RESULTCASTFROMDTDIDENTIFIERDisplayToLogical(), RESULTCASTFROMDTDIDENTIFIERGet(), RESULTCASTFROMDTDIDENTIFIERIsValid(), RESULTCASTFROMDTDIDENTIFIERLogicalToDisplay(), RESULTCASTFROMDTDIDENTIFIERLogicalToOdbc(), RESULTCASTFROMDTDIDENTIFIERNormalize(), RESULTCASTFROMDTDIDENTIFIERSQLCompute()
property ROUTINEBODY as %String (MAXLEN = 8, VALUELIST = ",SQL,EXTERNAL") [ Calculated , SqlFieldName = ROUTINE_BODY ];
The values of ROUTINE_BODY have the following meanings:
- SQL - Means this routine is a class query with language SQL.
- EXTERNAL - Means this is not a class query with language SQL.
Property methods: ROUTINEBODYCompute(), ROUTINEBODYDisplayToLogical(), ROUTINEBODYGet(), ROUTINEBODYIsValid(), ROUTINEBODYLogicalToDisplay(), ROUTINEBODYLogicalToOdbc(), ROUTINEBODYNormalize(), ROUTINEBODYSQLCompute()
property ROUTINECATALOG as %String (MAXLEN = 3) [ Calculated , SqlFieldName = ROUTINE_CATALOG ];
Reserved for future use. Routine qualifier - always NULL in InterSystems IRIS.
Property methods: ROUTINECATALOGCompute(), ROUTINECATALOGDisplayToLogical(), ROUTINECATALOGGet(), ROUTINECATALOGIsValid(), ROUTINECATALOGLogicalToDisplay(), ROUTINECATALOGLogicalToOdbc(), ROUTINECATALOGNormalize(), ROUTINECATALOGSQLCompute()
property ROUTINEDEFINITION as %String (MAXLEN = 8192) [ Calculated , SqlFieldName = ROUTINE_DEFINITION ];
/// The routine's query expression. If longer than 8192 characters, or the routine is not an SQL class query, NULL is returned.
Property methods: ROUTINEDEFINITIONCompute(), ROUTINEDEFINITIONDisplayToLogical(), ROUTINEDEFINITIONGet(), ROUTINEDEFINITIONIsValid(), ROUTINEDEFINITIONLogicalToDisplay(), ROUTINEDEFINITIONLogicalToOdbc(), ROUTINEDEFINITIONNormalize(), ROUTINEDEFINITIONSQLCompute()
property ROUTINENAME as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = ROUTINE_NAME , Required ];
Routine name, same as SPECIFIC_NAME.
Property methods: ROUTINENAMEDisplayToLogical(), ROUTINENAMEGet(), ROUTINENAMEIsValid(), ROUTINENAMELogicalToDisplay(), ROUTINENAMELogicalToOdbc(), ROUTINENAMENormalize(), ROUTINENAMESet()
property ROUTINESCHEMA as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = ROUTINE_SCHEMA , Required ];
Name of schema that contains the routine, same as SPECIFIC_SCHEMA.
Property methods: ROUTINESCHEMADisplayToLogical(), ROUTINESCHEMAGet(), ROUTINESCHEMAIsValid(), ROUTINESCHEMALogicalToDisplay(), ROUTINESCHEMALogicalToOdbc(), ROUTINESCHEMANormalize(), ROUTINESCHEMASet()
property ROUTINETYPE as %String (MAXLEN = 9, VALUELIST = ",PROCEDURE,FUNCTION") [ SqlFieldName = ROUTINE_TYPE ];
The values of ROUTINE_TYPE have the following meanings:
- PROCEDURE - The SQL-invoked routine is a query projected as a procedure.
- FUNCTION - The SQL-invoked routine is a function (method) projected as a procedure.
Property methods: ROUTINETYPEDisplayToLogical(), ROUTINETYPEGet(), ROUTINETYPEIsValid(), ROUTINETYPELogicalToDisplay(), ROUTINETYPELogicalToOdbc(), ROUTINETYPENormalize(), ROUTINETYPESet()
property SCHEMALEVELROUTINE as %String (MAXLEN = 3, VALUELIST = ",YES,NO") [ Calculated , SqlFieldName = SCHEMA_LEVEL_ROUTINE , Required ];
The values of SCHEMA_LEVEL_ROUTINE have the following meanings:
- YES - If the routine is a schema-level routine.
- NO - If the routine is not a schema-level routine.
Property methods: SCHEMALEVELROUTINECompute(), SCHEMALEVELROUTINEDisplayToLogical(), SCHEMALEVELROUTINEGet(), SCHEMALEVELROUTINEIsValid(), SCHEMALEVELROUTINELogicalToDisplay(), SCHEMALEVELROUTINELogicalToOdbc(), SCHEMALEVELROUTINENormalize(), SCHEMALEVELROUTINESQLCompute()
property SECURITYTYPE as %String (MAXLEN = 22, VALUELIST = ",DEFINER,INVOKER,IMPLEMENTATION DEFINED") [ Calculated , SqlFieldName = SECURITY_TYPE ];
The values of SECURITY_TYPE have the following meanings:
- DEFINER - The routine has the security characteristic DEFINER.
- INVOKER - The routine has the security characteristic INVOKER.
- IMPLEMENTATION DEFINED - The external routine has the security characteristic IMPLEMENTATION DEFINED.
- null - Unknown security type.
Property methods: SECURITYTYPECompute(), SECURITYTYPEDisplayToLogical(), SECURITYTYPEGet(), SECURITYTYPEIsValid(), SECURITYTYPELogicalToDisplay(), SECURITYTYPELogicalToOdbc(), SECURITYTYPENormalize(), SECURITYTYPESQLCompute()
property SPECIFICCATALOG as %String (MAXLEN = 128) [ Calculated , SqlFieldName = SPECIFIC_CATALOG ];
Reserved for future use. Specific qualifier - always NULL in InterSystems IRIS.
Property methods: SPECIFICCATALOGCompute(), SPECIFICCATALOGDisplayToLogical(), SPECIFICCATALOGGet(), SPECIFICCATALOGIsValid(), SPECIFICCATALOGLogicalToDisplay(), SPECIFICCATALOGLogicalToOdbc(), SPECIFICCATALOGNormalize(), SPECIFICCATALOGSQLCompute()
property SPECIFICNAME as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = SPECIFIC_NAME , Required ];
Specific name.
Property methods: SPECIFICNAMEDisplayToLogical(), SPECIFICNAMEGet(), SPECIFICNAMEIsValid(), SPECIFICNAMELogicalToDisplay(), SPECIFICNAMELogicalToOdbc(), SPECIFICNAMENormalize(), SPECIFICNAMESet()
property SPECIFICSCHEMA as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = SPECIFIC_SCHEMA , Required ];
Name of schema that contains the routine.
Property methods: SPECIFICSCHEMADisplayToLogical(), SPECIFICSCHEMAGet(), SPECIFICSCHEMAIsValid(), SPECIFICSCHEMALogicalToDisplay(), SPECIFICSCHEMALogicalToOdbc(), SPECIFICSCHEMANormalize(), SPECIFICSCHEMASet()
property SQLDATAACCESS as %String (MAXLEN = 17, VALUELIST = ",NO SQL,CONTAINS SQL,READS SQL DATA,MODIFIES SQL DATA") [ Calculated , SqlFieldName = SQL_DATA_ACCESS ];
SQL_DATA_ACCESS Returns one of the following values:
- NO SQL = Function does not contain SQL.
- CONTAINS SQL = Function possibly contains SQL.
- READS SQL DATA = Function possibly reads SQL data.
- MODIFIES SQL DATA = Function possibly modifies SQL data.
Property methods: SQLDATAACCESSCompute(), SQLDATAACCESSDisplayToLogical(), SQLDATAACCESSGet(), SQLDATAACCESSIsValid(), SQLDATAACCESSLogicalToDisplay(), SQLDATAACCESSLogicalToOdbc(), SQLDATAACCESSNormalize(), SQLDATAACCESSSQLCompute()
property SQLPATH as %String (MAXLEN = 3) [ Calculated , SqlFieldName = SQL_PATH ];
Reserved for future use. For InterSystems IRIS, SQL_PATH is always NULL.
Property methods: SQLPATHCompute(), SQLPATHDisplayToLogical(), SQLPATHGet(), SQLPATHIsValid(), SQLPATHLogicalToDisplay(), SQLPATHLogicalToOdbc(), SQLPATHNormalize(), SQLPATHSQLCompute()
property TOSQLSPECIFICCATALOG as %String (MAXLEN = 3) [ Calculated , SqlFieldName = TO_SQL_SPECIFIC_CATALOG ];
Reserved for future use. For InterSystems IRIS, TO_SQL_SPECIFIC_CATALOG is always NULL.
Property methods: TOSQLSPECIFICCATALOGCompute(), TOSQLSPECIFICCATALOGDisplayToLogical(), TOSQLSPECIFICCATALOGGet(), TOSQLSPECIFICCATALOGIsValid(), TOSQLSPECIFICCATALOGLogicalToDisplay(), TOSQLSPECIFICCATALOGLogicalToOdbc(), TOSQLSPECIFICCATALOGNormalize(), TOSQLSPECIFICCATALOGSQLCompute()
property TOSQLSPECIFICNAME as %String (MAXLEN = 3) [ Calculated , SqlFieldName = TO_SQL_SPECIFIC_NAME ];
Reserved for future use. For InterSystems IRIS, TO_SQL_SPECIFIC_NAME is always NULL.
Property methods: TOSQLSPECIFICNAMECompute(), TOSQLSPECIFICNAMEDisplayToLogical(), TOSQLSPECIFICNAMEGet(), TOSQLSPECIFICNAMEIsValid(), TOSQLSPECIFICNAMELogicalToDisplay(), TOSQLSPECIFICNAMELogicalToOdbc(), TOSQLSPECIFICNAMENormalize(), TOSQLSPECIFICNAMESQLCompute()
property TOSQLSPECIFICSCHEMA as %String (MAXLEN = 3) [ Calculated , SqlFieldName = TO_SQL_SPECIFIC_SCHEMA ];
Reserved for future use. For InterSystems IRIS, TO_SQL_SPECIFIC_SCHEMA is always NULL.
Property methods: TOSQLSPECIFICSCHEMACompute(), TOSQLSPECIFICSCHEMADisplayToLogical(), TOSQLSPECIFICSCHEMAGet(), TOSQLSPECIFICSCHEMAIsValid(), TOSQLSPECIFICSCHEMALogicalToDisplay(), TOSQLSPECIFICSCHEMALogicalToOdbc(), TOSQLSPECIFICSCHEMANormalize(), TOSQLSPECIFICSCHEMASQLCompute()
property USERDEFINEDTYPECATALOG as %String (MAXLEN = 3) [ Calculated , SqlFieldName = USER_DEFINED_TYPE_CATALOG ];
Reserved for future use. For InterSystems IRIS, USER_DEFINED_TYPE_CATALOG is always NULL.
Property methods: USERDEFINEDTYPECATALOGCompute(), USERDEFINEDTYPECATALOGDisplayToLogical(), USERDEFINEDTYPECATALOGGet(), USERDEFINEDTYPECATALOGIsValid(), USERDEFINEDTYPECATALOGLogicalToDisplay(), USERDEFINEDTYPECATALOGLogicalToOdbc(), USERDEFINEDTYPECATALOGNormalize(), USERDEFINEDTYPECATALOGSQLCompute()
property USERDEFINEDTYPENAME as %String (MAXLEN = 3) [ Calculated , SqlFieldName = USER_DEFINED_TYPE_NAME ];
Reserved for future use. For InterSystems IRIS, USER_DEFINED_TYPE_NAME is always NULL.
Property methods: USERDEFINEDTYPENAMECompute(), USERDEFINEDTYPENAMEDisplayToLogical(), USERDEFINEDTYPENAMEGet(), USERDEFINEDTYPENAMEIsValid(), USERDEFINEDTYPENAMELogicalToDisplay(), USERDEFINEDTYPENAMELogicalToOdbc(), USERDEFINEDTYPENAMENormalize(), USERDEFINEDTYPENAMESQLCompute()
property USERDEFINEDTYPESCHEMA as %String (MAXLEN = 3) [ Calculated , SqlFieldName = USER_DEFINED_TYPE_SCHEMA ];
Reserved for future use. For InterSystems IRIS, USER_DEFINED_TYPE_SCHEMA is always NULL.
Property methods: USERDEFINEDTYPESCHEMACompute(), USERDEFINEDTYPESCHEMADisplayToLogical(), USERDEFINEDTYPESCHEMAGet(), USERDEFINEDTYPESCHEMAIsValid(), USERDEFINEDTYPESCHEMALogicalToDisplay(), USERDEFINEDTYPESCHEMALogicalToOdbc(), USERDEFINEDTYPESCHEMANormalize(), USERDEFINEDTYPESCHEMASQLCompute()
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %AddToSyncSet()
- %BuildDeferredIndices()
- %BuildIndicesAsync()
- %BuildIndicesAsyncResponse()
- %CheckConstraints()
- %CheckConstraintsForExtent()
- %ClassIsLatestVersion()
- %ClassName()
- %ComposeOid()
- %ConstructClone()
- %Delete()
- %DeleteExtent()
- %DeleteId()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Exists()
- %ExistsId()
- %Extends()
- %GUID()
- %GUIDSet()
- %GetLock()
- %GetParameter()
- %GetSwizzleObject()
- %Id()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %LockExtent()
- %LockId()
- %New()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnBeforeAddToSync()
- %OnDeleteFinally()
- %OnDetermineClass()
- %OnOpenFinally()
- %OnSaveFinally()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
- %ValidateTable()
Storage
Gray indicates storage defined by superclasses.
Storage Model: SQLStorage
Maps: 1
Map number 1 is named Master
thismap.Global: ^oddPROC
^oddPROC({SchemaUpper},{TableUpper})
|
= |
|