public class TCTE extends TTable
Multiple common table expressions can be specified following the single WITH keyword.
Each common table expression specified can also be referenced by name in the FROM clause of subsequent common table expressions.
Syntax:
table-name [column-name [,...n]] AS (fullselect)
PIVOT_CLAUSE_ALIAS, TABLE_COLLECTION_ALIAS, tablerefs, UNPIVOT_CLAUSE_ALIASdbvendor, doubleLinkedTokenListToString, nodeActionAppend, nodeActionInsert, nodeActionRemove, nodeActionUnknown, nodeActionUpdate, nodeActionUpdateText, nodeChangeEndToken, nodeChangeStartToken| Constructor and Description |
|---|
TCTE() |
addAttribute, checkTableByName, equalByName, getAliasName, getAttributes, getAttributesReferenceToThisRelation, getCaseJoin, getColumnDefinitions, getColumnListInTempTable, getColumnsFromSQLEnv, getContainsTable, getCTE, getCteColomnReferences, getDatachangeTable, getDisplayName, getEffectType, getExpandedStarColumns, getFlashback, getForXMLClause, getFromTableList, getFullName, getFullNameWithAliasString, getFuncCall, getHiveFromQuery, getJoinExpr, getJsonTable, getLateralViewList, getLinkedColumns, getLinkTable, getName, getObjectNameReferences, getOpenDatasource, getOpenquery, getOpenRowSet, getOpenXML, getOuterClause, getOutputMerge, getParenthesisAfterAliasCount, getParenthesisCount, getPartitionExtensionClause, getPivotClause, getPivotedTable, getPrefixDatabase, getPrefixSchema, getPrefixServer, getPxGranule, getResolvedTable, getRowList, getSourceTableOfPivot, getSqlEnv, getStageName, getStageReference, getTableExpr, getTableHintList, getTableProperties, getTableSample, getTableType, getTdUnpivot, getTimeTravelClause, getUnnestClause, getValueClause, getXmlTable, initAttributeForRowList, initAttributeForTableFunction, initAttributeForXMLTable, initAttributesForJoin, initAttributesForPivotTable, initAttributesForUnnest, initAttributesFromCTE, initAttributesFromSubquery, isBaseTable, isCTEName, isIncludeColumnAlias, isLinkTable, isOnlyKeyword, isResolved, isTableKeyword, isTableRefBelongToThisTable, searchColumn, searchColumnInAlias, setCaseJoin, setColumnDefinitions, setColumnListInTempTable, setContainsTable, setCTE, setCteColomnReferences, setCTEName, setDatachangeTable, setEffectType, setFlashback, setForXMLClause, setFromTableList, setFuncCall, setHiveFromQuery, setJoinExpr, setJsonTable, setLateralViewList, setLinkedColumns, setLinkTable, setLinkTable, setObjectNameReferences, setOnlyKeyword, setOpenDatasource, setOpenquery, setOpenRowSet, setOpenXML, setOuterClause, setOutputMerge, setParenthesisAfterAliasCount, setParenthesisCount, setPartitionExtensionClause, setPivotClause, setPivotedTable, setPropertyFromObjectName, setPxGranule, setResolved, setResolvedTable, setRowList, setSourceTableOfPivot, setSqlEnv, setStageReference, setTableExpr, setTableHintList, setTableKeyword, setTableProperties, setTablerefs, setTableSample, setTableType, setTdUnpivot, setTimeTravelClause, setUnnestClause, setValueClause, setXmlTable, size, toStringgetAliasClause, setAliasClauseaddAllMyTokensToTokenList, addToTokenChain, appendNewNode, calculateTokenCount, doAppendNewNode, fastSetString, getAnchorNode, getColumnNo, getCommentAfterNode, getCommentBeforeNode, getCompactString, getDummyTag, getEndToken, getEvaluateDatatype, getEvalValue, getGsqlparser, getLineNo, getLocation, getMd5, getNodeStatus, getNodeType, getParentObjectName, getPlainText, getStartToken, getTokenCount, hasNext, init, init, init, init, init, insertAfterAToken, insertNewNodeBeforeMe, isChanged, isTokensInChain, next, refreshAllNodesTokenCount, remove, removeAllMyTokensFromTokenList, removeTokens, removeTokensBetweenNodes, removeTokensBetweenToken, replaceWithNewNode, resetIterator, setAnchorNode, setChanged, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setEndToken, setEndTokenDirectly, setEvaluateDatatype, setEvalValue, setGsqlparser, setIncludingComment, setLocation, setNewSubNode, setNodeStatus, setNodeType, setParent, setPlainText, setStartToken, setStartToken, setStartToken, setStartToken, setStartTokenDirectly, setString, setString2, subNodeInNode, toScript, toString2clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, waitforEachRemainingpublic TCTE()
public void setRecursive(boolean recursive)
public boolean isRecursive()
public void initAttributesFromColumnList()
public void initAttributesFromSubQuery()
public String getRelationName()
getRelationName in interface IRelationgetRelationName in class TTablepublic boolean searchColumnInResultSet(TCustomSqlStatement pSql, TTable pTable, TObjectName pColumn, boolean pMustIn)
public TCustomSqlStatement getPreparableStmt()
public TUpdateSqlStatement getUpdateStmt()
public TInsertSqlStatement getInsertStmt()
public TDeleteSqlStatement getDeleteStmt()
public TObjectName getTableName()
getTableName in class TTablepublic void setColumnList(TObjectNameList columnList)
public TSelectSqlStatement getSubquery()
getSubquery in class TTablepublic TObjectNameList getColumnList()
public void init(Object arg1, Object arg2)
init in class TParseTreeNodepublic void incParenthesisCount()
public void doParse(TCustomSqlStatement psql, ESqlClause plocation)
TParseTreeNodedoParse in class TParseTreeNodepsql - SQL statement this node belongs toplocation - SQL clause this node belongs topublic void accept(TParseTreeVisitor v)
TParseTreeNodeaccept in interface Visitableaccept in class TTablev - visitor is a descendant class of TParseTreeVisitorpublic void acceptChildren(TParseTreeVisitor v)
TParseTreeNodeacceptChildren in interface VisitableacceptChildren in class TTablev - visitor is a descendant class of TParseTreeVisitorpublic void setSubquery(TSelectSqlStatement subquery)
setSubquery in class TTablepublic void setInsertStmt(TInsertSqlStatement insertStmt)
public void setUpdateStmt(TUpdateSqlStatement updateStmt)
public void setDeleteStmt(TDeleteSqlStatement deleteStmt)
public void setPreparableStmt(TCustomSqlStatement preparableStmt)
public void setTableName(TObjectName tableName)
setTableName in class TTable