TMergeSqlStatement (gudusoft.gsqlparser 2.0.1.0 API)

java.lang.Object
- gudusoft.gsqlparser.nodes.TParseTreeNode
- - gudusoft.gsqlparser.TCustomSqlStatement
  - - gudusoft.gsqlparser.stmt.TMergeSqlStatement

All Implemented Interfaces:

Visitable
```
public class TMergeSqlStatement
extends TCustomSqlStatement
```
Merge SQL statement.

TCustomSqlStatement.getTargetTable() returns the target table.
getUsingTable() returns the source table in the using clause.
getCondition() returns the merge search condition.
getWhenClauses() returns when MATCHED/NOT MATCHED clauses.
```
     merge into target_table [column_list]
     using source_table|subquery
     on merge_search_condition
     [when matched [and search_conditions ] then update set {col_name = expression} | delete]
     [when not matched [and search_conditions ] then insert [(column_list)] values (value_list)]
  
```
call TCustomSqlStatement.getTargetTable() to return a value for target_table.
column_list can be fetched from getColumnList() if any.
source_table in using clause can be fetched via getUsingTable(), subquery treated as a table as well.
call getCondition() to return merge_search_condition.
when [not] matched clause is available by calling getWhenClauses() which is a list of type TMergeWhenClause.
See Also:

TMergeWhenClause, TMergeUpdateClause, TMergeDeleteClause, TMergeInsertClause

Field Summary
- Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement
  dbvendor, dummytag, isparsed, joins, parser, plsqlparser, rootNode, sourcetokenlist, sqlstatementtype, tables

Constructor Summary

Constructors
Constructor and Description

TMergeSqlStatement(EDbVendor dbvendor)

Constructors
Constructor and Description
`TMergeSqlStatement(EDbVendor dbvendor)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`accept(TParseTreeVisitor v)` Accept a visitor
`void`	`acceptChildren(TParseTreeVisitor v)` Accept a visitor to iterate this class and sub-nodes of this class
`int`	`doParseStatement(TCustomSqlStatement psql)`
`TObjectNameList`	`getColumnList()` Columns in target table.
`TExpression`	`getCondition()` merge search condition.
`TErrorLoggingClause`	`getErrorLoggingClause()` Oracle error logging clause.
`TMergeInsertClause`	`getInsertClause()` This method is not used, use `getWhenClauses()` instead.
`TLimitClause`	`getLimitClause()` Couchbase, limit clause.
`TExpression`	`getMatchedSearchCondition()` This method is not used, use `getCondition()` instead.
`TExpression`	`getNotMatchedSearchCondition()` This method is not used, use `getCondition()` instead.
`TOptionClause`	`getOptionClause()` sql server option clause
`TReturningClause`	`getReturningClause()` Couchbase, returning clause.
`TMergeUpdateClause`	`getUpdateClause()` This method is not used, use `getWhenClauses()` instead.
`TTable`	`getUsingTable()` Source table in the using clause.
`TPTNodeList<TMergeWhenClause>`	`getWhenClauses()` when matched/not matched clauses.
`void`	`setColumnList(TObjectNameList columnList)`
`void`	`setCondition(TExpression condition)`
`void`	`setErrorLoggingClause(TErrorLoggingClause errorLoggingClause)`
`void`	`setInsertClause(TMergeInsertClause insertClause)`
`void`	`setLimitClause(TLimitClause limitClause)`
`void`	`setMatchedSearchCondition(TExpression matchedSearchCondition)`
`void`	`setNotMatchedSearchCondition(TExpression notMatchedSearchCondition)`
`void`	`setOptionClause(TOptionClause optionClause)`
`void`	`setReturningClause(TReturningClause returningClause)`
`void`	`setUpdateClause(TMergeUpdateClause updateClause)`
`void`	`setUsingTable(TTable usingTable)`
`void`	`setWhenClauses(TPTNodeList<TMergeWhenClause> whenClauses)`

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement
addToTables, addWhereClause, analyzeFromTable, analyzeJoin, analyzeTablename, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, clearError, dochecksyntax, findTable, fireOnMetaDatabaseTableColumn, getAncestorStmt, getCteList, getDaxFunctionStack, getEndlabelName, getErrorCount, getFirstPhysicalTable, getIndexColumns, getJoins, getLabelName, getOrphanColumns, getOutputClause, getParentStmt, getResultColumnList, getStatements, getSymbolTable, getTables, getTargetTable, getTopClause, getTopStatement, getVariableStack, getWhereClause, isnzplsql, isoracleplsql, ispgplsql, isTableACTE, isverticaplsql, linkColumnReferenceToTable, linkColumnToTable, linkToFirstTable, locateVariableOrParameter, OracleStatementCanBeSeparatedByBeginEndPair, parseerrormessagehandle, parsestatement, searchCTEList, searchDaxVariableInStack, setCteList, setEndlabelName, setLabelName, setOutputClause, setParentStmt, setResultColumnList, setTargetTable, setTopClause, setVariableStack, setWhereClause, VerticaStatementCanBeSeparatedByBeginEndPair

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode
addAllMyTokensToTokenList, appendString, doParse, fastSetString, getColumnNo, getDummyTag, getEndToken, getGsqlparser, getLineNo, getNodeType, getStartToken, init, init, init, init, init, init, removeAllMyTokensFromTokenList, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setGsqlparser, setIncludingComment, setNodeType, setStartToken, setStartToken, setStartToken, setStartToken, setString, toScript, toString

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - TMergeSqlStatement
```
public TMergeSqlStatement(EDbVendor dbvendor)
```
- Method Detail
  - getErrorLoggingClause
```
public TErrorLoggingClause getErrorLoggingClause()
```
    Oracle error logging clause.
    
    Returns:
    
    Oracle error logging clause.
  - getOptionClause
```
public TOptionClause getOptionClause()
```
    sql server option clause
    
    Returns:
    
    option clause
    
    See Also:
    
    TOptionClause
  - getColumnList
```
public TObjectNameList getColumnList()
```
    Columns in target table.
    
    Returns:
    
    Columns in target table.
  - getMatchedSearchCondition
```
public TExpression getMatchedSearchCondition()
```
    This method is not used, use getCondition() instead.
    
    Returns:
    
    not used
  - getNotMatchedSearchCondition
```
public TExpression getNotMatchedSearchCondition()
```
    This method is not used, use getCondition() instead.
    
    Returns:
    
    not used
  - getUsingTable
```
public TTable getUsingTable()
```
    Source table in the using clause.
    
    Returns:
    
    Source table in the using clause.
  - getCondition
```
public TExpression getCondition()
```
    merge search condition.
    
    Returns:
    
    merge search condition.
  - getUpdateClause
```
public TMergeUpdateClause getUpdateClause()
```
    This method is not used, use getWhenClauses() instead.
    
    Returns:
  - getInsertClause
```
public TMergeInsertClause getInsertClause()
```
    This method is not used, use getWhenClauses() instead.
    
    Returns:
  - getWhenClauses
```
public TPTNodeList<TMergeWhenClause> getWhenClauses()
```
    when matched/not matched clauses.
    
    Returns:
    
    when matched/not matched clauses.
  - doParseStatement
```
public int doParseStatement(TCustomSqlStatement psql)
```
    Overrides:
    
    doParseStatement in class TCustomSqlStatement
  - accept
```
public void accept(TParseTreeVisitor v)
```
    Description copied from class: TParseTreeNode
    
    Accept a visitor
    
    Specified by:
    
    accept in interface Visitable
    
    Overrides:
    
    accept in class TParseTreeNode
    
    Parameters:
    
    v - visitor is a descendant class of TParseTreeVisitor
  - acceptChildren
```
public void acceptChildren(TParseTreeVisitor v)
```
    Description copied from class: TParseTreeNode
    
    Accept a visitor to iterate this class and sub-nodes of this class
    
    Specified by:
    
    acceptChildren in interface Visitable
    
    Overrides:
    
    acceptChildren in class TParseTreeNode
    
    Parameters:
    
    v - visitor is a descendant class of TParseTreeVisitor
  - setErrorLoggingClause
```
public void setErrorLoggingClause(TErrorLoggingClause errorLoggingClause)
```
  - setOptionClause
```
public void setOptionClause(TOptionClause optionClause)
```
  - setMatchedSearchCondition
```
public void setMatchedSearchCondition(TExpression matchedSearchCondition)
```
  - setNotMatchedSearchCondition
```
public void setNotMatchedSearchCondition(TExpression notMatchedSearchCondition)
```
  - setColumnList
```
public void setColumnList(TObjectNameList columnList)
```
  - setUsingTable
```
public void setUsingTable(TTable usingTable)
```
  - setCondition
```
public void setCondition(TExpression condition)
```
  - setUpdateClause
```
public void setUpdateClause(TMergeUpdateClause updateClause)
```
  - setInsertClause
```
public void setInsertClause(TMergeInsertClause insertClause)
```
  - setWhenClauses
```
public void setWhenClauses(TPTNodeList<TMergeWhenClause> whenClauses)
```
  - setLimitClause
```
public void setLimitClause(TLimitClause limitClause)
```
  - getLimitClause
```
public TLimitClause getLimitClause()
```
    Couchbase, limit clause.
    
    Returns:
    
    Couchbase, limit clause.
  - setReturningClause
```
public void setReturningClause(TReturningClause returningClause)
```
    Overrides:
    
    setReturningClause in class TCustomSqlStatement
  - getReturningClause
```
public TReturningClause getReturningClause()
```
    Couchbase, returning clause.
    
    Overrides:
    
    getReturningClause in class TCustomSqlStatement
    
    Returns:
    
    Couchbase, returning clause.

Class TMergeSqlStatement

Field Summary

Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement

Constructor Summary

Method Summary

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

Methods inherited from class java.lang.Object

Constructor Detail

TMergeSqlStatement

Method Detail

getErrorLoggingClause

getOptionClause

getColumnList

getMatchedSearchCondition

getNotMatchedSearchCondition

getUsingTable

getCondition

getUpdateClause

getInsertClause

getWhenClauses

doParseStatement

accept

acceptChildren

setErrorLoggingClause

setOptionClause

setMatchedSearchCondition

setNotMatchedSearchCondition

setColumnList

setUsingTable

setCondition

setUpdateClause

setInsertClause

setWhenClauses

setLimitClause

getLimitClause

setReturningClause

getReturningClause