TCustomSqlStatement (gudusoft.gsqlparser 2.0.1.0 API)

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

All Implemented Interfaces:

Visitable

Direct Known Subclasses:

TAlterAccessPolicy, TAlterAccountStmt, TAlterAuditPolicyStmt, TAlterAuthentication, TAlterCredentialStmt, TAlterDatabaseStmt, TAlterFaultGroup, TAlterFileFormatStmt, TAlterFulltextIndexStmt, TAlterFunctionStmt, TAlterIndexStmt, TAlterJWTProviderStmt, TAlterLDAPProviderStmt, TAlterLibraryStmt, TAlterMaterializedViewStmt, TAlterNetworkInterface, TAlterNetworkPolicyStmt, TAlterNode, TAlterPipeStmt, TAlterProfile, TAlterProjectionRename, TAlterPSEStmt, TAlterRemoteSourceStmt, TAlterResourceMonitorStmt, TAlterResourcePool, TAlterRoleStmt, TAlterSAMLProviderStmt, TAlterSchemaStmt, TAlterSequenceStatement, TAlterSessionStatement, TAlterShareStmt, TAlterStageStmt, TAlterStatisticsStmt, TAlterSubnet, TAlterSynonymStmt, TAlterSystemStmt, TAlterTableStatement, TAlterTriggerStmt, TAlterUserGroupStmt, TAlterUserStmt, TAlterViewStatement, TAlterVirtualTableStmt, TAlterWarehouseStmt, TAlterWorkloadClassStmt, TAlterWorkloadMappingStmt, TAssignStmt, TBackupCancelStmt, TBackupCatalogDeleteStmt, TBackupCheckStmt, TBackupDataStmt, TBackupListDataStmt, TBasicStmt, TBeginTran, TBlockSqlStatement, TCallStatement, TCaseStmt, TCheckWorkload, TCloseStmt, TCommentOnSqlStmt, TCommitStmt, TConnectStmt, TCopyIntoStmt, TCreateAccessPolicy, TCreateAliasStmt, TCreateAuditPolicyStmt, TCreateAuthentication, TCreateCertificateStmt, TCreateCollectionStmt, TCreateCredentialStmt, TCreateDatabaseLinkStmt, TCreateDatabaseSqlStatement, TCreateFaultGroup, TCreateFileFormatStmt, TCreateFulltextIndexStmt, TCreateGraphWorkspaceStmt, TCreateHCatalogSchema, TCreateIndexSqlStatement, TCreateJWTProviderStmt, TCreateLDAPProviderStmt, TCreateMaterializedSqlStatement, TCreateMaterializedViewLogSqlStatement, TCreateNetworkPolicyStmt, TCreatePipeStmt, TCreatePSEStmt, TCreateRemoteSourceStmt, TCreateResourceMonitorStmt, TCreateRoleStmt, TCreateSAMLProviderStmt, TCreateSequenceStmt, TCreateShareStmt, TCreateStageStmt, TCreateStatistics, TCreateStructuredPrivilegeStmt, TCreateSubnet, TCreateSynonymStmt, TCreateTableSqlStatement, TCreateTypeStmt, TCreateUserGroupStmt, TCreateUserStmt, TCreateViewSqlStatement, TCreateVirtualFunctionStmt, TCreateVirtualProcedureStmt, TCreateVirtualTableStmt, TCreateWarehouseStmt, TCreateWorkloadClassStmt, TCreateWorkloadMappingStmt, TCursorDeclStmt, TCustomDb2Stmt, TCustomMySQLStmt, TCustomOracleSqlStmt, TDaxStmt, TDb2StmtStub, TDeleteSqlStatement, TDenyStmt, TDescribeStmt, TDisconnectStmt, TDropAccessPolicy, TDropAggregateFunction, TDropAuthentication, TDropDatabaseLinkStmt, TDropDatabaseStmt, TDropFaultGroup, TDropFunctionStmt, TDropIndexSqlStatement, TDropLibraryStmt, TDropMacro, TDropMaterializedViewLogStmt, TDropMaterializedViewStmt, TDropNetworkInterface, TDropProcedureStmt, TDropProfileStmt, TDropProjectionStmt, TDropResourcePool, TDropRoleSqlStatement, TDropRoleStmt, TDropSchemaSqlStatement, TDropSequenceStmt, TDropStmt, TDropSubnet, TDropSynonymStmt, TDropTableSqlStatement, TDropTextIndex, TDropTransformFunction, TDropTriggerSqlStatement, TDropUserStmt, TDropViewSqlStatement, TElsifStmt, TEndTran, TExecutePreparedStatement, TExecuteSqlStatement, TExitStmt, TExplainPlan, TExportStmt, TExportToVertica, TFetchFromStmt, TFetchStmt, TGetDiagStmt, TGetStmt, TGrantSqlStatement, TGrantStmt, THiveAnalyzeTable, THiveCreateFunction, THiveCreateRole, THiveDescribe, THiveDropDatabase, THiveDropFunction, THiveDropRole, THiveExplain, THiveExportTable, THiveFromQuery, THiveGrant, THiveGrantRole, THiveImportTable, THiveLoad, THiveMetaStoreCheck, THiveRevoke, THiveRevokeRole, THiveSet, THiveShow, THiveShowGrant, THiveShowRoleGrant, THiveSwitchDatabase, THiveUnlockTable, TIfStmt, TImportStmt, TInferKeyspaceStmt, TInformixAllocateCollectionStmt, TInformixAllocateDescriptorStmt, TInformixAllocateRow, TInformixAlterAccess_MethodStmt, TInformixAlterFragment, TInformixCreateRowTypeStmt, TInformixCreateTrigger, TInformixDropRowTypeStmt, TInformixExecuteFunction, TInformixExecuteImmediate, TInformixExecuteProcedure, TInformixExecuteStmt, TInsertBulk, TInsertSqlStatement, TListStmt, TLoadStmt, TLockSqlStatement, TLockTableStmt, TMdxAlterCube, TMdxCalculate, TMdxCall, TMdxCase, TMdxClearCalculations, TMdxCreateAction, TMdxCreateCellCalculation, TMdxCreateGlobalCube, TMdxCreateMeasure, TMdxCreateMember, TMdxCreateSessionCube, TMdxCreateSet, TMdxCreateSubCube, TMdxDrillthrough, TMdxDropAction, TMdxDropCellCalculation, TMdxDropMember, TMdxDropSet, TMdxDropSubcube, TMdxExpression, TMdxFreeze, TMdxIf, TMdxRefreshCube, TMdxScope, TMdxSelect, TMdxUpdate, TMergeDeltaStmt, TMergeSqlStatement, TMoveStmt, TMssqlBeginConversationTimer, TMssqlBeginDialog, TMssqlBreak, TMssqlBulkInsert, TMssqlClose, TMssqlCommit, TMssqlContinue, TMssqlCreateType, TMssqlCreateXmlSchemaCollectionStmt, TMssqlDeallocate, TMssqlDeclare, TMssqlDropDbObject, TMssqlDropTable, TMssqlDropView, TMssqlDummyStmt, TMssqlEndConversation, TMssqlErrorStmt, TMssqlExecute, TMssqlExecuteAs, TMssqlFetch, TMssqlGo, TMssqlGoTo, TMssqlGrant, TMssqlIfElse, TMssqlLabel, TMssqlOpen, TMssqlPrint, TMssqlRaiserror, TMssqlReturn, TMssqlRevert, TMssqlRollback, TMssqlSaveTran, TMssqlSendOnConversation, TMssqlSet, TMssqlSetRowCount, TMssqlStmtStub, TMssqlThrow, TMssqlUpdateStatistics, TMssqlUpdateText, TMssqlWaitFor, TMssqlWithas, TMySQLPrepareStmt, TMySQLStmtStub, TNetezzaGenerateStatistics, TNetezzaGroomTable, TNullStmt, TOpenforStmt, TOpenStmt, TOracleCreateLibraryStmt, TOracleExecuteProcedure, TParseErrorSqlStatement, TPlsqlContinue, TPlsqlCreateTriggerSqlStatement, TPlsqlCreateType, TPlsqlCreateType_Placeholder, TPlsqlDummyStmt, TPlsqlForallStmt, TPlsqlGotoStmt, TPlsqlNullStmt, TPlsqlPipeRowStmt, TPlsqlPragmaDeclStmt, TPlsqlProcedureSpecStmt, TPlsqlRecordTypeDefStmt, TPlsqlSqlStmt, TPlsqlStatement, TPlsqlSubProgram, TPlsqlTableTypeDefStmt, TPlsqlVarrayTypeDefStmt, TProfileStmt, TPutStmt, TRaiseStmt, TReconfigure, TRecoverDatabaseStmt, TRecoverDataStmt, TRedshiftAbort, TRedshiftAlterGroup, TRedshiftAlterSchema, TRedshiftAlterUser, TRedshiftAnalyze, TRedshiftAnalyzeCompression, TRedshiftBegin, TRedshiftCancel, TRedshiftClose, TRedshiftComment, TRedshiftCommit, TRedshiftCopy, TRedshiftCreateGroup, TRedshiftCreateSchema, TRedshiftCreateUser, TRedshiftDeallocate, TRedshiftDeclare, TRedshiftDropGroup, TRedshiftDropSchema, TRedshiftDropUser, TRedshiftEnd, TRedshiftExplain, TRedshiftLock, TRedshiftPrepare, TRedshiftReset, TRedshiftRollback, TRedshiftSessionAuthorization, TRedshiftStartTransaction, TRedshiftUnload, TRedshiftVacuum, TRefreshStatisticsStmt, TReleaseSavepointStmt, TRemoveStmt, TRenameStmt, TReturnStmt, TRevokeStmt, TRollbackStmt, TSavepointStmt, TSelectSqlStatement, TSetDatabaseObjectStmt, TSetStmt, TShowStmt, TSignalStmt, TSlashCommand, TSqlplusCmdStatement, TSybaseDeleteStatistics, TSybaseDumpTran, TSybaseUpdateIndexStatistics, TSybaseWritetext, TTBuildIndexesStmt, TTeradataAbort, TTeradataBeginLogging, TTeradataBeginTransaction, TTeradataBTEQCmd, TTeradataCollectStatistics, TTeradataCommit, TTeradataCreateTrigger, TTeradataDropDbObject, TTeradataEndLogging, TTeradataExecute, TTeradataGive, TTeradataGrant, TTeradataLock, TTeradataNotImplement, TTeradataRollback, TTeradataSetRole, TTeradataSetSession, TTeradataSetTimezone, TTeradataStmtStub, TTeradataUsing, TTruncateCollectionStmt, TTruncateStatement, TUndropStmt, TUnknownSqlStatement, TUnloadStmt, TUnsetStmt, TUpdateSqlStatement, TUpsertStmt, TUseDatabase, TUseStmt, TValidateLDAPProviderStmt, TValidateUserStmt, TVarDeclStmt, TVerticaSetStmt, TVerticaShow
```
public class TCustomSqlStatement
extends TParseTreeNode
```
TCustomSqlStatement is the root class for all SQL statements.

Field Summary

Fields
Modifier and Type	Field and Description
`EDbVendor`	`dbvendor` SQL dialect of this statement.
`int`	`dummytag` Tag used by parser internally.
`protected boolean`	`isparsed`
`TJoinList`	`joins` joins represents table sources in the from clause.
`TCustomParser`	`parser` Parser used to parse this statement.
`TCustomParser`	`plsqlparser` PLSQL parser used to parse this statement.
`TParseTreeNode`	`rootNode` Original Parse tree node from parser
`TSourceTokenList`	`sourcetokenlist` Source tokens included in this statement.
`ESqlStatementType`	`sqlstatementtype` Type of this statement.
`TTableList`	`tables` Provides a quick way to access all tables involved in this SQL statement.

Constructor Summary

Constructors
Constructor and Description

TCustomSqlStatement(EDbVendor dbvendor)

Constructors
Constructor and Description
`TCustomSqlStatement(EDbVendor dbvendor)`

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`void`	`addToTables(TTable pTable)`
`TWhereClause`	`addWhereClause(String condition)`
`TTable`	`analyzeFromTable(TFromTable pfromTable, Boolean addToTableList)`
`TJoin`	`analyzeJoin(TJoinExpr pJoinExpr, TJoin pJoin, Boolean isSub)`
`TTable`	`analyzeTablename(TObjectName tableName)`
`boolean`	`checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt(TObjectName crf, boolean sameLevelOnly)` Found out is a non qualified column is a column in uplevel subquery table like this: take ma_parkey for example: ma_parkey is not a physical column SELECT c_mandant , CASE WHEN EXISTS (SELECT 1 FROM CDS_H_GRUPPE GRP1 WHERE GRP1.c_mandant = c_mandant AND GRP1.parkey1 = ma_parkey) THEN 1 ELSE NULL END MA_ME FROM (SELECT c_mandant , CASE WHEN funktionscode = 'U' THEN parkey1 ELSE parkey2 END MA_PARKEY FROM CDS_H_GRUPPE )
`void`	`clearError()`
`protected int`	`dochecksyntax(TCustomSqlStatement psql)`
`int`	`doParseStatement(TCustomSqlStatement psql)`
`TTable`	`findTable(ETableEffectType pTableEffectType)`
`protected boolean`	`fireOnMetaDatabaseTableColumn(String pServer, String pDatabase, String pSchema, String pTable, String pColumn)`
`TCustomSqlStatement`	`getAncestorStmt()`
`TCTEList`	`getCteList()` Multiple common table expressions `TCTE` can be specified following the single WITH keyword.
`Stack<TDaxFunction>`	`getDaxFunctionStack()`
`TObjectName`	`getEndlabelName()`
`int`	`getErrorCount()` Number of syntax errors for this statement.
`TTable`	`getFirstPhysicalTable()`
`TPTNodeList<TColumnWithSortOrder>`	`getIndexColumns()`
`TJoinList`	`getJoins()`
`TObjectName`	`getLabelName()`
`TObjectNameList`	`getOrphanColumns()`
`TOutputClause`	`getOutputClause()`
`TCustomSqlStatement`	`getParentStmt()`
`TResultColumnList`	`getResultColumnList()` In select statement, this method returns Items in select_list.
`TReturningClause`	`getReturningClause()`
`TStatementList`	`getStatements()` Saves all first level sub statements.
`Stack`	`getSymbolTable()`
`TTableList`	`getTables()`
`TTable`	`getTargetTable()` target table in the delete/insert/update/create table statement.
`TTopClause`	`getTopClause()`
`TCustomSqlStatement`	`getTopStatement()`
`Stack<TObjectName>`	`getVariableStack()`
`TWhereClause`	`getWhereClause()` restrict the rows selected to those that satisfy one or more conditions.
`boolean`	`isnzplsql()`
`boolean`	`isoracleplsql()`
`boolean`	`ispgplsql()`
`protected boolean`	`isTableACTE(TTable pTable)`
`boolean`	`isverticaplsql()`
`void`	`linkColumnReferenceToTable(TObjectName cr, ESqlClause plocation)` Deprecated. As of v1.6.0.1, use `linkColumnToTable(gudusoft.gsqlparser.nodes.TObjectName, gudusoft.gsqlparser.ESqlClause)` instead
`boolean`	`linkColumnToTable(TObjectName pColumn, ESqlClause pLocation)`
`protected boolean`	`linkToFirstTable(TObjectName pColumn, int pCandidateTableCnt)`
`boolean`	`locateVariableOrParameter(TObjectName cr)`
`boolean`	`OracleStatementCanBeSeparatedByBeginEndPair()`
`EActionOnParseError`	`parseerrormessagehandle(TSyntaxError se)` Log error messages if syntax errors found while parsing this statement.
`int`	`parsestatement(TCustomSqlStatement pparentsql, boolean isparsetreeavailable)` Parse this statement.
`protected TCTEList`	`searchCTEList()`
`boolean`	`searchDaxVariableInStack(TObjectName pName)`
`void`	`setCteList(TCTEList cteList)`
`void`	`setEndlabelName(TObjectName endlabelName)`
`void`	`setLabelName(TObjectName lName)`
`void`	`setOutputClause(TOutputClause outputClause)`
`void`	`setParentStmt(TCustomSqlStatement parentStmt)`
`void`	`setResultColumnList(TResultColumnList resultColumnList)`
`void`	`setReturningClause(TReturningClause returningClause)`
`void`	`setTargetTable(TTable targetTable)`
`void`	`setTopClause(TTopClause topClause)`
`void`	`setVariableStack(Stack<TObjectName> variableStack)`
`void`	`setWhereClause(TWhereClause whereClause)`
`boolean`	`VerticaStatementCanBeSeparatedByBeginEndPair()`

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode
accept, acceptChildren, 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

- Field Detail
  - sqlstatementtype
```
public ESqlStatementType sqlstatementtype
```
    Type of this statement.
  - sourcetokenlist
```
public TSourceTokenList sourcetokenlist
```
    Source tokens included in this statement. only source tokens available when this is a top level statement, otherwise, there is no source token in this statement. Please check TParseTreeNode.getStartToken(), and TParseTreeNode.getEndToken() of this statement.
  - dbvendor
```
public EDbVendor dbvendor
```
    SQL dialect of this statement.
  - parser
```
public TCustomParser parser
```
    Parser used to parse this statement.
  - plsqlparser
```
public TCustomParser plsqlparser
```
    PLSQL parser used to parse this statement.
  - dummytag
```
public int dummytag
```
    Tag used by parser internally.
  - joins
```
public TJoinList joins
```
    joins represents table sources in the from clause. All structure information was reserved.
    SQL 1:
    select f from t1
    size of joins will be 1, t1 can be fetch via joins.getJoin(0).getTable()
    
    SQL 2:
    select f from t1,t2
    size of joins will be 2,
    t1 can be fetch via joins.getJoin(0).getTable()
    t2 can be fetch via joins.getJoin(1).getTable()
    
    SQL 3:
    select f from t1 join t2 on t1.f1 = t2.f1
    size of joins will be 1,
    t1 information can be fetch via joins.getJoin(0).getTable()
    In order to access t2, we need to introduce a new class TJoinItem which includes all information about t2 and join condition.
    There is a property named joinItems of TJoin which is type of TJoinItemList that includes a list of TJoinItem.
    this property can be access via TJoin.getJoinItems().
    Now, t2 can be fetch via joins.getJoin(0).getJoinItems().getJoinItem(0).getTable()
    
    SQL 4:
    select f from t1 join t2 on t1.f1 = t2.f1 join t3 on t1.f1 = t3.f1
    size of joins will be 1,
    t1 can be fetch via joins.getJoin(0).getTable()
    t2 can be fetch via joins.getJoin(0).getJoinItems().getJoinItem(0).getTable()
    t3 can be fetch via joins.getJoin(0).getJoinItems().getJoinItem(1).getTable()
    See Also:
    
    tables
  - tables
```
public TTableList tables
```
    Provides a quick way to access all tables involved in this SQL statement.
    It stores all tables in a flat way while joins stores all tables in a hierarchical structure.
    joins only represents tables in from clause of select/delete statement, and tables in update/insert statement.
    tables includes all tables in all types of SQL statements such as tables involved in a create table or create trigger statements.
  - rootNode
```
public TParseTreeNode rootNode
```
    Original Parse tree node from parser
  - isparsed
```
protected boolean isparsed
```
- Constructor Detail
  - TCustomSqlStatement
```
public TCustomSqlStatement(EDbVendor dbvendor)
```
- Method Detail
  - getIndexColumns
```
public TPTNodeList<TColumnWithSortOrder> getIndexColumns()
```
  - setVariableStack
```
public void setVariableStack(Stack<TObjectName> variableStack)
```
  - getVariableStack
```
public Stack<TObjectName> getVariableStack()
```
  - getDaxFunctionStack
```
public Stack<TDaxFunction> getDaxFunctionStack()
```
  - setLabelName
```
public void setLabelName(TObjectName lName)
```
  - getLabelName
```
public TObjectName getLabelName()
```
    Returns:
    
    label name used in plsql statement.
  - setEndlabelName
```
public void setEndlabelName(TObjectName endlabelName)
```
  - getEndlabelName
```
public TObjectName getEndlabelName()
```
  - getTargetTable
```
public TTable getTargetTable()
```
    target table in the delete/insert/update/create table statement.
    
    See Also:
    
    joins, TSelectSqlStatement, TDeleteSqlStatement, TUpdateSqlStatement, TCreateTableSqlStatement, TMergeSqlStatement
  - setTargetTable
```
public void setTargetTable(TTable targetTable)
```
  - getJoins
```
public TJoinList getJoins()
```
  - getTables
```
public TTableList getTables()
```
  - getStatements
```
public TStatementList getStatements()
```
    Saves all first level sub statements.
    By iterating statements recursively, you can fetch all included statements in an easy way.
    select f1+(select f2 from t2) from t1 where f2 > all (select f3 from t3 where f4 = (select f5 from t4))
    Statements included in above SQL was save in a hierarchical way like this:
    - (select f2 from t2)
    - (select f3 from t3 where f4 = (select f5 from t4))
      
      (select f5 from t4)
    If this statement is a create procedure/function statement, then all declaration statements and statements in procedure body can also be fetched quickly by iterating this property recursively.
  - setCteList
```
public void setCteList(TCTEList cteList)
```
  - getCteList
```
public TCTEList getCteList()
```
    Multiple common table expressions TCTE 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.
    Used in select, delete, update statement.
    
    Returns:
    
    List of common table expression.
  - setResultColumnList
```
public void setResultColumnList(TResultColumnList resultColumnList)
```
  - getResultColumnList
```
public TResultColumnList getResultColumnList()
```
    In select statement, this method returns Items in select_list. Can be *, expr, and name.*
    
    In update statement, this method returns assignments in set clause.
    
    Returns:
    
    select list of select statement or assignments of update statement.
  - setReturningClause
```
public void setReturningClause(TReturningClause returningClause)
```
  - getReturningClause
```
public TReturningClause getReturningClause()
```
    Returns:
    
    returning clause.
  - setOutputClause
```
public void setOutputClause(TOutputClause outputClause)
```
  - getOutputClause
```
public TOutputClause getOutputClause()
```
    Returns:
    
    output clause.
  - setTopClause
```
public void setTopClause(TTopClause topClause)
```
  - getTopClause
```
public TTopClause getTopClause()
```
    Returns:
    
    top clause.
  - setWhereClause
```
public void setWhereClause(TWhereClause whereClause)
```
  - addWhereClause
```
public TWhereClause addWhereClause(String condition)
```
  - getWhereClause
```
public TWhereClause getWhereClause()
```
    restrict the rows selected to those that satisfy one or more conditions. used in select, delete, update statement.
    
    Returns:
    
    where clause.
  - searchCTEList
```
protected TCTEList searchCTEList()
```
  - getParentStmt
```
public TCustomSqlStatement getParentStmt()
```
  - setParentStmt
```
public void setParentStmt(TCustomSqlStatement parentStmt)
```
  - getAncestorStmt
```
public TCustomSqlStatement getAncestorStmt()
```
  - getSymbolTable
```
public Stack getSymbolTable()
```
  - getErrorCount
```
public int getErrorCount()
```
    Number of syntax errors for this statement.
    
    Returns:
    
    0 means no syntax error.
  - parseerrormessagehandle
```
public EActionOnParseError parseerrormessagehandle(TSyntaxError se)
```
    Log error messages if syntax errors found while parsing this statement.
    
    Parameters:
    
    se - syntax error structure.
    
    Returns:
    
    type of error
  - parsestatement
```
public int parsestatement(TCustomSqlStatement pparentsql,
                          boolean isparsetreeavailable)
```
    Parse this statement.
    
    Parameters:
    
    pparentsql -
    
    isparsetreeavailable -
    
    Returns:
    
    parse result, zero means no syntax error found.
  - OracleStatementCanBeSeparatedByBeginEndPair
```
public boolean OracleStatementCanBeSeparatedByBeginEndPair()
```
  - VerticaStatementCanBeSeparatedByBeginEndPair
```
public boolean VerticaStatementCanBeSeparatedByBeginEndPair()
```
  - isnzplsql
```
public boolean isnzplsql()
```
  - ispgplsql
```
public boolean ispgplsql()
```
  - isverticaplsql
```
public boolean isverticaplsql()
```
  - isoracleplsql
```
public boolean isoracleplsql()
```
  - dochecksyntax
```
protected int dochecksyntax(TCustomSqlStatement psql)
```
  - clearError
```
public void clearError()
```
  - doParseStatement
```
public int doParseStatement(TCustomSqlStatement psql)
```
  - analyzeTablename
```
public TTable analyzeTablename(TObjectName tableName)
```
  - isTableACTE
```
protected boolean isTableACTE(TTable pTable)
```
  - findTable
```
public TTable findTable(ETableEffectType pTableEffectType)
```
  - addToTables
```
public void addToTables(TTable pTable)
```
  - analyzeFromTable
```
public TTable analyzeFromTable(TFromTable pfromTable,
                               Boolean addToTableList)
```
  - analyzeJoin
```
public TJoin analyzeJoin(TJoinExpr pJoinExpr,
                         TJoin pJoin,
                         Boolean isSub)
```
  - locateVariableOrParameter
```
public boolean locateVariableOrParameter(TObjectName cr)
```
  - fireOnMetaDatabaseTableColumn
```
protected boolean fireOnMetaDatabaseTableColumn(String pServer,
                                                String pDatabase,
                                                String pSchema,
                                                String pTable,
                                                String pColumn)
```
  - getFirstPhysicalTable
```
public TTable getFirstPhysicalTable()
```
  - getOrphanColumns
```
public TObjectNameList getOrphanColumns()
```
  - linkToFirstTable
```
protected boolean linkToFirstTable(TObjectName pColumn,
                                   int pCandidateTableCnt)
```
  - searchDaxVariableInStack
```
public boolean searchDaxVariableInStack(TObjectName pName)
```
  - linkColumnToTable
```
public boolean linkColumnToTable(TObjectName pColumn,
                                 ESqlClause pLocation)
```
  - linkColumnReferenceToTable
```
public void linkColumnReferenceToTable(TObjectName cr,
                                       ESqlClause plocation)
```
    Deprecated. As of v1.6.0.1, use linkColumnToTable(gudusoft.gsqlparser.nodes.TObjectName, gudusoft.gsqlparser.ESqlClause) instead
  - checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt
```
public boolean checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt(TObjectName crf,
                                                                       boolean sameLevelOnly)
```
    Found out is a non qualified column is a column in uplevel subquery table like this: take ma_parkey for example: ma_parkey is not a physical column SELECT c_mandant , CASE WHEN EXISTS (SELECT 1 FROM CDS_H_GRUPPE GRP1 WHERE GRP1.c_mandant = c_mandant AND GRP1.parkey1 = ma_parkey) THEN 1 ELSE NULL END MA_ME FROM (SELECT c_mandant , CASE WHEN funktionscode = 'U' THEN parkey1 ELSE parkey2 END MA_PARKEY FROM CDS_H_GRUPPE )
  - getTopStatement
```
public TCustomSqlStatement getTopStatement()
```

Class TCustomSqlStatement

Field Summary

Constructor Summary

Method Summary

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

Methods inherited from class java.lang.Object

Field Detail

sqlstatementtype

sourcetokenlist

dbvendor

parser

plsqlparser

dummytag

joins

tables

rootNode

isparsed

Constructor Detail

TCustomSqlStatement

Method Detail

getIndexColumns

setVariableStack

getVariableStack

getDaxFunctionStack

setLabelName

getLabelName

setEndlabelName

getEndlabelName

getTargetTable

setTargetTable

getJoins

getTables

getStatements

setCteList

getCteList

setResultColumnList

getResultColumnList

setReturningClause

getReturningClause

setOutputClause

getOutputClause

setTopClause

getTopClause

setWhereClause

addWhereClause

getWhereClause

searchCTEList

getParentStmt

setParentStmt

getAncestorStmt

getSymbolTable

getErrorCount

parseerrormessagehandle

parsestatement

OracleStatementCanBeSeparatedByBeginEndPair

VerticaStatementCanBeSeparatedByBeginEndPair

isnzplsql

ispgplsql

isverticaplsql

isoracleplsql

dochecksyntax

clearError

doParseStatement

analyzeTablename

isTableACTE

findTable

addToTables

analyzeFromTable

analyzeJoin

locateVariableOrParameter

fireOnMetaDatabaseTableColumn

getFirstPhysicalTable

getOrphanColumns

linkToFirstTable

searchDaxVariableInStack

linkColumnToTable

linkColumnReferenceToTable

checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt

getTopStatement