public class Join extends GenericClause
| Modifier and Type | Class and Description | 
|---|---|
static class  | 
Join.JoinType
Deprecated. 
 
this class/method belongs to 11g SDK and is deprecated in 12c release.
  
 Types of join of a join clause. 
 | 
| Constructor and Description | 
|---|
Join(DataSet pDataSet)
Deprecated.  
Internal use only 
 | 
Join(DataSet pDataSet,
    java.lang.String pSql,
    boolean pOrdered,
    OdiInterface.ExecutionLocation pExecutionLocation)
Deprecated.  
Internal use only
 Builds a join clause in the parent dataset using the specified SQL
 expression text, clause type (ordered, non-ordered or cross join) and the
 desired execution location. 
 | 
Join(SourceDataStore pSourceDataStore1,
    SourceDataStore pSourceDataStore2,
    OdiInterface.ExecutionLocation pExecutionLocation)
Deprecated.  
Internal use only
 Builds a non-ordered cross join clause in the same dataset as the 
 the two specified source data sources with the desired execution location. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
SourceDataStore | 
getAttachedDataStore1()
Deprecated.  
Returns the source data store attached to the left side of this join. 
 | 
SourceDataStore | 
getAttachedDataStore2()
Deprecated.  
Returns the source data store attached to the right side of this join. 
 | 
java.lang.String | 
getBusinessRule()
Deprecated.  
Returns the business rule description of this clause. 
 | 
java.lang.Number | 
getClauseId()
Deprecated.  
Returns the internal ID of this clause. 
 | 
int | 
getClauseOrder()
Deprecated.  
Returns the clause order of this clause. 
 | 
DataSet | 
getDataSet()
Deprecated.  
Returns the parent dataset of this clause. 
 | 
OdiInterface.ExecutionLocation | 
getExecutionLocation()
Deprecated.  
Returns the execution location of this clause. 
 | 
java.lang.String | 
getGlobalId()
Deprecated.  
Global ID is unique cross repositories. 
 | 
OdiIndexType | 
getIndexType1()
Deprecated.  
Returns the temporary index type used for the left side of this clause. 
 | 
OdiIndexType | 
getIndexType2()
Deprecated.  
Returns the temporary index type used for the right side of this clause. 
 | 
SourceSet | 
getSourceSet()
Deprecated.  
Returns the source set where this clause is executed. 
 | 
java.lang.String | 
getSql()
Deprecated.  
Returns the SQL expression text of this clause. 
 | 
Expression | 
getSqlExpression()
Deprecated.  
Returns the SQL expression of this clause. 
 | 
java.lang.Number | 
getSqlExpressionId()
Deprecated.  
Returns the internal ID of the SQL expression text for this clause. 
 | 
java.lang.String | 
getSubComponentDescription()
Deprecated.  
Returns the sub component's description in a human-readable way. 
 | 
java.lang.String | 
getSubComponentDescription(java.util.Locale pLocale)
Deprecated.  
Returns the sub component's description in a human-readable way for the given Locale. 
 | 
java.lang.String | 
getTechnicalDescription()
Deprecated.  
Returns the technical description of the expression text of this clause. 
 | 
boolean | 
isCross()
Deprecated.  
Returns whether this join is a cross join or not. 
 | 
boolean | 
isEnabled()
Deprecated.  
Returns whether this clause is active and enabled. 
 | 
boolean | 
isLookup()
Deprecated.  
Returns whether this join clause represents a lookup operation or not. 
 | 
boolean | 
isNatural()
Deprecated.  
Returns whether this join is a natural join or not. 
 | 
boolean | 
isOrdered()
Deprecated.  
Returns whether this join clause to an ordered join or not. 
 | 
boolean | 
isOuter1()
Deprecated.  
Returns whether the source data store on the left side of this join is 
 set to be preserving (outer join) or not. 
 | 
boolean | 
isOuter2()
Deprecated.  
Returns whether the source data store on the right side of this join is 
 set to be preserving (outer join) or not. 
 | 
void | 
setAttachedDataStore1(SourceDataStore pAttachedDataStore)
Deprecated.  
Internal use only
 Sets the source data store attached to the left side of this join. 
 | 
void | 
setAttachedDataStore2(SourceDataStore pAttachedDataStore)
Deprecated.  
Internal use only
 Sets the right side of the source data store attached to this join. 
 | 
void | 
setBusinessRule(java.lang.String pBusinessRule)
Deprecated.  
Internal use only
 Set the business rule description of this clause. 
 | 
void | 
setClauseOrder(int pClauseOrder)
Deprecated.  
Internal use only
 Sets the clause order of this clause. 
 | 
void | 
setCross(boolean pCross)
Deprecated.  
Internal use only
 Sets this join clause to be a cross join. 
 | 
void | 
setEnabled(boolean pEnabled)
Deprecated.  
Internal use only
 Sets whether this clause is active and enabled or not. 
 | 
void | 
setExecutionLocation(OdiInterface.ExecutionLocation pExecutionLocation)
Deprecated.  
Internal use only
 Sets the execution location of this clause. 
 | 
void | 
setIndexType1(OdiIndexType pIndexType1)
Deprecated.  
Internal use only
 Set the temporary index type used for the left side of this clause. 
 | 
void | 
setIndexType2(OdiIndexType pIndexType2)
Deprecated.  
Internal use only
 Set the temporary index type used for the right side of this clause. 
 | 
void | 
setIndexTypeCode1(java.lang.String pIndexTypeCode1)
Deprecated.  
Internal use only 
 | 
void | 
setIndexTypeCode2(java.lang.String pIndexTypeCode2)
Deprecated.  
Internal use only 
 | 
void | 
setLookup(boolean pLookup)
Deprecated.  
Internal use only
 Sets whether this join clause represents a lookup operation or not. 
 | 
void | 
setNatural(boolean pNatural)
Deprecated.  
Internal use only
 Sets this join clause to be a natural join. 
 | 
void | 
setOrdered(boolean pOrdered)
Deprecated.  
Sets whether this join clause to be an ordered join. 
 | 
void | 
setOuter1(boolean pOuter1)
Deprecated.  
Internal use only
 Sets whether the source data store on the left side of this join is 
 set to be preserving (outer join) or not. 
 | 
void | 
setOuter2(boolean pOuter2)
Deprecated.  
Internal use only
 Sets whether the source data store on the right side of this join is 
 set to be preserving (outer join) or not. 
 | 
void | 
setSourceSet(SourceSet pSourceSet)
Deprecated.  
Internal use only
 Sets the source set where this clause will be executed. 
 | 
void | 
setSqlExpression(Expression pSqlExpression)
Deprecated.  
Internal use only
 Set the SQL expression for this clause. 
 | 
getInternalId, getNonPersistedSql, getSqlExpressionCrossRefsGlobalIdspublic Join(DataSet pDataSet)
public Join(DataSet pDataSet, java.lang.String pSql, boolean pOrdered, OdiInterface.ExecutionLocation pExecutionLocation)
pDataSet - the parent dataset for this join.pSql - the SQL expression text for this join.pOrdered - true if the join is an ordered
                           join, false otherwise.pExecutionLocation - the execution location of this join.public Join(SourceDataStore pSourceDataStore1, SourceDataStore pSourceDataStore2, OdiInterface.ExecutionLocation pExecutionLocation)
pSourceDataStore1 - the first source data store for cross join.pSourceDataStore2 - the second source data store for cross join.pExecutionLocation - the execution location of this join.public boolean isCross()
true if this join is a cross join,
         false otherwise.setCross(boolean)public void setNatural(boolean pNatural)
pNatural - true to set this join to a natural join,
                 false otherwise.isNatural()public boolean isNatural()
true if this join is a natural join,
         false otherwise.setNatural(boolean)public void setCross(boolean pCross)
pCross - true to set this join to a cross join,
               false otherwise.isCross()public boolean isOrdered()
true if this join is an ordered join,
         false if this join is a non-ordered join.setOrdered(boolean)public void setOrdered(boolean pOrdered)
pOrdered - true if this join is an ordered join,
                 false otherwise.PropertyExceptionisOrdered()public SourceDataStore getAttachedDataStore1()
setAttachedDataStore1(SourceDataStore)public void setAttachedDataStore1(SourceDataStore pAttachedDataStore)
pAttachedDataStore - The source data store attached to the left
                           side of this join.getAttachedDataStore1()public SourceDataStore getAttachedDataStore2()
setAttachedDataStore2(SourceDataStore)public void setAttachedDataStore2(SourceDataStore pAttachedDataStore)
pAttachedDataStore - The source data store attached to the right
                           side of this join.getAttachedDataStore2()public boolean isOuter1()
true if the source data store on the left side of
         this join is set to be preserving in the join.setOuter1(boolean)public void setOuter1(boolean pOuter1)
pOuter1 - true if the source data store on the left 
                side of this join is set to be preserving in the join.isOuter1()public boolean isOuter2()
true if the source data store on the right side of
         this join is set to be preserving in the join.setOuter2(boolean)public void setOuter2(boolean pOuter2)
pOuter2 - true if the source data store on the right
                side of this join is set to be preserving in the join.isOuter2()public boolean isLookup()
true if this join clause represents a lookup
         operation, false otherwise.public void setLookup(boolean pLookup)
pLookup - true if this join clause represents a lookup
                operation, false otherwise.public java.lang.String getSubComponentDescription()
IInterfaceSubComponentpublic java.lang.String getSubComponentDescription(java.util.Locale pLocale)
IInterfaceSubComponentpLocale - the Locale for which the description should be returnedpublic java.lang.String getGlobalId()
IRepositoryEntitygetGlobalId in interface IRepositoryEntitygetGlobalId in class oracle.odi.domain.support.AbstractRepositoryEntitypublic java.lang.String getTechnicalDescription()
GenericClausegetTechnicalDescription in class GenericClausepublic Expression getSqlExpression()
GenericClausegetSqlExpression in class GenericClauseGenericClause.setSqlExpression(Expression)public java.lang.Number getSqlExpressionId()
GenericClausegetSqlExpressionId in class GenericClausepublic java.lang.String getBusinessRule()
GenericClausegetBusinessRule in class GenericClauseGenericClause.setBusinessRule(String)public OdiInterface.ExecutionLocation getExecutionLocation()
GenericClausegetExecutionLocation in class GenericClauseGenericClause.setExecutionLocation(OdiInterface.ExecutionLocation)public SourceSet getSourceSet()
GenericClausegetSourceSet in class GenericClausenull,
         this clause is executed in the staging area.GenericClause.setSourceSet(SourceSet)public java.lang.Number getClauseId()
GenericClausegetClauseId in class GenericClausepublic DataSet getDataSet()
GenericClausegetDataSet in class GenericClauseGenericClause.setDataSet(oracle.odi.domain.project.interfaces.DataSet)public int getClauseOrder()
GenericClausegetClauseOrder in class GenericClauseGenericClause.setClauseOrder(int)public java.lang.String getSql()
GenericClausegetSql in class GenericClausepublic OdiIndexType getIndexType1()
GenericClausegetIndexType1 in class GenericClauseGenericClause.setIndexType1(OdiIndexType)public OdiIndexType getIndexType2()
GenericClausegetIndexType2 in class GenericClauseGenericClause.setIndexType2(OdiIndexType)public void setSqlExpression(Expression pSqlExpression)
GenericClausesetSqlExpression in class GenericClausepSqlExpression - The new SQL expression for this clause.GenericClause.getSqlExpression()public void setBusinessRule(java.lang.String pBusinessRule)
GenericClausesetBusinessRule in class GenericClausepBusinessRule - the new description of this clause.GenericClause.getBusinessRule()public boolean isEnabled()
GenericClauseisEnabled in class GenericClausetrue if the clause is active and enabled.GenericClause.setEnabled(boolean)public void setEnabled(boolean pEnabled)
GenericClausesetEnabled in class GenericClausepEnabled - true to enable this clause,
                 false to disable this clauseGenericClause.isEnabled()public void setExecutionLocation(OdiInterface.ExecutionLocation pExecutionLocation)
GenericClausesetExecutionLocation in class GenericClausepExecutionLocation - the new execution location of this clause.GenericClause.getExecutionLocation()public void setSourceSet(SourceSet pSourceSet)
GenericClausesetSourceSet in class GenericClausepSourceSet - the source set where this clause will be executed.
                   null if this clause is to be executed in
                   the staging area.GenericClause.getSourceSet()public void setClauseOrder(int pClauseOrder)
GenericClausesetClauseOrder in class GenericClausepClauseOrder - the new clause order of the clauseGenericClause.getClauseOrder()public void setIndexType1(OdiIndexType pIndexType1)
GenericClausesetIndexType1 in class GenericClausepIndexType1 - The temporary index type used for the left side of
                    this clause.GenericClause.getIndexType1()public void setIndexTypeCode1(java.lang.String pIndexTypeCode1)
GenericClausesetIndexTypeCode1 in class GenericClausepublic void setIndexType2(OdiIndexType pIndexType2)
GenericClausesetIndexType2 in class GenericClausepIndexType2 - The temporary index type used for the right side of
                    this clause.GenericClause.getIndexType2()public void setIndexTypeCode2(java.lang.String pIndexTypeCode2)
GenericClausesetIndexTypeCode2 in class GenericClause