Home > Class Reference > ENSLIB namespace > %SQL.StatementColumn

%SQL.StatementColumn

serial class %SQL.StatementColumn extends %Library.SerialObject

%SQL.StatementColumn - contains the metadata for a statement column whose column type is SQLRESULTCOL.

Property Inventory (Including Private)

Method Inventory (Including Private)

Properties (Including Private)

property ODBCType as %Integer;
The column ODBC type integer:
Property methods: ODBCTypeDisplayToLogical(), ODBCTypeGet(), ODBCTypeIsValid(), ODBCTypeLogicalToDisplay(), ODBCTypeNormalize(), ODBCTypeSet()
property clientType as %Integer;
Returns the type of column n in the result set where type is an integer associated with the client datatype. If the type cannot be determined, 0 (zero) is returned.
1BINARY
2DATE
3DOUBLE
4HANDLE
5INTEGER
6LIST
7LONGVARCHAR
8TIME
9TIMESTAMP
10VARCHAR
11STATUS
12BINARYSTREAM
13CHARACTERSTREAM
14NUMERIC
15CURRENCY
16BOOLEAN
17OID
18BIGINT
19FDATE
20FTIMESTAMP
Property methods: clientTypeDisplayToLogical(), clientTypeGet(), clientTypeIsValid(), clientTypeLogicalToDisplay(), clientTypeNormalize(), clientTypeSet()
property colName as %String (MAXLEN = 255);
The column name.
Property methods: colNameDisplayToLogical(), colNameGet(), colNameIsValid(), colNameLogicalToDisplay(), colNameLogicalToOdbc(), colNameNormalize(), colNameSet()
property isAliased as %Boolean;
Property methods: isAliasedDisplayToLogical(), isAliasedGet(), isAliasedIsValid(), isAliasedLogicalToDisplay(), isAliasedNormalize(), isAliasedSet()
property isAutoIncrement as %Boolean;
Property methods: isAutoIncrementDisplayToLogical(), isAutoIncrementGet(), isAutoIncrementIsValid(), isAutoIncrementLogicalToDisplay(), isAutoIncrementNormalize(), isAutoIncrementSet()
property isCaseSensitive as %Boolean;
Property methods: isCaseSensitiveDisplayToLogical(), isCaseSensitiveGet(), isCaseSensitiveIsValid(), isCaseSensitiveLogicalToDisplay(), isCaseSensitiveNormalize(), isCaseSensitiveSet()
property isCurrency as %Boolean;
Property methods: isCurrencyDisplayToLogical(), isCurrencyGet(), isCurrencyIsValid(), isCurrencyLogicalToDisplay(), isCurrencyNormalize(), isCurrencySet()
property isExpression as %Boolean;
Property methods: isExpressionDisplayToLogical(), isExpressionGet(), isExpressionIsValid(), isExpressionLogicalToDisplay(), isExpressionNormalize(), isExpressionSet()
property isHidden as %Boolean;
Property methods: isHiddenDisplayToLogical(), isHiddenGet(), isHiddenIsValid(), isHiddenLogicalToDisplay(), isHiddenNormalize(), isHiddenSet()
property isIdentity as %Boolean;
Property methods: isIdentityDisplayToLogical(), isIdentityGet(), isIdentityIsValid(), isIdentityLogicalToDisplay(), isIdentityNormalize(), isIdentitySet()
property isKeyColumn as %Boolean;
Property methods: isKeyColumnDisplayToLogical(), isKeyColumnGet(), isKeyColumnIsValid(), isKeyColumnLogicalToDisplay(), isKeyColumnNormalize(), isKeyColumnSet()
property isNullable as %Boolean;
isNullable is TRUE (1) if the column value can be NULL.
Property methods: isNullableDisplayToLogical(), isNullableGet(), isNullableIsValid(), isNullableLogicalToDisplay(), isNullableNormalize(), isNullableSet()
property isReadOnly as %Boolean;
Property methods: isReadOnlyDisplayToLogical(), isReadOnlyGet(), isReadOnlyIsValid(), isReadOnlyLogicalToDisplay(), isReadOnlyNormalize(), isReadOnlySet()
property isRowId as %Boolean;
Property methods: isRowIdDisplayToLogical(), isRowIdGet(), isRowIdIsValid(), isRowIdLogicalToDisplay(), isRowIdNormalize(), isRowIdSet()
property isRowVersion as %Boolean;
Property methods: isRowVersionDisplayToLogical(), isRowVersionGet(), isRowVersionIsValid(), isRowVersionLogicalToDisplay(), isRowVersionNormalize(), isRowVersionSet()
property isUnique as %Boolean;
Property methods: isUniqueDisplayToLogical(), isUniqueGet(), isUniqueIsValid(), isUniqueLogicalToDisplay(), isUniqueNormalize(), isUniqueSet()
property label as %String (MAXLEN = 255);
Property methods: labelDisplayToLogical(), labelGet(), labelIsValid(), labelLogicalToDisplay(), labelLogicalToOdbc(), labelNormalize(), labelSet()
property precision as %Integer;
Precision
Property methods: precisionDisplayToLogical(), precisionGet(), precisionIsValid(), precisionLogicalToDisplay(), precisionNormalize(), precisionSet()
property property as %Dictionary.CompiledProperty;
If this column corresponds to a property from the class that projected the tableName table. This property is NULL if the column cannot be linked to a property.
Property methods: propertyGet(), propertyGetObject(), propertyGetObjectId(), propertyGetSwizzled(), propertyIsValid(), propertyNewObject(), propertySet(), propertySetObject(), propertySetObjectId(), propertyUnSwizzle()
property qualifier as %String;
Property methods: qualifierDisplayToLogical(), qualifierGet(), qualifierIsValid(), qualifierLogicalToDisplay(), qualifierLogicalToOdbc(), qualifierNormalize(), qualifierSet()
property scale as %Integer;
Scale
Property methods: scaleDisplayToLogical(), scaleGet(), scaleIsValid(), scaleLogicalToDisplay(), scaleNormalize(), scaleSet()
property schemaName as %String;
The schema qualifier of tableName.
Property methods: schemaNameDisplayToLogical(), schemaNameGet(), schemaNameIsValid(), schemaNameLogicalToDisplay(), schemaNameLogicalToOdbc(), schemaNameNormalize(), schemaNameSet()
property tableName as %String;