space
Previous Page | Next Page

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 list of associations is used to determine if this object should inherit access controls from another object (inheritance), or if the association is allowed for the object (enforcement). An association will not be created unless the calling user is authorized to update one or both objects involved in the association. For more information about inheritance and enforcement rules, see the SAS Intelligence Platform: Security Administration Guide.

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. This is an integer value that indicates the SQL type. int  
SASFormat This attribute contains the SAS format associated with this column.   String 43  
SASInformat This attribute contains the SAS informat associated with this column.   String 43  

Inherited Attributes
Name, Id, Desc, MetadataCreated, MetadataUpdated, ChangeState, IsHidden, LockedBy, PublicType, UsageVersion

Associations

Inherited Associations
AccessControls/Objects, Changes/Objects, CustomAssociations/OwningObject, Documents/Objects, Extensions/OwningObject, ExternalIdentities/OwningObject, FavoritesContainers/Favorites, 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 43  

    This attribute contains the SAS format associated with this column.

    SASInformat
         Type:  String 43  

    This attribute contains the SAS informat associated with this column.

    Previous Page | Next Page | Top of Page