| Class and Description |
|---|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| Class and Description |
|---|
| EActionOnParseError
Used by parser internally.
|
| EAggregateType |
| EAlterColumnSubType
subtype of alter column in alter table statement.
|
| EAlterIndexOption |
| EAlterTableOptionType |
| EAlterTriggerOption |
| EAlterViewOption |
| EBoundaryType |
| EBTEQCmdType |
| EColumnAttributeType |
| EComparisonType |
| EComputeFunctionType |
| EConstraintType |
| ECreateTableOption |
| EDataType |
| EDataTypeAttribute
Teradata datatype attribute
|
| EDbObjectType |
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| EDeclareType |
| EErrorType
Type of SQL syntax errors.
|
| EExecType |
| EExecuteAsOption
SQL Server execute as option
|
| EExecuteOptionKind |
| EExpressionType
scalar expression: return a single value. |
| EFileFormat |
| EFindSqlStateType
Used by parser internally.
|
| EFunctionReturnsType |
| EFunctionType |
| EGroupingSetType |
| EIndexType |
| EInsertSource
source of insert value
|
| EIntervalType |
| EIsolationLevel |
| EJoinType |
| EKeyActionType |
| EKeyReferenceType |
| EKeywordType |
| ELimitRowType |
| ELiteralType
Type of
TConstant |
| ELockMode |
| ENullOrder |
| EOracleCreateType |
| EParameterMode |
| EProcedureOptionType |
| EQuantifierType |
| EQueryHint
query hint type
|
| EQuoteType |
| ERaiseLevel |
| ERestrictionType
Oracle/DB2 create view, subquery restriction clause
|
| EResultSetsOptionKind |
| EResultSetType |
| ESelectModifier |
| ESequenceOptionType |
| ESetOperatorType |
| ESetScope |
| ESetStatementType |
| ESortType
Used to replace TBaseType.srtNone,srtAsc and srtDesc
|
| ESqlClause
Enum for various SQL clause such as where clause, having clause and etc.
|
| ESqlPlusCmd |
| ESqlStatementType
Type of SQL statement.
|
| ETableEffectType |
| ETableElementType |
| ETableKind |
| ETablePartitionType |
| ETableSource |
| ETokenStatus
Used by parser internally.
|
| ETokenType
Type of source token.
|
| ETransactionIsolationLevel |
| ETriggerActionTime
A specification that indicates when triggered SQL statements perform in relation to the triggering event.
|
| ETriggerDmlType |
| ETriggerGranularity |
| ETriggerReferencingType |
| ETriggerTimingPoint |
| EUniqueRowFilterType |
| EWindowExcludeType |
| IMetaDatabase
Deprecated.
As of v2.0.3.1, please use
TSQLEnv instead
In order to link column to table correctly without connecting to database,
we need to provide a class which implements IMetaDatabase to TGSqlParser.
this class tells TGSqlParser the relation ship between column and table.
Take this SQL for example: SELECT Quantity,b.Time,c.Description FROM (SELECT ID2,Time FROM bTab) b INNER JOIN aTab a on a.ID=b.ID INNER JOIN cTab c on a.ID=c.ID General SQL Parser can build relationship between column: ID2 and table: bTable correctly without metadata information from database because there is only one table in from clause. But it can't judge column: Quantity belong to table: aTab or cTab, since no table alias was prefixed to column: Quantity. If no metadata provided, General SQL Parser will link column: Quantity to the first valid table (here it is aTab) If we create a class metaDB implements IMetaDatabase,then TGSqlParser.setMetaDatabase(new metaDB()), General SQL Parser can take this advantage to create a correct relationship between column and tables. Here is a sample of metaDB, you should create your own metaDB class with meta information from database.
public class metaDB implements IMetaDatabase {
String columns[][] = {
{"dbo","aTab","Quantity1"},
{"dbo","bTab","Quantity2"},
{"dbo","cTab","Quantity"}
};
public boolean checkColumn(String schema, String table, String column){
boolean bSchema,bTable,bColumn,bRet = false;
for (int i=0; i<columns.length;i++){
if (schema == null){
bSchema = true;
}else{
bSchema = columns[i][0].equalsIgnoreCase(schema);
}
if (!bSchema) continue;
bTable = columns[i][1].equalsIgnoreCase(table);
if (!bTable) continue;
bColumn = columns[i][2].equalsIgnoreCase(column);
if (!bColumn) continue;
bRet =true;
break;
}
return bRet;
}
}
After TGSqlParser.setMetaDatabase(new metaDB()), General SQL parser can generate this result for you: atab.id btab.id btab.time ctab.description ctab.id ctab.quantity |
| IRelation |
| ISQLStatementHandle
This is the interface for handling SQL statements after parsing each SQL statement.
|
| ITokenHandle
use this interface if you like to change token properties generated by lexer
before send to parser.
if you change a source token's TSourceToken#tokencode to TBaseType#cmtslashstar TBaseType#cmtdoublehyphen then, this token will be treated as comment you may also like to change tokencode of a keyword to TBaseType#ident, this will let parser treat this keyword as an identifier. |
| ITokenListHandle |
| TAttributeNode
TAttributeNode 类似 column，但含义更广泛。用来表示 SQL 语句中 table 包含的字段(table 或许用 relation 更准确)。
这里的 table 可以是数据库的基本表，也可以是 from clause 中出现的子查询，或者是 CTE。
GSP 会把 SQL 语句中出现的每个 table 都生成对应的 TAttributeNode 列表，表示该 table 可以在 SQL 中被使用的字段。
例如：一般 table
select column1 from table1
GSP 会在 SQLEnv 中查找 table1 的定义，如果找到（column1,column2,column3）, 则 table 会创建三个对应的 TAttributeNode。
用户可以通过
TTable.getAttributes() 来获取。
如果SQLEnv 中没有查找 table1 的定义，则创建一个 star column TAttributeNode， 形如 table1.*
例如：子查询
select column1 from (select c1,c2 from table1) t1
针对上例中的 t1 子查询， GSP 会创建两个 TAttributeNode，对应 t1.c1, t1.c2
针对其他类型的 table， 也做类似处理。为 SQL 中的每个 table 准备好 TAttributeNode 列表，
在接下来的分析中，SQL 语句中出现的 column 引用都应该能找到对应的来源表和 TAttributeNode
相关的属性
TAttributeNode.getName(), 字段名，不带前缀。
TAttributeNode.getTable_ref(), 该字段对应的 table，每个在 SQL 语句中出现的 table 都有对应的 TTable 对象。
TAttributeNode.getSqlColumn(), 如果在 SQLEnv 中找到该 table 的定义，这个方法返回数据库中定义的字段、
TAttributeNode.getSubLevelResultColumn(), 如果 table 类型为子查询，该方法返回子查询 select list 中的 TResultColumn 对象，为该字段的数据来源。
或者是 values() 中的 result column。 |
| TCustomLexer
Base lexer of all databases.
|
| TCustomParser
Base parser of all databases.
|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TGSqlParser
This is the first class people start to use this SQL parser library.
|
| TLog |
| TSingletonParser |
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| TSourceTokenList
List of source token.
|
| TSqlCmds.TSqlCmd |
| TSqlCmds.TSqlCmdList |
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| TSyntaxError
Detailed information about syntax error.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TGSqlParser
This is the first class people start to use this SQL parser library.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| EJoinType |
| EParameterMode |
| ESetOperatorType |
| ESqlClause
Enum for various SQL clause such as where clause, having clause and etc.
|
| ESqlStatementType
Type of SQL statement.
|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EAggregateType |
| EAlterColumnSubType
subtype of alter column in alter table statement.
|
| EAlterIndexOption |
| EAlterTableOptionType |
| EAlterTriggerOption |
| EAlterViewOption |
| EBoundaryType |
| EColumnAttributeType |
| EComparisonType |
| EComputeFunctionType |
| EConstraintType |
| ECreateTableOption |
| EDataType |
| EDataTypeAttribute
Teradata datatype attribute
|
| EDbObjectType |
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| EDeclareType |
| EExecType |
| EExpressionType
scalar expression: return a single value. |
| EFileFormat |
| EFunctionType |
| EGroupingSetType |
| EIndexType |
| EIntervalType |
| EIsolationLevel |
| EJoinType |
| EKeyActionType |
| EKeyReferenceType |
| ELimitRowType |
| ELiteralType
Type of
TConstant |
| ELockMode |
| ENullOrder |
| EParameterMode |
| EQuantifierType |
| EQueryHint
query hint type
|
| EQuoteType |
| ERestrictionType
Oracle/DB2 create view, subquery restriction clause
|
| ESelectModifier |
| ESequenceOptionType |
| ESetScope |
| ESetStatementType |
| ESortType
Used to replace TBaseType.srtNone,srtAsc and srtDesc
|
| ESqlClause
Enum for various SQL clause such as where clause, having clause and etc.
|
| ESqlStatementType
Type of SQL statement.
|
| ETableEffectType |
| ETableKind |
| ETablePartitionType |
| ETableSource |
| ETransactionIsolationLevel |
| ETriggerActionTime
A specification that indicates when triggered SQL statements perform in relation to the triggering event.
|
| ETriggerGranularity |
| ETriggerReferencingType |
| ETriggerTimingPoint |
| EUniqueRowFilterType |
| EWindowExcludeType |
| IRelation |
| TAttributeNode
TAttributeNode 类似 column，但含义更广泛。用来表示 SQL 语句中 table 包含的字段(table 或许用 relation 更准确)。
这里的 table 可以是数据库的基本表，也可以是 from clause 中出现的子查询，或者是 CTE。
GSP 会把 SQL 语句中出现的每个 table 都生成对应的 TAttributeNode 列表，表示该 table 可以在 SQL 中被使用的字段。
例如：一般 table
select column1 from table1
GSP 会在 SQLEnv 中查找 table1 的定义，如果找到（column1,column2,column3）, 则 table 会创建三个对应的 TAttributeNode。
用户可以通过
TTable.getAttributes() 来获取。
如果SQLEnv 中没有查找 table1 的定义，则创建一个 star column TAttributeNode， 形如 table1.*
例如：子查询
select column1 from (select c1,c2 from table1) t1
针对上例中的 t1 子查询， GSP 会创建两个 TAttributeNode，对应 t1.c1, t1.c2
针对其他类型的 table， 也做类似处理。为 SQL 中的每个 table 准备好 TAttributeNode 列表，
在接下来的分析中，SQL 语句中出现的 column 引用都应该能找到对应的来源表和 TAttributeNode
相关的属性
TAttributeNode.getName(), 字段名，不带前缀。
TAttributeNode.getTable_ref(), 该字段对应的 table，每个在 SQL 语句中出现的 table 都有对应的 TTable 对象。
TAttributeNode.getSqlColumn(), 如果在 SQLEnv 中找到该 table 的定义，这个方法返回数据库中定义的字段、
TAttributeNode.getSubLevelResultColumn(), 如果 table 类型为子查询，该方法返回子查询 select list 中的 TResultColumn 对象，为该字段的数据来源。
或者是 values() 中的 result column。 |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TGSqlParser
This is the first class people start to use this SQL parser library.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| TSourceTokenList
List of source token.
|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| EIndexType |
| ESortType
Used to replace TBaseType.srtNone,srtAsc and srtDesc
|
| Class and Description |
|---|
| ESortType
Used to replace TBaseType.srtNone,srtAsc and srtDesc
|
| ESqlClause
Enum for various SQL clause such as where clause, having clause and etc.
|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| ESqlClause
Enum for various SQL clause such as where clause, having clause and etc.
|
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EFileFormat |
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| Class and Description |
|---|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| Class and Description |
|---|
| EExecuteAsOption
SQL Server execute as option
|
| EExecuteOptionKind |
| EProcedureOptionType |
| EResultSetsOptionKind |
| EResultSetType |
| ESqlStatementType
Type of SQL statement.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| Class and Description |
|---|
| ESqlClause
Enum for various SQL clause such as where clause, having clause and etc.
|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| Class and Description |
|---|
| ESqlClause
Enum for various SQL clause such as where clause, having clause and etc.
|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| ESqlClause
Enum for various SQL clause such as where clause, having clause and etc.
|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EBTEQCmdType |
| ESqlClause
Enum for various SQL clause such as where clause, having clause and etc.
|
| ESqlStatementType
Type of SQL statement.
|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| Class and Description |
|---|
| ESqlClause
Enum for various SQL clause such as where clause, having clause and etc.
|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| Class and Description |
|---|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| TSourceTokenList
List of source token.
|
| Class and Description |
|---|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TGSqlParser
This is the first class people start to use this SQL parser library.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| Class and Description |
|---|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| ETokenType
Type of source token.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| TSourceTokenList
List of source token.
|
| Class and Description |
|---|
| TAttributeNode
TAttributeNode 类似 column，但含义更广泛。用来表示 SQL 语句中 table 包含的字段(table 或许用 relation 更准确)。
这里的 table 可以是数据库的基本表，也可以是 from clause 中出现的子查询，或者是 CTE。
GSP 会把 SQL 语句中出现的每个 table 都生成对应的 TAttributeNode 列表，表示该 table 可以在 SQL 中被使用的字段。
例如：一般 table
select column1 from table1
GSP 会在 SQLEnv 中查找 table1 的定义，如果找到（column1,column2,column3）, 则 table 会创建三个对应的 TAttributeNode。
用户可以通过
TTable.getAttributes() 来获取。
如果SQLEnv 中没有查找 table1 的定义，则创建一个 star column TAttributeNode， 形如 table1.*
例如：子查询
select column1 from (select c1,c2 from table1) t1
针对上例中的 t1 子查询， GSP 会创建两个 TAttributeNode，对应 t1.c1, t1.c2
针对其他类型的 table， 也做类似处理。为 SQL 中的每个 table 准备好 TAttributeNode 列表，
在接下来的分析中，SQL 语句中出现的 column 引用都应该能找到对应的来源表和 TAttributeNode
相关的属性
TAttributeNode.getName(), 字段名，不带前缀。
TAttributeNode.getTable_ref(), 该字段对应的 table，每个在 SQL 语句中出现的 table 都有对应的 TTable 对象。
TAttributeNode.getSqlColumn(), 如果在 SQLEnv 中找到该 table 的定义，这个方法返回数据库中定义的字段、
TAttributeNode.getSubLevelResultColumn(), 如果 table 类型为子查询，该方法返回子查询 select list 中的 TResultColumn 对象，为该字段的数据来源。
或者是 values() 中的 result column。 |
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| EComparisonType |
| EExpressionType
scalar expression: return a single value. |
| ETokenType
Type of source token.
|
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| TSourceTokenList
List of source token.
|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| Class and Description |
|---|
| EAlterIndexOption |
| EAlterTriggerOption |
| EAlterViewOption |
| EDbObjectType |
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| EDeclareType |
| EExecType |
| EFunctionReturnsType |
| EIndexType |
| EInsertSource
source of insert value
|
| EKeyReferenceType |
| ELockMode |
| ERaiseLevel |
| ESetOperatorType |
| ESetStatementType |
| ETableKind |
| ETransactionIsolationLevel |
| ETriggerDmlType |
| ETriggerTimingPoint |
| IProcExchange |
| IRelation |
| TAttributeNode
TAttributeNode 类似 column，但含义更广泛。用来表示 SQL 语句中 table 包含的字段(table 或许用 relation 更准确)。
这里的 table 可以是数据库的基本表，也可以是 from clause 中出现的子查询，或者是 CTE。
GSP 会把 SQL 语句中出现的每个 table 都生成对应的 TAttributeNode 列表，表示该 table 可以在 SQL 中被使用的字段。
例如：一般 table
select column1 from table1
GSP 会在 SQLEnv 中查找 table1 的定义，如果找到（column1,column2,column3）, 则 table 会创建三个对应的 TAttributeNode。
用户可以通过
TTable.getAttributes() 来获取。
如果SQLEnv 中没有查找 table1 的定义，则创建一个 star column TAttributeNode， 形如 table1.*
例如：子查询
select column1 from (select c1,c2 from table1) t1
针对上例中的 t1 子查询， GSP 会创建两个 TAttributeNode，对应 t1.c1, t1.c2
针对其他类型的 table， 也做类似处理。为 SQL 中的每个 table 准备好 TAttributeNode 列表，
在接下来的分析中，SQL 语句中出现的 column 引用都应该能找到对应的来源表和 TAttributeNode
相关的属性
TAttributeNode.getName(), 字段名，不带前缀。
TAttributeNode.getTable_ref(), 该字段对应的 table，每个在 SQL 语句中出现的 table 都有对应的 TTable 对象。
TAttributeNode.getSqlColumn(), 如果在 SQLEnv 中找到该 table 的定义，这个方法返回数据库中定义的字段、
TAttributeNode.getSubLevelResultColumn(), 如果 table 类型为子查询，该方法返回子查询 select list 中的 TResultColumn 对象，为该字段的数据来源。
或者是 values() 中的 result column。 |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| TSourceTokenList
List of source token.
|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| EIndexType |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| ESqlStatementType
Type of SQL statement.
|
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| EDbObjectType |
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| EDeclareType |
| EExecType |
| EExecuteAsOption
SQL Server execute as option
|
| ESqlStatementType
Type of SQL statement.
|
| ETriggerDmlType |
| ETriggerTimingPoint |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| TSourceTokenList
List of source token.
|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| EDeclareType |
| ESetStatementType |
| ESqlStatementType
Type of SQL statement.
|
| ETransactionIsolationLevel |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| EOracleCreateType |
| ESqlPlusCmd |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| TStatementList
List of SQL statements which is instance of class that descends from
TCustomSqlStatement. |
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbObjectType |
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| EFileFormat |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| EFindSqlStateType
Used by parser internally.
|
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| TSourceToken
Represents a source token which is the basic syntactic unit of SQL.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| IRelation |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|
| Class and Description |
|---|
| EDbVendor
Database vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,
EDbVendor.dbvsybase, EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,
EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESS EDbVendor.dbvaccess, use EDbVendor.dbvmssql instead. |
| TCustomSqlStatement
TCustomSqlStatement is the root class for all SQL statements.
|