space
Previous Page | Next Page

SAS Namespace Types

Select


Subclass of ClassifierMap


Overview

Used to document an SQL Select statement.

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
IsParseAllowed If true then the query visuals should attempt to parse and display the query in a GUI manner. This provides a way to prevent incorrect parsing of a query.   int  
IsSubstitutionAllowed If true then we may need to substitute physical names on the input sources before the query can be run. If true then this also implies that all of the inputs are maintained and correct. This would likely be set to false by any process that does not understand the query's variable mechanism.   int  

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

Associations

= indicates the resident side of an association, or where the association is persisted for cross-repository associations. If no resident side is indicated, this association may not cross repository boundaries.
Name Cardinality Description Associated Types
GroupByForSelect

Partner: OwningSelect

0 to 1 The GroupBy statement for the select object.   GroupByClause
HavingForSelect

Partner: OwningSelect

0 to 1 The Having statement of this select object. HavingClause
OrderByForSelect

Partner: OwningSelect

0 to 1 The OrderBy statement of the select object.   OrderByClause
WhereForSelect

Partner: OwningSelect

0 to 1 The Where clause for this select object. WhereClause

Inherited Associations
AccessControls/Objects, AssociatedPrompt/ValueSource, AssociatedRowSelector/OwningClassifierMap, Changes/Objects, ClassifierSources/SourceClassifierMaps, ClassifierTargets/TargetClassifierMaps, ComputeLocations/ComputeTasks, ConditionActionSets/AssociatedTransformation, CustomAssociations/OwningObject, Customizers/CustomizedTransformations, DeployedComponents/InitProcesses, Documents/Objects, Extensions/OwningObject, ExternalIdentities/OwningObject, FavoritesContainers/Favorites, FeatureMaps/AssociatedClassifierMap, Groups/Members, Implementors/ImplementedObjects, Keywords/Objects, LocalizedAttributes/AssociatedLocalizedObject, Notes/Objects, PrimaryPropertyGroup/AssociatedObject, Prompts/PromptEnabledObject, Properties/AssociatedObject, PropertySets/OwningObject, ReferencedObjects/AssociatedObjects, ResponsibleParties/Objects, SourceCode/AssociatedTransformation, SourceSpecifications/SpecSourceTransformations, SourceTransformations/TransformationSources, SpecSourceTransformations/SourceSpecifications, SpecTargetTransformations/TargetSpecifications, Steps/Transformations, SubstitutionVariables/OwningTransformation, TargetSpecifications/SpecTargetTransformations, TargetTransformations/TransformationTargets, Timestamps/Objects, TransformationSources/SourceTransformations, TransformationTargets/TargetTransformations, Trees/Members, TriggeredEvents/TriggeringTransforms, TriggeringEvents/TriggeredTransforms, TSObjectNamespace/TSObjects, UsedByPrototypes/UsingPrototype, UsingPrototype/UsedByPrototypes, Variables/AssociatedObject

Attribute Details

IsParseAllowed
     Type:  int  

If true then the query visuals should attempt to parse and display the query in a GUI manner. This provides a way to prevent incorrect parsing of a query.

IsSubstitutionAllowed
     Type:  int  

If true then we may need to substitute physical names on the input sources before the query can be run. If true then this also implies that all of the inputs are maintained and correct. This would likely be set to false by any process that does not understand the query's variable mechanism.

Association Details

GroupByForSelect
     Cardinality:   0 to 1
     Partner:   OwningSelect

The GroupBy statement for the select object. 

Associated Types:
GroupByClause

HavingForSelect
     Cardinality:   0 to 1
     Partner:   OwningSelect

The Having statement of this select object. 

Associated Types:
HavingClause

OrderByForSelect
     Cardinality:   0 to 1
     Partner:   OwningSelect

The OrderBy statement of the select object. 

Associated Types:
OrderByClause

WhereForSelect
     Cardinality:   0 to 1
     Partner:   OwningSelect

The Where clause for this select object. 

Associated Types:
WhereClause

Previous Page | Next Page | Top of Page