Skip to main content

%SQL.DICT.RoutineColumn

SQL Table Name: %SQL_DICT.RoutineColumn

Property Inventory

Parameters

parameter READONLY = 1;
READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties

property PARM as array of %String);
Property methods: PARMBuildValueArray(), PARMCollectionToDisplay(), PARMCollectionToOdbc(), PARMDisplayToCollection(), PARMDisplayToLogical(), PARMGet(), PARMGetObject(), PARMGetObjectId(), PARMGetStored(), PARMGetSwizzled(), PARMIsValid(), PARMLogicalToDisplay(), PARMLogicalToOdbc(), PARMNormalize(), PARMOdbcToCollection(), PARMSet(), PARMSetObject(), PARMSetObjectId()
property attribute as %String);
Property methods: attributeDisplayToLogical(), attributeGet(), attributeGetStored(), attributeIsValid(), attributeLogicalToDisplay(), attributeLogicalToOdbc(), attributeNormalize(), attributeSet()
property bitstring as %String);
Property methods: bitstringDisplayToLogical(), bitstringGet(), bitstringGetStored(), bitstringIsValid(), bitstringLogicalToDisplay(), bitstringLogicalToOdbc(), bitstringNormalize(), bitstringSet()
property caption as %String);
Property methods: captionDisplayToLogical(), captionGet(), captionGetStored(), captionIsValid(), captionLogicalToDisplay(), captionLogicalToOdbc(), captionNormalize(), captionSet()
property class as %String);
Property methods: classDisplayToLogical(), classGet(), classGetStored(), classIsValid(), classLogicalToDisplay(), classLogicalToOdbc(), classNormalize(), classSet()
property clientdatatypeenum as %String);
Property methods: clientdatatypeenumDisplayToLogical(), clientdatatypeenumGet(), clientdatatypeenumGetStored(), clientdatatypeenumIsValid(), clientdatatypeenumLogicalToDisplay(), clientdatatypeenumLogicalToOdbc(), clientdatatypeenumNormalize(), clientdatatypeenumSet()
property colinfo as %String);
Property methods: colinfoDisplayToLogical(), colinfoGet(), colinfoGetStored(), colinfoIsValid(), colinfoLogicalToDisplay(), colinfoLogicalToOdbc(), colinfoNormalize(), colinfoSet()
property colinfoV as %String);
Property methods: colinfoVDisplayToLogical(), colinfoVGet(), colinfoVGetStored(), colinfoVIsValid(), colinfoVLogicalToDisplay(), colinfoVLogicalToOdbc(), colinfoVNormalize(), colinfoVSet()
property datatype as %String);
Property methods: datatypeDisplayToLogical(), datatypeGet(), datatypeGetStored(), datatypeIsValid(), datatypeLogicalToDisplay(), datatypeLogicalToOdbc(), datatypeNormalize(), datatypeSet()
property defaultValue as %String);
Property methods: defaultValueDisplayToLogical(), defaultValueGet(), defaultValueGetStored(), defaultValueIsValid(), defaultValueLogicalToDisplay(), defaultValueLogicalToOdbc(), defaultValueNormalize(), defaultValueSet()
property length as %Integer;
Property methods: lengthDisplayToLogical(), lengthGet(), lengthGetStored(), lengthIsValid(), lengthLogicalToDisplay(), lengthNormalize(), lengthSet()
property name as %String);
Property methods: nameDisplayToLogical(), nameGet(), nameGetStored(), nameIsValid(), nameLogicalToDisplay(), nameLogicalToOdbc(), nameNormalize(), nameSet()
property nullable as %String);
Property methods: nullableDisplayToLogical(), nullableGet(), nullableGetStored(), nullableIsValid(), nullableLogicalToDisplay(), nullableLogicalToOdbc(), nullableNormalize(), nullableSet()
property odbctype as %String);
Property methods: odbctypeDisplayToLogical(), odbctypeGet(), odbctypeGetStored(), odbctypeIsValid(), odbctypeLogicalToDisplay(), odbctypeLogicalToOdbc(), odbctypeNormalize(), odbctypeSet()
property odbctypename as %String);
Property methods: odbctypenameDisplayToLogical(), odbctypenameGet(), odbctypenameGetStored(), odbctypenameIsValid(), odbctypenameLogicalToDisplay(), odbctypenameLogicalToOdbc(), odbctypenameNormalize(), odbctypenameSet()
property precision as %Integer;
Property methods: precisionDisplayToLogical(), precisionGet(), precisionGetStored(), precisionIsValid(), precisionLogicalToDisplay(), precisionNormalize(), precisionSet()
property procinfo as %String);
Property methods: procinfoDisplayToLogical(), procinfoGet(), procinfoGetStored(), procinfoIsValid(), procinfoLogicalToDisplay(), procinfoLogicalToOdbc(), procinfoNormalize(), procinfoSet()
property radix as %String);
Property methods: radixDisplayToLogical(), radixGet(), radixGetStored(), radixIsValid(), radixLogicalToDisplay(), radixLogicalToOdbc(), radixNormalize(), radixSet()
property remarks as %String);
Property methods: remarksDisplayToLogical(), remarksGet(), remarksGetStored(), remarksIsValid(), remarksLogicalToDisplay(), remarksLogicalToOdbc(), remarksNormalize(), remarksSet()
relationship routine as %SQL.DICT.Routine [ Required , Inverse = columns , Cardinality = parent ];
Property methods: routineGet(), routineGetObject(), routineGetObjectId(), routineGetStored(), routineGetSwizzled(), routineIsValid(), routineNewObject(), routineOnDelete(), routineRClose(), routineRExec(), routineRFetch(), routineRelate(), routineSQLCompute(), routineSet(), routineSetObject(), routineSetObjectId(), routineUnRelate(), routineUnSwizzle()
property scale as %Integer;
Property methods: scaleDisplayToLogical(), scaleGet(), scaleGetStored(), scaleIsValid(), scaleLogicalToDisplay(), scaleNormalize(), scaleSet()
property schemaName as %String);
Property methods: schemaNameDisplayToLogical(), schemaNameGet(), schemaNameGetStored(), schemaNameIsValid(), schemaNameLogicalToDisplay(), schemaNameLogicalToOdbc(), schemaNameNormalize(), schemaNameSet()
property subquery as %String);
Property methods: subqueryDisplayToLogical(), subqueryGet(), subqueryGetStored(), subqueryIsValid(), subqueryLogicalToDisplay(), subqueryLogicalToOdbc(), subqueryNormalize(), subquerySet()
property tablename as %String);
Property methods: tablenameDisplayToLogical(), tablenameGet(), tablenameGetStored(), tablenameIsValid(), tablenameLogicalToDisplay(), tablenameLogicalToOdbc(), tablenameNormalize(), tablenameSet()
property type as %String (DISPLAYLIST = ",UNKNOWN,INPUT,INPUTOUTPUT,RESULTCOL,OUTPUT,RETURNVALUE", VALUELIST = ",0,1,2,3,4,5");
Defines for SQLBindParameter and SQLProcedureColumns SQLPARAMTYPEUNKNOWN 0 SQLPARAMINPUT 1 SQLPARAMINPUTOUTPUT 2 SQLRESULTCOL 3 SQLPARAMOUTPUT 4 SQLRETURNVALUE 5
Property methods: typeDisplayToLogical(), typeGet(), typeGetStored(), typeIsValid(), typeLogicalToDisplay(), typeLogicalToOdbc(), typeNormalize(), typeSet()

Indexes

index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,"P",n)
=
PARM(n)

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,1)
=
attribute

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,21)
=
bitstring

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,15)
=
caption

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,16)
=
class

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,17)
=
clientdatatypeenum

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,2)
=
colinfo

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID)
=
colinfoV

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,3)
=
datatype

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,22)
=
defaultValue

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,4)
=
length

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,5)
=
name

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,6)
=
nullable

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,7)
=
odbctype

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,8)
=
odbctypename

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,9)
=
precision

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,10)
=
procinfo

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,11)
=
radix

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,12)
=
remarks

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,13)
=
scale

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,18)
=
schemaName

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,20)
=
subquery

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,19)
=
tablename

Storage Model: CacheStorage (%SQL.DICT.RoutineColumn)

{%%PARENT}("c")(ID,14)
=
type
FeedbackOpens in a new tab