gudusoft.gsqlparser.stmt

Class TBlockSqlStatement

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TBlockSqlStatement

All Implemented Interfaces:

IRelation, Visitable, Iterator<TSourceToken>

Direct Known Subclasses:

TCreateSchemaSqlStatement, TDb2LoopStmt, TExecImmeStmt, TForEachStmt, TForStmt, TLoopStmt, TMssqlBlock, TMySQLBlock, TMySQLLoopStmt, TMySQLRepeatStmt, TMySQLWhileStmt, TRepeatStmt, TStoredProcedureSqlStatement, TWhileStmt

public class TBlockSqlStatement
extends TCustomSqlStatement

Base class for all sql statements that include multiple sql statements

Field Summary

Fields

Modifier and Type	Field and Description
protected TBlockSqlNode	blockBody
protected TStatementList	bodyStatements
protected TStatementList	declareStatements
protected TExceptionClause	exceptionClause

Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement

dummytag, fromClause, fromSourceJoin, fromSourceTable, isparsed, joins, parser, plsqlparser, relationAttributes, rootNode, sourcetokenlist, sqlstatementtype, stmtScope, tables

Fields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

dbvendor, doubleLinkedTokenListToString, nodeActionAppend, nodeActionInsert, nodeActionRemove, nodeActionUnknown, nodeActionUpdate, nodeActionUpdateText, nodeChangeEndToken, nodeChangeStartToken

Constructor Summary

Constructors

Constructor and Description
TBlockSqlStatement(EDbVendor dbvendor)

Method Summary

Modifier and Type	Method and Description
int	doParseStatement(TCustomSqlStatement psql)
TBlockSqlNode	getBlockBody()
TStatementList	getBodyStatements()
TStatementList	getDeclareStatements()
TObjectName	getEndlabelName()
TExceptionClause	getExceptionClause()
TObjectName	getLabelName()
String	getLabelNameStr()
void	setBodyStatements(TStatementList bodyStatements)
void	setDeclareStatements(TStatementList declareStatements)
void	setExceptionClause(TExceptionClause exceptionClause)

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement

addToTables, addWhereClause, analyzeFromTable, analyzeFromTable, analyzeJoin, analyzeTablename, analyzeTableOrJoin, asCanonical, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, clearError, dochecksyntax, findTable, fireOnMetaDatabaseTableColumn, getAncestorStmt, getAttributes, getColumnsInTable, getColumnsInTable, getCteIncludeThisStmt, getCteList, getDaxFunctionStack, getErrorCount, getErrormessage, getExpandedResultColumns, getFirstPhysicalTable, getFrameStack, getFromClause, getFromSourceJoin, getFromSourceTable, getGlobalScope, getIndexColumns, getJoins, getOrphanColumns, getOutputClause, getParentObjectName, getParentStmt, getRelationName, getRelations, getResultColumnList, getReturningClause, getSqlEnv, getStatements, getStmtScope, getSymbolTable, getSyntaxErrors, getSyntaxHints, getTables, getTargetTable, getTokenList, getTopClause, getTopStatement, getUsingVariableList, getVariableStack, getWhereClause, isathenaplsql, isBigQueryplsql, isdatabricksplsql, isGaussDBStoredProcedure, isgreeplumplsql, isnzplsql, isoracleplsql, ispgplsql, isprestoplsql, issnowflakeplsql, isTableACTE, isverticaplsql, linkColumnReferenceToTable, linkColumnToTable, linkToFirstTable, locateVariableOrParameter, locateVariableOrParameter, OracleStatementCanBeSeparatedByBeginEndPair, parseerrormessagehandle, parsestatement, parsestatement, searchCTEList, searchDaxVariableInStack, searchFunctionInSQLEnv, setAlreadyAddToParent, setCteIncludeThisStmt, setCteList, setEndlabelName, setFrameStack, setFromClause, setLabelName, setOutputClause, setParentStmt, setParentStmtToNull, setResultColumnList, setReturningClause, setStmtScope, setTargetTable, setTopClause, setUsingVariableList, setVariableStack, setWhereClause, size, toScript, VerticaStatementCanBeSeparatedByBeginEndPair

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

accept, acceptChildren, addAllMyTokensToTokenList, addToTokenChain, appendNewNode, calculateTokenCount, doAppendNewNode, doParse, fastSetString, getAnchorNode, getColumnNo, getCommentAfterNode, getCommentBeforeNode, getCompactString, getDummyTag, getEndToken, getEvaluateDatatype, getEvalValue, getGsqlparser, getLineNo, getLocation, getMd5, getNodeStatus, getNodeType, getPlainText, getStartToken, getTokenCount, hasNext, init, 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, toString, toString2

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface Iterator

forEachRemaining

Field Detail

declareStatements

protected TStatementList declareStatements

bodyStatements

protected TStatementList bodyStatements

exceptionClause

protected TExceptionClause exceptionClause

blockBody

protected TBlockSqlNode blockBody

Constructor Detail

TBlockSqlStatement

public TBlockSqlStatement(EDbVendor dbvendor)

Method Detail

getBlockBody

public TBlockSqlNode getBlockBody()

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Overrides:

doParseStatement in class TCustomSqlStatement

getLabelName

public TObjectName getLabelName()

Overrides:

getLabelName in class TCustomSqlStatement

Returns:

label name used in plsql statement.

getLabelNameStr

public String getLabelNameStr()

getEndlabelName

public TObjectName getEndlabelName()

Overrides:

getEndlabelName in class TCustomSqlStatement

getExceptionClause

public TExceptionClause getExceptionClause()

setExceptionClause

public void setExceptionClause(TExceptionClause exceptionClause)

getDeclareStatements

public TStatementList getDeclareStatements()

setDeclareStatements

public void setDeclareStatements(TStatementList declareStatements)

getBodyStatements

public TStatementList getBodyStatements()

setBodyStatements

public void setBodyStatements(TStatementList bodyStatements)