SAS Namespace Types

LogicalColumn

Subclass of Feature

Subtypes

Overview

The supertype for Column, which is part of a relational table, and Measure, which is used with OLAP types.

Security Inheritance and Enforcement Rules

The following is a list of associations that are used to determine if this object should inherit access controls from another object (inheritance) or if the association is allowed for the object (enforcement). For more information about inheritance and enforcement rules, see the SAS 9.2 Intelligence Platform: Security Administration Guide.

Trees

Attributes

Name	Description	Type	Length
ColumnLength	This attribute contains the length of the column. When this type is used to represent a physical column in a DBMS, the length is the DBMS length value. The SASColumnLength should be the same as this value, unless the length is too long and will be truncated by SAS software.	int
ColumnName	This attribute is the name of the column as it is defined in a DBMS. ColumnName will often be set to match the value for SASColumnName. This attribute is not used by SAS Data Integration Studio.	String	256
ColumnType	The type of the column as defined in the DBMS.	int
SASFormat	This attribute contains the SAS format associated with this column.	String	32
SASInformat	This attribute contains the SAS informat associated with this column.	String	32

Inherited Attributes
Name Id Desc MetadataCreated MetadataUpdated ChangeState LockedBy PublicType UsageVersion

Associations

Inherited Associations
AccessControls/Objects , Changes/Objects , CustomAssociations/OwningObject , Documents/Objects , Extensions/OwningObject , ExternalIdentities/OwningObject , Groups/Members , Implementors/ImplementedObjects , Keywords/Objects , LocalizedAttributes/AssociatedLocalizedObject , Notes/Objects , PrimaryPropertyGroup/AssociatedObject , Prompts/PromptEnabledObject , Properties/AssociatedObject , PropertySets/OwningObject , ReferencedObjects/AssociatedObjects , ResponsibleParties/Objects , SourceFeatureMaps/FeatureSources , SourceTransformations/TransformationSources , SpecSourceTransformations/SourceSpecifications , SpecTargetTransformations/TargetSpecifications , TargetFeatureMaps/FeatureTargets , TargetTransformations/TransformationTargets , Timestamps/Objects , Trees/Members , TSObjectNamespace/TSObjects , UsedByPrototypes/UsingPrototype , UsingPrototype/UsedByPrototypes , Variables/AssociatedObject

Attribute Details

ColumnLength
     Type: int
This attribute contains the length of the column. When this type is used to represent a physical column in a DBMS, the length is the DBMS length value. The SASColumnLength should be the same as this value, unless the length is too long and will be truncated by SAS software.

ColumnName
     Type: String 256
This attribute is the name of the column as it is defined in a DBMS. ColumnName will often be set to match the value for SASColumnName. This attribute is not used by SAS Data Integration Studio.

ColumnType
     Type: int
The type of the column as defined in the DBMS. This is an integer value that indicates the SQL type.

ARRAY = 2003

BIGINT = -5

BINARY = -2

BIT = -7

BLOB = 2004

CHAR = 1

CLOB = 2005

DATE = 91

DECIMAL = 3

DISTINCT = 2001

DOUBLE = 8

FLOAT = 6

INTEGER = 4

JAVA_OBJECT = 2000

LONGVARBINARY = -4

LONGVARCHAR = -1

NULL = 0

NUMERIC = 2

OTHER = 1111

REAL = 7

REF = 2006

SMALLINT = 5

STRUCT = 2002

TIME = 92

TIMESTAMP = 93

TINYINT = -6

VARBINARY = -3

VARCHAR = 12

SASFormat
     Type: String 32
This attribute contains the SAS format associated with this column.

SASInformat
     Type: String 32
This attribute contains the SAS informat associated with this column.

Top of Page