oracle.odi.mapping.generation

Class SetQuery

java.lang.Object

oracle.odi.mapping.generation.AbstractSyntaxTree

oracle.odi.mapping.generation.QueryClause

oracle.odi.mapping.generation.SqlQuery

oracle.odi.mapping.generation.SetQuery

All Implemented Interfaces:

ITableFunctionParameter, SqlStatement

public class SetQuery
extends SqlQuery
implements SqlStatement

SetQuery is the substitution API class used for set operation.
It holds a collection of SqlQuery (the queries that will be union-ed), a collection of columns alias, a set operation type and a set alias. All these values are used to generation the subquery.

Nested Class Summary

Nested classes/interfaces inherited from class oracle.odi.mapping.generation.AbstractSyntaxTree

AbstractSyntaxTree.LogCounter

Method Summary

Modifier and Type	Method and Description
java.util.List	getChildren() Get the list of child objects owned by this substitution API object.
SqlQuery	getInputQuery(int index) Get the input query corresponding to the given index.
int	getInputQueryCount() Return the number of input queries.
java.lang.String	getSetAlias() Get the set alias
java.util.List	getSetOperationTypes() Retrieve the set operation types list
java.util.Collection	getSourceTables() Get all source tables involved in this query.
java.lang.String	getType() Get a class type string for this substitution API object.
boolean	isSubqueryRequired() Return true if this set query needs to be generated as a sub-query

Methods inherited from class oracle.odi.mapping.generation.SqlQuery

addJoin, getAliasList, getColumnAliasSeparator, getConstantFromClauseText, getConstantFromClauseText, getExpressionColumn, getExpressions, getFromList, getGroupByList, getHavingList, getJournalizedSource, getLateralViewList, getNonOrderedComponents, getOrderByList, getQuerySourceComponent, getSelectHints, getSelectList, getSetOperand, getSetOperation, getSourceColumns, getSourceLocation, getSourceTable, getSourceTables, getSubqueries, getTemplateSubstitutionMap, getText, getWhereList, hasAggregation, hasFilterWithAggregation, hasJournalizedSource, hasNonOrderedJoin, hasSourceReference, hasWindowFunction, hasWindowFunction, isANSI, isConstantQuery, isDistinct, isPassive, isPivot, isScalarTableFunctionWithAggregate, isStagingQuery, isSubquery, toString

Methods inherited from class oracle.odi.mapping.generation.QueryClause

getParentQuery

Methods inherited from class oracle.odi.mapping.generation.AbstractSyntaxTree

getCodeGenerationTemplate, getCodeGenerationTemplateName, getCustomTemplate, getKMName, getLeafLevelChildren, getMapPhysicalNode, getOrder, getParentAST, getParentOfType, getPropertyValue, getSourceLanguage, getSourceTechnology, getSourceText, getTargetLanguage, getTargetLocation, getTargetTechnology, getTargetText, hasCustomTemplate, hasSourceAndTargetText, isLeafLevelNode, isPushFromSource

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface oracle.odi.mapping.generation.ITableFunctionParameter

getParentAST

Method Detail

getSetAlias

public java.lang.String getSetAlias()

Get the set alias

Returns:

getSetOperationTypes

public java.util.List getSetOperationTypes()

Retrieve the set operation types list

Returns:

isSubqueryRequired

public boolean isSubqueryRequired()

Return true if this set query needs to be generated as a sub-query

Returns:

getType

public java.lang.String getType()

Description copied from class: AbstractSyntaxTree

Get a class type string for this substitution API object.

Overrides:

getType in class SqlQuery

Returns:

A simple class type name for this object.

getChildren

public java.util.List getChildren()

Description copied from class: AbstractSyntaxTree

Get the list of child objects owned by this substitution API object.

Specified by:

getChildren in interface ITableFunctionParameter

Overrides:

getChildren in class SqlQuery

Returns:

The list of child objects.

getSourceTables

public java.util.Collection getSourceTables()

Description copied from class: SqlQuery

Get all source tables involved in this query.

Overrides:

getSourceTables in class SqlQuery

Returns:

List of source tables.

getInputQuery

public SqlQuery getInputQuery(int index)
                       throws GenerationException

Get the input query corresponding to the given index.

Overrides:

getInputQuery in class SqlQuery

Parameters:

index - The index of the query.

Returns:

This query.

Throws:

GenerationException

getInputQueryCount

public int getInputQueryCount()

Return the number of input queries.

Overrides:

getInputQueryCount in class SqlQuery

Returns:

The number of input queries used to form the set query.