Skip to main content

INFORMATION.SCHEMA.ROUTINES

persistent class INFORMATION.SCHEMA.ROUTINES extends %Library.Persistent

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

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:
  • 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.
For Caché, AS_LOCATOR is always null unless the return value is a stream, then it is YES.
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 Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché, COLLATION_SCHEMA is always NULL.
Property methods: COLLATIONSCHEMACompute(), COLLATIONSCHEMADisplayToLogical(), COLLATIONSCHEMAGet(), COLLATIONSCHEMAIsValid(), COLLATIONSCHEMALogicalToDisplay(), COLLATIONSCHEMALogicalToOdbc(), COLLATIONSCHEMANormalize(), COLLATIONSCHEMASQLCompute()
property CREATED as %TimeStamp [ Calculated ];
For Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché, 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.
Reserved for future use. For Caché, IS_IMPLICITLY_INVOCABLE is always null.
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.
For Caché, if the routine is a function IS_NULL_CALL is always NO.
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 Caché, 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.
For Caché, if the routine is a function IS_USER_DEFINED_CAST is always NO.
Property methods: ISUSERDEFINEDCASTCompute(), ISUSERDEFINEDCASTDisplayToLogical(), ISUSERDEFINEDCASTGet(), ISUSERDEFINEDCASTIsValid(), ISUSERDEFINEDCASTLogicalToDisplay(), ISUSERDEFINEDCASTLogicalToOdbc(), ISUSERDEFINEDCASTNormalize(), ISUSERDEFINEDCASTSQLCompute()
property LASTALTERED as %TimeStamp [ Calculated , SqlFieldName = LAST_ALTERED ];
For Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché.
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.
For Caché, SCHEMA_LEVEL_ROUTINE is always YES.
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.
For Caché, SECURITY_TYPE is always null.
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 Caché.
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.
Returns CONTAINS SQL for all functions, and READS SQL DATA for all class query procedure.
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 Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché, 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 Caché, USER_DEFINED_TYPE_SCHEMA is always NULL.
Property methods: USERDEFINEDTYPESCHEMACompute(), USERDEFINEDTYPESCHEMADisplayToLogical(), USERDEFINEDTYPESCHEMAGet(), USERDEFINEDTYPESCHEMAIsValid(), USERDEFINEDTYPESCHEMALogicalToDisplay(), USERDEFINEDTYPESCHEMALogicalToOdbc(), USERDEFINEDTYPESCHEMANormalize(), USERDEFINEDTYPESCHEMASQLCompute()

Inherited Members

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

Storage Model: CacheSQLStorage

Maps: 1

  • Map number 1 is named Master

    thismap.Global: ^oddPROC

  • ^oddPROC({SchemaUpper},{TableUpper})
    =
    Node Delimiter Piece Name
    ROUTINE_TYPE
    1 Classname
    10 SPECIFIC_NAME
    14 METHOD_OR_QUERY_NAME
    20 SPECIFIC_SCHEMA
FeedbackOpens in a new tab