public interface ANSISelectBuilder extends SelectBuilder
Modifier and Type | Method and Description |
---|---|
java.lang.String |
addANSIFromCondition(java.lang.String table,
java.lang.String tableAlias,
java.lang.String joinType,
java.lang.String joinCondition)
Adds ANSI from join condition to the end of the from
clause of ANSI select statement
|
java.lang.String |
addANSIJoinCondition(java.lang.String tableAlias,
java.lang.String condition)
Adds condition to the end of the specified ON clause of the ANSI statement
|
java.lang.String |
addANSIWhere(java.lang.String condition)
Adds condition to the end of the WHERE clause of the ANSI statement
|
java.lang.String |
replaceANSIJoinCondition(java.lang.String tableAlias,
java.lang.String condition)
Replaces specified ON clause of the ANSI statement
|
java.lang.String |
replaceANSIWhere(java.lang.String clause)
Replaces WHERE clause of the ANSI statement with
|
addFrom, addGroupBy, addHaving, addHaving, addOrderBy, addRSColumns, addWhere, addWhere, buildWhereItem, createRSColumn, findRSColumn, getRSColumns, getRSItemExprById, getSelect, replaceGroupBy, replaceHaving, replaceOrderBy, replaceRSColumns, replaceWhere, updateSelect
java.lang.String addANSIFromCondition(java.lang.String table, java.lang.String tableAlias, java.lang.String joinType, java.lang.String joinCondition) throws DEException
table
- table nametableAlias
- table aliasjoinType
- type of ANSI join like JOIN,RIGTH JOIN,LEFT JOIN ...joinCondition
- ANSI join condition like t1.col1=t2.col2DEException
- when original statement is not in ANSI formatjava.lang.String addANSIWhere(java.lang.String condition) throws DEException
condition
- where conditionDEException
- when original statement is not in ANSI formatjava.lang.String replaceANSIWhere(java.lang.String clause) throws DEException
clause
- new ANSI whereDEException
- when original statement is not in ANSI formatjava.lang.String addANSIJoinCondition(java.lang.String tableAlias, java.lang.String condition) throws DEException
tableAlias
- alias of the table which ON condition will be modifiedcondition
- DEException
- when original statement is not in ANSI formatjava.lang.String replaceANSIJoinCondition(java.lang.String tableAlias, java.lang.String condition) throws DEException
tableAlias
- alias of the table which ON clause will be replacedcondition
- DEException
- when original statement is not in ANSI format