SAS Namespace Types

Select

Overview

The type is used to document an SQL Select statement.

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.

Steps

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 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 , 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

Top of Page