| 
 | ||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectorg.eclipse.datatools.sqltools.parsers.sql.query.SQLQueryParserFactory
public class SQLQueryParserFactory
This class provides methods for creating elements of the SQL query model. I wraps the factories: - RDBSchemaFactory
| Field Summary | |
|---|---|
| static java.lang.String | ALLString constant for QuerySelect "ALL" | 
| static int | COMBINED_OPERATOR_ADDint constant for ValueExpressionCombinedOperator.ADD"+" | 
| static int | COMBINED_OPERATOR_ANDint constant for SearchConditionCombinedOperator.AND | 
| static int | COMBINED_OPERATOR_CONCATENATEint constant for ValueExpressionCombinedOperator.CONCATENATE"||" | 
| static int | COMBINED_OPERATOR_DIVIDEint constant for ValueExpressionCombinedOperator.DIVIDE"/" | 
| static int | COMBINED_OPERATOR_MULTIPLYint constant for ValueExpressionCombinedOperator.MULTIPLY"*" | 
| static int | COMBINED_OPERATOR_ORint constant for SearchConditionCombinedOperator.OR | 
| static int | COMBINED_OPERATOR_SUBTRACTint constant for ValueExpressionCombinedOperator.SUBTRACT"-" | 
| static int | COMPARISON_OPERATOR_EQint constant for PredicateComparisonOperator.EQUAL"=" | 
| static int | COMPARISON_OPERATOR_GEint constant for PredicateComparisonOperator.GREATER_THAN_OR_EQUAL">=" | 
| static int | COMPARISON_OPERATOR_GTint constant for PredicateComparisonOperator.GREATER_THAN">" | 
| static int | COMPARISON_OPERATOR_LEint constant for PredicateComparisonOperator.LESS_THAN_OR_EQUAL"<=" | 
| static int | COMPARISON_OPERATOR_LTint constant for PredicateComparisonOperator.LESS_THAN"<" | 
| static int | COMPARISON_OPERATOR_NEint constant for PredicateComparisonOperator.NOT_EQUAL"<>" | 
| static java.lang.String | DISTINCTString constant for QuerySelect "DISTINCT" | 
| static int | DURATION_TYPE_DAYSint constant for ValueExpressionLabeledDurationType.DAYS | 
| static int | DURATION_TYPE_HOURSint constant for ValueExpressionLabeledDurationType.HOURS | 
| static int | DURATION_TYPE_MICROSECONDSint constant for ValueExpressionLabeledDurationType.MICROSECONDS | 
| static int | DURATION_TYPE_MINUTESint constant for ValueExpressionLabeledDurationType.MINUTES | 
| static int | DURATION_TYPE_MONTHSint constant for ValueExpressionLabeledDurationType.MONTHS | 
| static int | DURATION_TYPE_SECONDSint constant for ValueExpressionLabeledDurationType.SECONDS | 
| static int | DURATION_TYPE_YEARSint constant for ValueExpressionLabeledDurationType.YEARS | 
| static int | JOIN_DEFAULT_INNERint constant for TableJoinedOperator.DEFAULT_INNER"JOIN" | 
| static int | JOIN_EXPLICIT_INNERint constant for TableJoinedOperator.EXPLICIT_INNER"INNER JOIN" | 
| static int | JOIN_FULL_OUTERint constant for TableJoinedOperator.FULL_OUTER"FULL JOIN" | 
| static int | JOIN_LEFT_OUTERint constant for TableJoinedOperator.LEFT_OUTER"LEFT JOIN" | 
| static int | JOIN_RIGHT_OUTERint constant for TableJoinedOperator.RIGHT_OUTER"RIGHT JOIN" | 
| static int | NULL_ORDERING_TYPE_NONEint constant for NullOrderingType.NONE | 
| static int | NULL_ORDERING_TYPE_NULLS_FIRSTint constant for NullOrderingType.NULLS_FIRST | 
| static int | NULL_ORDERING_TYPE_NULLS_LASTint constant for NullOrderingType.NULLS_LAST | 
| static java.lang.String | ORDER_ASCString constant for OrderBySpecification "ASC" | 
| static java.lang.String | ORDER_DESCString constant for OrderBySpecification "DESC" | 
| static int | ORDERING_SPEC_TYPE_ASCint constant for OrderingSpecType.ASC | 
| static int | ORDERING_SPEC_TYPE_DESCint constant for OrderingSpecType.DESC | 
| static int | ORDERING_SPEC_TYPE_NONEint constant for OrderingSpecType.NONE | 
| static int | QUANTIFIER_ALLint constant for PredicateQuantifiedType.ALL"ALL" | 
| static int | QUANTIFIER_ANYint constant for PredicateQuantifiedType.ANY"ANY" | 
| static int | QUANTIFIER_SOMEint constant for PredicateQuantifiedType.SOME"SOME" | 
| static int | QUERY_COMBINED_EXCEPTint constant for QueryCombinedOperator.EXCEPT"EXCEPT" | 
| static int | QUERY_COMBINED_EXCEPT_ALLint constant for QueryCombinedOperator.EXCEPT_ALL"EXCEPT ALL" | 
| static int | QUERY_COMBINED_INTERSECTint constant for QueryCombinedOperator.INTERSECT"INTERSECT" | 
| static int | QUERY_COMBINED_INTERSECT_ALLint constant for QueryCombinedOperator.INTERSECT_ALL"INTERSECT ALL" | 
| static int | QUERY_COMBINED_UNIONint constant for QueryCombinedOperator.UNION"UNION" | 
| static int | QUERY_COMBINED_UNION_ALLint constant for QueryCombinedOperator.UNION_ALL"UNION ALL" | 
| static java.lang.String | SPECIAL_REGISTER_CURRENT_DATEString constant for special register, value "CURRENT_DATE" | 
| static java.lang.String | SPECIAL_REGISTER_CURRENT_DEFAULT_TRANSFORM_GROUPString constant for special register, value "CURRENT_DEFAULT_TRANSFORM_GROUP" | 
| static java.lang.String | SPECIAL_REGISTER_CURRENT_PATHString constant for special register, value "CURRENT_PATH" | 
| static java.lang.String | SPECIAL_REGISTER_CURRENT_ROLEString constant for special register, value "CURRENT_ROLE" | 
| static java.lang.String | SPECIAL_REGISTER_CURRENT_TIMEString constant for special register, value "CURRENT_TIME" | 
| static java.lang.String | SPECIAL_REGISTER_CURRENT_TIMESTAMPString constant for special register, value "CURRENT_TIMESTAMP" | 
| static java.lang.String | SPECIAL_REGISTER_CURRENT_TRANSFORM_GROUP_FOR_TYPEString constant for special register, value "CURRENT_TRANSFORM_GROUP_FOR_TYPE" | 
| static java.lang.String | SPECIAL_REGISTER_CURRENT_USERString constant for special register, value "CURRENT_USER" | 
| static java.lang.String | SPECIAL_REGISTER_LOCALTIMEString constant for special register, value "LOCALTIME" | 
| static java.lang.String | SPECIAL_REGISTER_LOCALTIMESTAMPString constant for special register, value "LOCALTIMESTAMP" | 
| static java.lang.String | SPECIAL_REGISTER_SESSION_USERString constant for special register, value "SESSION_USER" | 
| static java.lang.String | SPECIAL_REGISTER_SYSTEM_USERString constant for special register, value "SYSTEM_USER" | 
| static java.lang.String | SPECIAL_REGISTER_USERString constant for special register, value "USER" | 
| static java.lang.String | SPECIAL_REGISTER_VALUEString constant for special register, value "VALUE" | 
| static int | SUPERGROUP_TYPE_CUBEint constant for SuperGroupType.CUBE | 
| static int | SUPERGROUP_TYPE_GRANDTOTALint constant for SuperGroupType.GRANDTOTAL | 
| static int | SUPERGROUP_TYPE_ROLLUPint constant for SuperGroupType.ROLLUP | 
| static int | UNARY_OPERATOR_MINUSint constant for ValueExpressionUnaryOperator.MINUS"-" | 
| static int | UNARY_OPERATOR_PLUSint constant for ValueExpressionUnaryOperator.PLUS"+" | 
| static int | UPDATABILITY_TYPE_FOR_READ_ONLYint constant for UpdatabilityType.READ_ONLY"FOR READ ONLY" | 
| static int | UPDATABILITY_TYPE_FOR_UPDATEint constant for UpdatabilityType.UPDATE"FOR UPDATE" | 
| Constructor Summary | |
|---|---|
| SQLQueryParserFactory()Constructs an instance of this class. | |
| SQLQueryParserFactory(SQLQuerySourceFormat aSourceFormat)Constructor. | |
| Method Summary | |
|---|---|
|  TableExpression | addTableCorrelationToTableExpression(TableExpression tableExpr,
                                     TableCorrelation tableCorrelation)Adds the given tableCorrelationto the giventableExpr. | 
|  CallStatement | createCallStatement(ProcedureReference procRef,
                    java.util.List argList) | 
|  ValueExpressionCaseElse | createCaseElse(QueryValueExpression expr) | 
|  ValueExpressionCaseSearchContent | createCaseSearchContent(QuerySearchCondition aWhenCond,
                        QueryValueExpression aExpr) | 
|  ValueExpressionCaseSearch | createCaseSearchExpression(java.util.List aCaseSearchWhenList,
                           ValueExpressionCaseElse aCaseElse) | 
|  java.util.List | createCaseSearchList(java.util.List aCaseSearchList,
                     ValueExpressionCaseSearchContent aCaseSearchContent) | 
|  ValueExpressionCaseSimpleContent | createCaseSimpleContent(QueryValueExpression aWhenExpr,
                        QueryValueExpression aResultExpr) | 
|  ValueExpressionCaseSimple | createCaseSimpleExpression(QueryValueExpression aCaseValue,
                           java.util.List aCaseSimpleWhenList,
                           ValueExpressionCaseElse aCaseElse) | 
|  java.util.List | createCaseSimpleList(java.util.List aCaseSimpleList,
                     ValueExpressionCaseSimpleContent aCaseSimpleContent) | 
|  ValueExpressionCast | createCastExpression(QueryValueExpression aExpr,
                     DataType aCastType) | 
|  ValueExpressionCast | createCastExpression(QueryValueExpression aExpr,
                     java.lang.String aCastType) | 
|  ValueExpressionColumn | createColumnExpression(java.lang.String aColumnName) | 
|  ValueExpressionColumn | createColumnExpression(java.lang.String aColumnName,
                       java.lang.String aQualifier) | 
|  ValueExpressionColumn | createColumnExpression(java.lang.String aColumnName,
                       java.lang.String aTableName,
                       java.lang.String aSchemaName)if the same table name and same column name is referenced in two different schemas and the tables in the FROM-clause are not given an alias name e.g. | 
|  java.util.List | createColumnList(java.util.List aColumnNameList,
                 ValueExpressionColumn aColumnExpr) | 
|  ColumnName | createColumnName(java.lang.String aColumnName) | 
|  java.util.List | createColumnNameList(java.util.List aColumnNameList,
                     ColumnName aColumnName) | 
|  SearchConditionCombined | createCombinedCondition(QuerySearchCondition aLeftCond,
                        QuerySearchCondition aRightCond,
                        int aCondOper) | 
|  ValueExpressionCombined | createCombinedExpression(QueryValueExpression aLeftExpr,
                         int aExprOper,
                         QueryValueExpression aRightExpr) | 
|  DataType | createDataType(java.lang.String aTypeName) | 
|  ArrayDataType | createDataTypeArray(DataType dataType)Factory method to construct a ArrayDataTypewith the
 element data typeelementDataType. | 
|  ArrayDataType | createDataTypeArray(DataType dataType,
                    int maxCardinality)Factory method to construct a ArrayDataTypewith the
 element data typeelementDataTypeand with maximum
 cardinality specified bymaxCardinality. | 
|  ArrayDataType | createDataTypeArray(DataType dataType,
                    int maxCardinality,
                    java.lang.String typeName) | 
|  BinaryStringDataType | createDataTypeBinaryString(int primitiveType,
                           int length,
                           java.lang.String optionalUnitsIndicator)Factory method to construct a BinaryStringDataTypewith
 itsprimitiveTypeandlength. | 
|  BinaryStringDataType | createDataTypeBinaryString(int primitiveType,
                           int length,
                           java.lang.String optionalUnitsIndicator,
                           java.lang.String typeName) | 
|  BooleanDataType | createDataTypeBoolean()Factory method to construct a BooleanDataTypewithprimitiveTypePrimitiveType.BOOLEAN_LITERAL. | 
|  BooleanDataType | createDataTypeBoolean(java.lang.String typeName) | 
|  CharacterStringDataType | createDataTypeCharacterString(int primitiveType,
                              int length,
                              java.lang.String optionalUnitsIndicator)Factory method to construct a CharacterStringDataTypewith
 itsprimitiveTypeandlength. | 
|  CharacterStringDataType | createDataTypeCharacterString(int primitiveType,
                              int length,
                              java.lang.String optionalUnitsIndicator,
                              java.lang.String typeName) | 
|  DataLinkDataType | createDataTypeDataLink(int length)TODO: finish method signature and doc properly! | 
|  DataLinkDataType | createDataTypeDataLink(int length,
                       java.lang.String typeName) | 
|  DateDataType | createDataTypeDate()Factory method to construct a DateDataTypewithprimitiveTypePrimitiveType.DATE_LITERAL. | 
|  DateDataType | createDataTypeDate(java.lang.String typeName) | 
|  DistinctUserDefinedType | createDataTypeDistinctUserDefinedType(java.lang.String aTypeName) | 
|  IntervalDataType | createDataTypeInterval(IntervalQualifierType leadingQualifier,
                       IntervalQualifierType trailingQualifier,
                       int leadingFieldPrecision,
                       int trailingFieldPrecision,
                       int fractionalSecondsPrecision)Factory method to construct a IntervalDataTypewithprimitiveTypePrimitiveType.INTERVAL. | 
|  IntervalDataType | createDataTypeInterval(IntervalQualifierType leadingQualifier,
                       IntervalQualifierType trailingQualifier,
                       int leadingFieldPrecision,
                       int trailingFieldPrecision,
                       int fractionalSecondsPrecision,
                       java.lang.String typeName) | 
|  MultisetDataType | createDataTypeMultiset(DataType dataType)Factory method to construct a MultisetDataTypewith the
 element data typeelementDataType. | 
|  MultisetDataType | createDataTypeMultiset(DataType dataType,
                       java.lang.String typeName) | 
|  ApproximateNumericDataType | createDataTypeNumericApproximate(int primitiveType,
                                 int precision)Factory method to construct a ApproximateNumericDataTypewith
 itsprimitiveTypeandprecision. | 
|  ApproximateNumericDataType | createDataTypeNumericApproximate(int primitiveType,
                                 int precision,
                                 java.lang.String typeName) | 
|  FixedPrecisionDataType | createDataTypeNumericFixedPrecision(int primitiveType,
                                    int precision,
                                    int scale)Factory method to construct a FixedPrecisionDataTypewith
 itsprimitiveType,precisionandscale. | 
|  FixedPrecisionDataType | createDataTypeNumericFixedPrecision(int primitiveType,
                                    int precision,
                                    int scale,
                                    java.lang.String typeName) | 
|  IntegerDataType | createDataTypeNumericInteger(int primitiveType,
                             int precision)Factory method to construct a IntegerDataTypewith
 itsprimitiveType. | 
|  IntegerDataType | createDataTypeNumericInteger(int primitiveType,
                             int precision,
                             java.lang.String typeName) | 
|  PredefinedDataType | createDataTypePredefinedDataType(java.lang.String typeName) | 
|  TimeDataType | createDataTypeTime(int primitiveType,
                   int precision)Factory method to construct a TimeDataTypewith
 itsprimitiveTypeandlength. | 
|  TimeDataType | createDataTypeTime(int primitiveType,
                   int precision,
                   java.lang.String typeName) | 
|  UserDefinedType | createDataTypeUserDefinedType(java.lang.String aSchemaName,
                              java.lang.String aTypeName) | 
|  ValueExpressionDefaultValue | createDefaultExpression() | 
|  QueryDeleteStatement | createDeleteStatement_deprecated(TableInDatabase aTargetTable,
                                 java.lang.String aAsTable,
                                 QuerySearchCondition aWhereClause)Deprecated. use #createDeleteStatement(SQLTableExpression, SQLTableCorrelation, SQLSearchCondition) | 
|  QueryDeleteStatement | createDeleteStatement(TableInDatabase aTargetTable,
                      TableCorrelation aAsTable,
                      QuerySearchCondition aWhereClause)[New Model] | 
|  DistinctUserDefinedType | createDistinctUserDefinedType(java.lang.String aTypeName) | 
|  java.util.List | createExpressionList(java.util.List aExprList,
                     QueryValueExpression aValExpr) | 
|  java.util.List | createFromClause(java.util.List aTableRefList,
                 TableReference aTableRef) | 
|  ValueExpressionFunction | createFunctionExpression(java.lang.String aFuncName,
                         java.lang.String distinct,
                         java.util.List aFuncParmList,
                         java.lang.String aSchemaName) | 
|  GroupingExpression | createGroupingExpression(QueryValueExpression aExpr) | 
|  GroupingSets | createGroupingSets(java.util.List aGroupingSetsElementList) | 
|  GroupingSetsElementExpression | createGroupingSetsElementExpression(Grouping aGrouping) | 
|  java.util.List | createGroupingSetsElementExprList(java.util.List aGroupingSetsElementExprList,
                                  GroupingSetsElementExpression aGroupingSetsElementExpr) | 
|  java.util.List | createGroupingSetsElementList(java.util.List aGroupingSetsElementList,
                              GroupingSetsElement aGroupingSetsElement) | 
|  GroupingSetsElementSublist | createGroupingSetsElementSublist(java.util.List aGroupingSetsElementExprList) | 
|  java.util.List | createGroupingSpecificationList(java.util.List aGroupingSpecList,
                                GroupingSpecification aGroupingSpec) | 
|  java.util.List | createInsertRow(java.util.List aInsertExprList,
                ValuesRow aInsertExpr) | 
|  QueryInsertStatement | createInsertStatement(TableInDatabase aTargetTable,
                      java.util.List aTargetColumnList,
                      java.util.List aSrcValuesRowList)Started to change right here! has either a list of source values aSrcValuesRowList rather than a SrcQuery | 
|  QueryInsertStatement | createInsertStatement(TableInDatabase aTargetTable,
                      java.util.List aColumnList,
                      QueryExpressionRoot aSrcQuery)has SrcQuery rather than a list of source values aSrcValuesRowList | 
|  ValuesRow | createInsertValuesRow(java.util.List aExprList) | 
|  ValuesRow | createInsertValuesRow(QueryValueExpression aValueExpr) | 
|  TableJoined | createJoinedTable(TableReference aLeftTable,
                  int aJoinType,
                  TableReference aRightTable,
                  QuerySearchCondition aJoinCond) | 
|  ValueExpressionLabeledDuration | createLabeledDurationExpression(QueryValueExpression aExpr,
                                int aDurationType) | 
|  MergeInsertSpecification | createMergeInsertSpecification(java.util.List aTargetColList,
                               ValuesRow aValuesRow) | 
|  MergeOnCondition | createMergeOnCondition(QuerySearchCondition aSearchCond) | 
|  java.util.List | createMergeOperatationSpecificationList(java.util.List aMergeSpecList,
                                        MergeOperationSpecification aMergeSpec)This is for as syntax hack in the parser. | 
|  MergeSourceTable | createMergeSourceTable(TableReference aTableRef) | 
|  QueryMergeStatement | createMergeStatement(MergeTargetTable aTargetTable,
                     MergeSourceTable aSourceTable,
                     MergeOnCondition aOnCondition,
                     java.util.List aOperSpecList) | 
|  MergeTargetTable | createMergeTargetTable(TableExpression aTableExpr,
                       java.lang.String aTableAliasName) | 
|  MergeUpdateSpecification | createMergeUpdateSpecification(java.util.List aAssignmentExprList) | 
|  SearchConditionNested | createNestedCondition(QuerySearchCondition aCondition) | 
|  SearchConditionNested | createNestedConditionNegated(QuerySearchCondition aCondition) | 
|  ValueExpressionNested | createNestedExpression(QueryValueExpression aNestedExpr) | 
|  TableNested | createNestedTable(TableReference aNestedTable) | 
|  ValueExpressionNullValue | createNullExpression() | 
|  java.util.List | createOrderByClause(java.util.List aOrderByList,
                    OrderBySpecification aOrderByExpr) | 
|  OrderBySpecification | createOrderByExpression(QueryValueExpression aOrderByExpr,
                        int orderingSpec,
                        int nullOrdering)creates an OrderBySpecification. | 
|  OrderBySpecification | createOrderByExpression(QueryValueExpression aOrderByExpr,
                        java.lang.String optAscDesc)Deprecated. use createOrderByExpression(QueryValueExpression, int, int) | 
|  PredefinedDataType | createPredefinedDataType(java.lang.String aTypeName) | 
|  PredicateBasic | createPredicateBasic(QueryValueExpression aLeftExpr,
                     int aRelOper,
                     QueryValueExpression aRightExpr) | 
|  PredicateBetween | createPredicateBetween(QueryValueExpression aLeftExpr,
                       boolean isNotBetween,
                       QueryValueExpression aRightExpr1,
                       QueryValueExpression aRightExpr2) | 
|  PredicateExists | createPredicateExists(QueryExpressionBody aQueryExpr) | 
|  PredicateInValueList | createPredicateInValueList(QueryValueExpression aLeftExpr,
                           boolean isNotIn,
                           java.util.List aValuesList) | 
|  PredicateInValueRowSelect | createPredicateInValueRowSelect(java.util.List aValuesList,
                                boolean isNotIn,
                                QueryExpressionRoot aQueryExpr) | 
|  PredicateInValueSelect | createPredicateInValueSelect(QueryValueExpression aLeftExpr,
                             boolean isNotIn,
                             QueryExpressionRoot aQueryExpr) | 
|  PredicateLike | createPredicateLike(QueryValueExpression aMatchingExpr,
                    boolean isNotLike,
                    QueryValueExpression aPatternExpr,
                    QueryValueExpression aEscapeExpr) | 
|  PredicateIsNull | createPredicateNull(QueryValueExpression aValueExpr,
                    boolean isNotNull) | 
|  PredicateQuantifiedRowSelect | createPredicateQuantifiedRowSelect(java.util.List aValueExprList,
                                   int aQuantType,
                                   QueryExpressionRoot aQueryExpr) | 
|  PredicateQuantifiedValueSelect | createPredicateQuantifiedValueSelect(QueryValueExpression aValueExpr,
                                     int aRelOper,
                                     int aQuantType,
                                     QueryExpressionRoot aQueryExpr) | 
|  ProcedureReference | createProcedureReference(java.lang.String aSchemaName,
                         java.lang.String aProcName) | 
|  QueryCombined | createQueryCombined(QueryExpressionBody aLeftQuery,
                    int combinedOperator,
                    QueryExpressionBody aRightQuery) | 
|  QueryCombined | createQueryCombined(QueryExpressionBody aLeftQuery,
                    int combinedOperator,
                    QueryExpressionBody aRightQuery,
                    java.util.List aSortSpecList,
                    int aRowFetchLimit) | 
|  QueryExpressionRoot | createQueryExpressionRoot(QueryExpressionBody aQuery,
                          java.util.List aWithTableSpecList) | 
|  QueryNested | createQueryNested(QueryExpressionBody queryExprBody) | 
|  QueryNested | createQueryNested(QueryExpressionBody queryExprBody,
                  java.util.List aSortSpecList,
                  int aRowFetchLimit) | 
|  QuerySelect | createQuerySelect(java.lang.String optAllOrDistinct,
                  java.util.List aResultColList,
                  java.util.List aTableRefList,
                  QuerySearchCondition aWhereClause,
                  java.util.List aGroupByList,
                  QuerySearchCondition aHavingClause) | 
|  QuerySelect | createQuerySelect(java.lang.String optAllOrDistinct,
                  java.util.List aResultColList,
                  java.util.List aTableRefList,
                  QuerySearchCondition aWhereClaus,
                  java.util.List aGroupByList,
                  QuerySearchCondition aHavingClaus,
                  java.util.List aSortSpecList,
                  int aRowFetchLimit) | 
|  QueryValues | createQueryValues(java.util.List aValuesRowList) | 
|  QueryValues | createQueryValues(java.util.List aValuesRowList,
                  java.util.List aSortSpecList,
                  int aRowFetchLimit) | 
|  TableExpression | createReferenceTable(java.lang.String aSchemaName,
                     java.lang.String aTableName,
                     java.lang.String aCorrName)Deprecated. use createReferenceTable(String, String, TableCorrelation) | 
|  TableExpression | createReferenceTable(java.lang.String aSchemaName,
                     java.lang.String aTableName,
                     TableCorrelation aTableCorr) | 
|  ResultColumn | createResultColumn(QueryValueExpression aResultColExpr,
                   java.lang.String aAsName) | 
|  ResultTableAllColumns | createResultTableAllColumns(java.lang.String aTableName) | 
|  ResultTableAllColumns | createResultTableAllColumns(java.lang.String aTableName,
                            java.lang.String aSchemaName) | 
|  ValueExpressionScalarSelect | createScalarSelectExpression(QueryExpressionRoot aQueryExpr) | 
|  Schema | createSchema(java.lang.String aSchemaName) | 
|  java.util.List | createSelectClause(java.util.List aResultSpecList,
                   QueryResultSpecification aResultCol) | 
|  QuerySelectStatement | createSelectStatement(QueryExpressionRoot aQryExpr,
                      java.util.List aOrderByList) | 
|  QuerySelectStatement | createSelectStatement(QueryExpressionRoot aQryExpr,
                      java.util.List aOrderByList,
                      UpdatabilityExpression aUpdatabilityExpr) | 
|  QuerySelectStatement | createSelectStatement(QuerySelect aQrySel,
                      java.util.List aOrderByList) | 
|  ValueExpressionSimple | createSimpleExpression(java.lang.String aExpr) | 
|  TableInDatabase | createSimpleTable(java.lang.String aSchemaName,
                  java.lang.String aTableName) | 
|  ValueExpressionFunction | createSpecialRegisterExpression(java.lang.String aSpecialReg)Creates a ValueExpressionFunctionwith nameaSpecialRegand field | 
|  ValueExpressionFunction | createSpecialRegisterExpression(java.lang.String aSpecialReg,
                                java.lang.String value)Deprecated. use createSpecialRegisterExpression(String, UserDefinedType) instead | 
|  ValueExpressionFunction | createSpecialRegisterExpression(java.lang.String aRegName,
                                UserDefinedType aDataType)Creates a function expression object for the special register with the name and user-defined data type. | 
|  SuperGroup | createSuperGroups(java.util.List aSuperGroupsElementList,
                  int aSuperGroupType) | 
|  SuperGroupElementExpression | createSuperGroupsElementExpression(GroupingExpression aGroupingExpr) | 
|  java.util.List | createSuperGroupsElementExprList(java.util.List aSuperGroupsElementExprList,
                                 SuperGroupElementExpression aSuperGroupsElementExpr) | 
|  java.util.List | createSuperGroupsElementList(java.util.List aSuperGroupsElementList,
                             SuperGroupElement aSuperGroupsElement) | 
|  SuperGroupElementSublist | createSuperGroupsElementSublist(java.util.List aSuperGroupsElementExprList) | 
|  TableCorrelation | createTableCorrelation(java.lang.String aCorrName) | 
|  TableCorrelation | createTableCorrelation(java.lang.String aCorrName,
                       java.util.List aColNameList) | 
|  TableExpression | createTableExpressionQuery(QueryExpressionBody aSubquery,
                           java.lang.String aCorrName)Deprecated. use createTableExpressionQuery(QueryExpressionBody, TableCorrelation) | 
|  TableExpression | createTableExpressionQuery(QueryExpressionBody aSubquery,
                           TableCorrelation aTableCorr) | 
|  TableFunction | createTableFunction(java.lang.String aFuncName,
                    java.util.List aFuncParmList,
                    java.lang.String aSchemaName,
                    TableCorrelation aTableCorr) | 
|  UpdatabilityExpression | createUpdatabilityExpression(int aUpdatabilityType,
                             java.util.List aUpdateOfColList) | 
|  java.util.List | createUpdateAssignmentClause(java.util.List aExprList,
                             UpdateAssignmentExpression aExpr) | 
|  UpdateAssignmentExpression | createUpdateAssignmentExpression(java.util.List aTargetColList,
                                 java.util.List aExprList) | 
|  UpdateAssignmentExpression | createUpdateAssignmentExpression(java.util.List aTargetColList,
                                 QueryExpressionBody aUpdateQuery) | 
|  UpdateAssignmentExpression | createUpdateAssignmentExpression(ValueExpressionColumn aTargetCol,
                                 QueryValueExpression aExpr) | 
|  QueryUpdateStatement | createUpdateStatement(TableInDatabase aTargetTable,
                      TableCorrelation aAsTable,
                      java.util.List aAssignmentList,
                      QuerySearchCondition aWhereCond) | 
|  DataType | createUserDefinedTypeFromDomainName(java.lang.String domainName)Deprecated. | 
|  ValueExpressionRow | createValueExpressionRow(java.util.List aExprList) | 
|  ValuesRow | createValuesRow(java.util.List aValueExprList) | 
|  ValuesRow | createValuesRow(QueryValueExpression aValueExpr) | 
|  java.util.List | createValuesRowList(java.util.List aValuesRowList,
                    ValuesRow aValuesRow) | 
|  ValueExpressionVariable | createVariableExpression(java.lang.String aVarName) | 
|  WithTableSpecification | createWithTableSpecification(java.lang.String aTableIdentifier,
                             java.util.List aColumnNameList,
                             QueryExpressionBody aWithSource) | 
|  java.util.List | createWithTableSpecificationList(java.util.List aTableWithSpecList,
                                 WithTableSpecification aTableWithSpec) | 
|  SQLQuerySourceFormat | getSQLSourceFormat() | 
| static boolean | isColumnFunction(java.lang.String aFuncName)Returns whether or not the given function name is a column (summary) function. | 
| static boolean | isDistinctColumnFunction(java.lang.String aFuncName)Returns whether or not the given function name is a column (summary) function that allows the DISTINCT keyword in the parameter list. | 
|  java.util.List | listConcat(java.util.List p_list,
           java.lang.Object p_rhs)Utility used to append elements to an List at the end. | 
|  java.util.List | listConcat(java.lang.Object p_lhs,
           java.util.List p_list)Utility used to append elements to an List in the beginning. | 
|  QuerySearchCondition | negateCondition(QuerySearchCondition aSearchCond,
                boolean negate) | 
|  Predicate | negatePredicate(Predicate aPredicate,
                boolean negate) | 
|  void | setSQLSourceFormat(SQLQuerySourceFormat sourceFormat) | 
|  QueryValueExpression | setUnaryOperator(QueryValueExpression expr,
                 int op) | 
| Methods inherited from class java.lang.Object | 
|---|
| equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait | 
| Field Detail | 
|---|
public static final int COMPARISON_OPERATOR_EQ
PredicateComparisonOperator.EQUAL "="
PredicateComparisonOperator.EQUAL, 
Constant Field Valuespublic static final int COMPARISON_OPERATOR_NE
PredicateComparisonOperator.NOT_EQUAL "<>"
PredicateComparisonOperator.NOT_EQUAL, 
Constant Field Valuespublic static final int COMPARISON_OPERATOR_LT
PredicateComparisonOperator.LESS_THAN "<"
PredicateComparisonOperator.LESS_THAN, 
Constant Field Valuespublic static final int COMPARISON_OPERATOR_GT
PredicateComparisonOperator.GREATER_THAN ">"
PredicateComparisonOperator.GREATER_THAN, 
Constant Field Valuespublic static final int COMPARISON_OPERATOR_LE
PredicateComparisonOperator.LESS_THAN_OR_EQUAL "<="
PredicateComparisonOperator.LESS_THAN_OR_EQUAL, 
Constant Field Valuespublic static final int COMPARISON_OPERATOR_GE
PredicateComparisonOperator.GREATER_THAN_OR_EQUAL ">="
PredicateComparisonOperator.GREATER_THAN_OR_EQUAL, 
Constant Field Valuespublic static final int COMBINED_OPERATOR_AND
SearchConditionCombinedOperator.AND
SearchConditionCombinedOperator.AND, 
Constant Field Valuespublic static final int COMBINED_OPERATOR_OR
SearchConditionCombinedOperator.OR
SearchConditionCombinedOperator.OR, 
Constant Field Valuespublic static final int UNARY_OPERATOR_PLUS
ValueExpressionUnaryOperator.PLUS "+"
ValueExpressionUnaryOperator.PLUS, 
Constant Field Valuespublic static final int UNARY_OPERATOR_MINUS
ValueExpressionUnaryOperator.MINUS "-"
ValueExpressionUnaryOperator.MINUS, 
Constant Field Valuespublic static final int COMBINED_OPERATOR_ADD
ValueExpressionCombinedOperator.ADD "+"
ValueExpressionCombinedOperator.ADD, 
Constant Field Valuespublic static final int COMBINED_OPERATOR_SUBTRACT
ValueExpressionCombinedOperator.SUBTRACT "-"
ValueExpressionCombinedOperator.SUBTRACT, 
Constant Field Valuespublic static final int COMBINED_OPERATOR_MULTIPLY
ValueExpressionCombinedOperator.MULTIPLY "*"
ValueExpressionCombinedOperator.MULTIPLY, 
Constant Field Valuespublic static final int COMBINED_OPERATOR_DIVIDE
ValueExpressionCombinedOperator.DIVIDE "/"
ValueExpressionCombinedOperator.DIVIDE, 
Constant Field Valuespublic static final int COMBINED_OPERATOR_CONCATENATE
ValueExpressionCombinedOperator.CONCATENATE "||"
ValueExpressionCombinedOperator.CONCATENATE, 
Constant Field Valuespublic static final int DURATION_TYPE_DAYS
ValueExpressionLabeledDurationType.DAYS
ValueExpressionLabeledDurationType.DAYS, 
Constant Field Valuespublic static final int DURATION_TYPE_HOURS
ValueExpressionLabeledDurationType.HOURS
ValueExpressionLabeledDurationType.HOURS, 
Constant Field Valuespublic static final int DURATION_TYPE_MICROSECONDS
ValueExpressionLabeledDurationType.MICROSECONDS
ValueExpressionLabeledDurationType.MICROSECONDS, 
Constant Field Valuespublic static final int DURATION_TYPE_MINUTES
ValueExpressionLabeledDurationType.MINUTES
ValueExpressionLabeledDurationType.MINUTES, 
Constant Field Valuespublic static final int DURATION_TYPE_MONTHS
ValueExpressionLabeledDurationType.MONTHS
ValueExpressionLabeledDurationType.MONTHS, 
Constant Field Valuespublic static final int DURATION_TYPE_SECONDS
ValueExpressionLabeledDurationType.SECONDS
ValueExpressionLabeledDurationType.SECONDS, 
Constant Field Valuespublic static final int DURATION_TYPE_YEARS
ValueExpressionLabeledDurationType.YEARS
ValueExpressionLabeledDurationType.YEARS, 
Constant Field Valuespublic static final int NULL_ORDERING_TYPE_NONE
NullOrderingType.NONE
NullOrderingType.NONE, 
Constant Field Valuespublic static final int NULL_ORDERING_TYPE_NULLS_FIRST
NullOrderingType.NULLS_FIRST
NullOrderingType.NULLS_FIRST, 
Constant Field Valuespublic static final int NULL_ORDERING_TYPE_NULLS_LAST
NullOrderingType.NULLS_LAST
NullOrderingType.NULLS_LAST, 
Constant Field Valuespublic static final int ORDERING_SPEC_TYPE_NONE
OrderingSpecType.NONE
OrderingSpecType.NONE, 
Constant Field Valuespublic static final int ORDERING_SPEC_TYPE_ASC
OrderingSpecType.ASC
OrderingSpecType.ASC, 
Constant Field Valuespublic static final int ORDERING_SPEC_TYPE_DESC
OrderingSpecType.DESC
OrderingSpecType.DESC, 
Constant Field Valuespublic static final int SUPERGROUP_TYPE_CUBE
SuperGroupType.CUBE
SuperGroupType.CUBE, 
Constant Field Valuespublic static final int SUPERGROUP_TYPE_ROLLUP
SuperGroupType.ROLLUP
SuperGroupType.ROLLUP, 
Constant Field Valuespublic static final int SUPERGROUP_TYPE_GRANDTOTAL
SuperGroupType.GRANDTOTAL
SuperGroupType.GRANDTOTAL, 
Constant Field Valuespublic static final int QUANTIFIER_ALL
PredicateQuantifiedType.ALL "ALL"
PredicateQuantifiedType.ALL, 
Constant Field Valuespublic static final int QUANTIFIER_ANY
PredicateQuantifiedType.ANY "ANY"
PredicateQuantifiedType.ANY, 
Constant Field Valuespublic static final int QUANTIFIER_SOME
PredicateQuantifiedType.SOME "SOME"
PredicateQuantifiedType.SOME, 
Constant Field Valuespublic static final int JOIN_DEFAULT_INNER
TableJoinedOperator.DEFAULT_INNER "JOIN"
TableJoinedOperator.DEFAULT_INNER, 
Constant Field Valuespublic static final int JOIN_EXPLICIT_INNER
TableJoinedOperator.EXPLICIT_INNER "INNER JOIN"
TableJoinedOperator.EXPLICIT_INNER, 
Constant Field Valuespublic static final int JOIN_LEFT_OUTER
TableJoinedOperator.LEFT_OUTER "LEFT JOIN"
TableJoinedOperator.LEFT_OUTER, 
Constant Field Valuespublic static final int JOIN_RIGHT_OUTER
TableJoinedOperator.RIGHT_OUTER "RIGHT JOIN"
TableJoinedOperator.RIGHT_OUTER, 
Constant Field Valuespublic static final int JOIN_FULL_OUTER
TableJoinedOperator.FULL_OUTER "FULL JOIN"
TableJoinedOperator.FULL_OUTER, 
Constant Field Valuespublic static final int QUERY_COMBINED_UNION
QueryCombinedOperator.UNION "UNION"
QueryCombinedOperator.UNION, 
Constant Field Valuespublic static final int QUERY_COMBINED_UNION_ALL
QueryCombinedOperator.UNION_ALL "UNION ALL"
QueryCombinedOperator.UNION_ALL, 
Constant Field Valuespublic static final int QUERY_COMBINED_INTERSECT
QueryCombinedOperator.INTERSECT "INTERSECT"
QueryCombinedOperator.INTERSECT, 
Constant Field Valuespublic static final int QUERY_COMBINED_INTERSECT_ALL
QueryCombinedOperator.INTERSECT_ALL "INTERSECT ALL"
QueryCombinedOperator.INTERSECT_ALL, 
Constant Field Valuespublic static final int QUERY_COMBINED_EXCEPT
QueryCombinedOperator.EXCEPT "EXCEPT"
QueryCombinedOperator.EXCEPT, 
Constant Field Valuespublic static final int QUERY_COMBINED_EXCEPT_ALL
QueryCombinedOperator.EXCEPT_ALL "EXCEPT ALL"
QueryCombinedOperator.EXCEPT_ALL, 
Constant Field Valuespublic static final int UPDATABILITY_TYPE_FOR_READ_ONLY
UpdatabilityType.READ_ONLY "FOR READ ONLY"
UpdatabilityType.READ_ONLY, 
Constant Field Valuespublic static final int UPDATABILITY_TYPE_FOR_UPDATE
UpdatabilityType.UPDATE "FOR UPDATE"
UpdatabilityType.UPDATE, 
Constant Field Valuespublic static final java.lang.String SPECIAL_REGISTER_CURRENT_DATE
public static final java.lang.String SPECIAL_REGISTER_CURRENT_TIME
public static final java.lang.String SPECIAL_REGISTER_CURRENT_TIMESTAMP
public static final java.lang.String SPECIAL_REGISTER_LOCALTIME
public static final java.lang.String SPECIAL_REGISTER_LOCALTIMESTAMP
public static final java.lang.String SPECIAL_REGISTER_CURRENT_DEFAULT_TRANSFORM_GROUP
public static final java.lang.String SPECIAL_REGISTER_CURRENT_TRANSFORM_GROUP_FOR_TYPE
public static final java.lang.String SPECIAL_REGISTER_CURRENT_PATH
public static final java.lang.String SPECIAL_REGISTER_CURRENT_ROLE
public static final java.lang.String SPECIAL_REGISTER_CURRENT_USER
public static final java.lang.String SPECIAL_REGISTER_SESSION_USER
public static final java.lang.String SPECIAL_REGISTER_SYSTEM_USER
public static final java.lang.String SPECIAL_REGISTER_USER
public static final java.lang.String SPECIAL_REGISTER_VALUE
public static final java.lang.String ORDER_ASC
OrderBySpecification.isDescending(), 
Constant Field Valuespublic static final java.lang.String ORDER_DESC
OrderBySpecification.isDescending(), 
Constant Field Valuespublic static final java.lang.String ALL
QuerySelect.isDistinct(), 
Constant Field Valuespublic static final java.lang.String DISTINCT
QuerySelect.isDistinct(), 
Constant Field Values| Constructor Detail | 
|---|
public SQLQueryParserFactory()
SQLQueryParserFactory is equal to the resulting
 SQLQueryParserFactory of
 SQLQueryParserFactory(SQLQuerySourceFormat) with
 SQLQuerySourceFormat =
             SQLQuerySourceFormat.SQL_SOURCE_FORMAT_DEFAULT
SQLQuerySourceFormat.SQL_SOURCE_FORMAT_DEFAULTpublic SQLQueryParserFactory(SQLQuerySourceFormat aSourceFormat)
aSourceFormat - | Method Detail | 
|---|
public SQLQuerySourceFormat getSQLSourceFormat()
getSQLSourceFormat in interface SQLParserFactorypublic void setSQLSourceFormat(SQLQuerySourceFormat sourceFormat)
setSQLSourceFormat in interface SQLParserFactory
public java.util.List listConcat(java.util.List p_list,
                                 java.lang.Object p_rhs)
public java.util.List listConcat(java.lang.Object p_lhs,
                                 java.util.List p_list)
public TableExpression addTableCorrelationToTableExpression(TableExpression tableExpr,
                                                            TableCorrelation tableCorrelation)
tableCorrelation to the given tableExpr.
tableExpr - tableCorrelation - 
tableExprpublic ValueExpressionCaseElse createCaseElse(QueryValueExpression expr)
public ValueExpressionCaseSearchContent createCaseSearchContent(QuerySearchCondition aWhenCond,
                                                                QueryValueExpression aExpr)
public ValueExpressionCaseSearch createCaseSearchExpression(java.util.List aCaseSearchWhenList,
                                                            ValueExpressionCaseElse aCaseElse)
public java.util.List createCaseSearchList(java.util.List aCaseSearchList,
                                           ValueExpressionCaseSearchContent aCaseSearchContent)
public ValueExpressionCaseSimpleContent createCaseSimpleContent(QueryValueExpression aWhenExpr,
                                                                QueryValueExpression aResultExpr)
public ValueExpressionCaseSimple createCaseSimpleExpression(QueryValueExpression aCaseValue,
                                                            java.util.List aCaseSimpleWhenList,
                                                            ValueExpressionCaseElse aCaseElse)
public java.util.List createCaseSimpleList(java.util.List aCaseSimpleList,
                                           ValueExpressionCaseSimpleContent aCaseSimpleContent)
public ValueExpressionCast createCastExpression(QueryValueExpression aExpr,
                                                java.lang.String aCastType)
public ValueExpressionCast createCastExpression(QueryValueExpression aExpr,
                                                DataType aCastType)
public ValueExpressionColumn createColumnExpression(java.lang.String aColumnName,
                                                    java.lang.String aTableName,
                                                    java.lang.String aSchemaName)
public ValueExpressionColumn createColumnExpression(java.lang.String aColumnName,
                                                    java.lang.String aQualifier)
public ValueExpressionColumn createColumnExpression(java.lang.String aColumnName)
public java.util.List createColumnList(java.util.List aColumnNameList,
                                       ValueExpressionColumn aColumnExpr)
public java.util.List createColumnNameList(java.util.List aColumnNameList,
                                           ColumnName aColumnName)
public ColumnName createColumnName(java.lang.String aColumnName)
public SearchConditionCombined createCombinedCondition(QuerySearchCondition aLeftCond,
                                                       QuerySearchCondition aRightCond,
                                                       int aCondOper)
public ValueExpressionCombined createCombinedExpression(QueryValueExpression aLeftExpr,
                                                        int aExprOper,
                                                        QueryValueExpression aRightExpr)
public DataType createDataType(java.lang.String aTypeName)
public ArrayDataType createDataTypeArray(DataType dataType)
SQLQueryParserFactoryDataTypesArrayDataType with the
 element data type elementDataType.
createDataTypeArray in interface SQLQueryParserFactoryDataTypesArrayDataTypeSQLQueryParserFactoryDataTypes.createDataTypeArray(DataType)
public ArrayDataType createDataTypeArray(DataType dataType,
                                         int maxCardinality)
SQLQueryParserFactoryDataTypesArrayDataType with the
 element data type elementDataType and with maximum
 cardinality specified by maxCardinality.
createDataTypeArray in interface SQLQueryParserFactoryDataTypesArrayDataTypeSQLQueryParserFactoryDataTypes.createDataTypeArray(DataType, int)
public ArrayDataType createDataTypeArray(DataType dataType,
                                         int maxCardinality,
                                         java.lang.String typeName)
SQLQueryParserFactoryDataTypes.createDataTypeArray(DataType, int)
public BinaryStringDataType createDataTypeBinaryString(int primitiveType,
                                                       int length,
                                                       java.lang.String optionalUnitsIndicator)
SQLQueryParserFactoryDataTypesBinaryStringDataType with
 its primitiveType and length.
 
 Note:
 The optional parameter optionalUnitsIndicator may only be
 specified with the given primitiveType
 SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BINARY_LARGE_OBJECT, where
 SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_K measures the given length
 in Kilobyte (for the given length <= 2097152),
 SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_M measures the given length
 in Megabyte (for the given length <= 2048),
 SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_G measures the given length
 in Gigabyte (for the given length <= 2).
 
 
 Note:
 The given primitiveType must be one of the constants for the
 primitve types in this interface/class correlated to the
 BinaryStringDataType.
createDataTypeBinaryString in interface SQLQueryParserFactoryDataTypesprimitiveType - one of the correlated the primitive types for
   the BinaryStringDataTypelength - the length of this BinaryStringDataTypeoptionalUnitsIndicator - optional parameter indicating the given length
                is measured in Kilobyte (use SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_K),
                Megabyte (use SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_M) or 
                Gigabyte (use SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_G)
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BINARY, 
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BINARY_VARYING, 
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BINARY_LARGE_OBJECT
public BinaryStringDataType createDataTypeBinaryString(int primitiveType,
                                                       int length,
                                                       java.lang.String optionalUnitsIndicator,
                                                       java.lang.String typeName)
public BooleanDataType createDataTypeBoolean()
SQLQueryParserFactoryDataTypesBooleanDataType with
 primitiveType PrimitiveType.BOOLEAN_LITERAL.
createDataTypeBoolean in interface SQLQueryParserFactoryDataTypespublic BooleanDataType createDataTypeBoolean(java.lang.String typeName)
public CharacterStringDataType createDataTypeCharacterString(int primitiveType,
                                                             int length,
                                                             java.lang.String optionalUnitsIndicator)
SQLQueryParserFactoryDataTypesCharacterStringDataType with
 its primitiveType and length.
 
 Note:  The optional parameter optionalUnitsIndicator
 may only be specified with the given primitiveType
 SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_CHARACTER_LARGE_OBJECTor
 SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_NATIONAL_CHARACTER_LARGE_OBJECT, where
 SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_Kmeasures the given length in
 Kilobyte (for the given length<= 2097152),
 SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_Mmeasures the given length in
 Megabyte (for the given length<= 2048),
 SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_Gmeasures the given length in
 Gigabyte (for the given length<= 2).
 
 
 Note:  The given primitiveType must be one of the
 constants for the primitve types in this interface/class correlated to
 the CharacterStringDataType.
createDataTypeCharacterString in interface SQLQueryParserFactoryDataTypesprimitiveType - one of the correlated the primitive types for the
        CharacterStringDataTypelength - the length of this CharacterStringDataTypeoptionalUnitsIndicator - optional parameter indicating the given
        length is measured in Kilobyte (use
        SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_K), Megabyte (use
        SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_M) or Gigabyte (use
        SQLQueryParserFactoryDataTypes.UNIT_INDICATOR_G)
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_CHARACTER, 
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_CHARACTER_VARYING, 
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_CHARACTER_LARGE_OBJECT, 
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_NATIONAL_CHARACTER, 
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_NATIONAL_CHARACTER_VARYING, 
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_NATIONAL_CHARACTER_LARGE_OBJECT
public CharacterStringDataType createDataTypeCharacterString(int primitiveType,
                                                             int length,
                                                             java.lang.String optionalUnitsIndicator,
                                                             java.lang.String typeName)
public DataLinkDataType createDataTypeDataLink(int length)
SQLQueryParserFactoryDataTypes
createDataTypeDataLink in interface SQLQueryParserFactoryDataTypes
public DataLinkDataType createDataTypeDataLink(int length,
                                               java.lang.String typeName)
public DateDataType createDataTypeDate()
SQLQueryParserFactoryDataTypesDateDataType with
 primitiveType PrimitiveType.DATE_LITERAL.
createDataTypeDate in interface SQLQueryParserFactoryDataTypesSQLDataTypesFactory.createDateDataType()public DateDataType createDataTypeDate(java.lang.String typeName)
SQLDataTypesFactory.createDateDataType()public DistinctUserDefinedType createDataTypeDistinctUserDefinedType(java.lang.String aTypeName)
public IntervalDataType createDataTypeInterval(IntervalQualifierType leadingQualifier,
                                               IntervalQualifierType trailingQualifier,
                                               int leadingFieldPrecision,
                                               int trailingFieldPrecision,
                                               int fractionalSecondsPrecision)
SQLQueryParserFactoryDataTypesIntervalDataType with
 primitiveType PrimitiveType.INTERVAL.
createDataTypeInterval in interface SQLQueryParserFactoryDataTypes
public IntervalDataType createDataTypeInterval(IntervalQualifierType leadingQualifier,
                                               IntervalQualifierType trailingQualifier,
                                               int leadingFieldPrecision,
                                               int trailingFieldPrecision,
                                               int fractionalSecondsPrecision,
                                               java.lang.String typeName)
public MultisetDataType createDataTypeMultiset(DataType dataType)
SQLQueryParserFactoryDataTypesMultisetDataType with the
 element data type elementDataType.
createDataTypeMultiset in interface SQLQueryParserFactoryDataTypesMultisetDataTypeSQLQueryParserFactoryDataTypes.createDataTypeMultiset(DataType)
public MultisetDataType createDataTypeMultiset(DataType dataType,
                                               java.lang.String typeName)
SQLQueryParserFactoryDataTypes.createDataTypeMultiset(DataType)
public ApproximateNumericDataType createDataTypeNumericApproximate(int primitiveType,
                                                                   int precision)
SQLQueryParserFactoryDataTypesApproximateNumericDataType with
 its primitiveType and precision.
 Note:
 The given primitiveType must be one of the constants for the
 primitve types in this interface/class correlated to the
 ApproximateNumericDataType.
createDataTypeNumericApproximate in interface SQLQueryParserFactoryDataTypesprimitiveType - one of the correlated the primitive types for
        the FixedPrecisionDataType SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_FLOAT,
        SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_REAL, SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_DOUBLE_PRECISIONprecision - the total number of digits
                org.eclipse.wst.rdb.internal.models.sql.datatypes.NumericalDataType#setPrecision(int) ranges between 1 and 31
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_FLOAT, 
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_REAL, 
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_DOUBLE_PRECISION
public ApproximateNumericDataType createDataTypeNumericApproximate(int primitiveType,
                                                                   int precision,
                                                                   java.lang.String typeName)
public FixedPrecisionDataType createDataTypeNumericFixedPrecision(int primitiveType,
                                                                  int precision,
                                                                  int scale)
SQLQueryParserFactoryDataTypesFixedPrecisionDataType with
 its primitiveType, precision and scale.
 Note:
 The given primitiveType must be one of the constants for the
 primitve types in this interface/class correlated to the
 FixedPrecisionDataType.
createDataTypeNumericFixedPrecision in interface SQLQueryParserFactoryDataTypesprimitiveType - one of the correlated the primitive types for
        the FixedPrecisionDataType SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_NUMERIC,
        SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_DECIMALprecision - the total number of digits
                org.eclipse.wst.rdb.internal.models.sql.datatypes.NumericalDataType#setPrecision(int) ranges between 1 and 31scale - the number of digits to the right of the decimal point,
                ranges between 0 and precision
                org.eclipse.wst.rdb.internal.models.sql.datatypes.ExactNumericDataType#setScale(int)
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_NUMERIC, 
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_DECIMAL
public FixedPrecisionDataType createDataTypeNumericFixedPrecision(int primitiveType,
                                                                  int precision,
                                                                  int scale,
                                                                  java.lang.String typeName)
public IntegerDataType createDataTypeNumericInteger(int primitiveType,
                                                    int precision)
SQLQueryParserFactoryDataTypesIntegerDataType with
 its primitiveType. The precision is implicitly
 given for the primitiveTypes
 SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_SMALLINT (5) and
 SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_INTEGER (10). The precision  has to
 be explicitely specified for the primitiveType
 SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BIGINT or will be set to 10 by default.
 Note:
 The given primitiveType must be one of the constants for the
 primitve types in this interface/class correlated to the
 intDataType.
createDataTypeNumericInteger in interface SQLQueryParserFactoryDataTypesprimitiveType - one of the correlated the primitive types for
        the intDataType SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_SMALLINT precision is 5,
        SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_INTEGER precision is 10,
                SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BIGINT precision has to be given, default is 10precision - the total number of digits for given primitiveType
                SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BIGINT, default is 10
                org.eclipse.wst.rdb.internal.models.sql.datatypes.NumericalDataType#setPrecision(int) ranges between 1 and 31
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_SMALLINT, 
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_INTEGER, 
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_BIGINT
public IntegerDataType createDataTypeNumericInteger(int primitiveType,
                                                    int precision,
                                                    java.lang.String typeName)
public PredefinedDataType createDataTypePredefinedDataType(java.lang.String typeName)
public TimeDataType createDataTypeTime(int primitiveType,
                                       int precision)
SQLQueryParserFactoryDataTypesTimeDataType with
 its primitiveType and length.
 
 Note:
 The given primitiveType must be one of the constants for the
 primitve types in this interface/class correlated to the
 TimeDataType.
createDataTypeTime in interface SQLQueryParserFactoryDataTypesprimitiveType - one of the correlated the primitive types for
   the TimeDataType SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_TIME,
  SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_TIMESTAMPprecision - optional precision in fractional seconds of
                this TimeDataType 
                (TimeDataType.setFractionalSecondsPrecision(int)), if not
                specified default value for given primitiveType 
                SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_TIME is 0 and for 
                SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_TIMESTAMP is 6
SQLQueryParserFactoryDataTypes.PRIMITIVE_TYPE_TIME, 
 Note:
 If the optional parameter fractionalSecondsPrecision is not
 specified, the default value for the given primitiveType
 {@link #PRIMITIVE_TYPE_TIME} is 0 and for primitiveType
 {@link #PRIMITIVE_TYPE_TIMESTAMP} is 6.
public TimeDataType createDataTypeTime(int primitiveType,
                                       int precision,
                                       java.lang.String typeName)
public UserDefinedType createDataTypeUserDefinedType(java.lang.String aSchemaName,
                                                     java.lang.String aTypeName)
public ValueExpressionDefaultValue createDefaultExpression()
public QueryDeleteStatement createDeleteStatement_deprecated(TableInDatabase aTargetTable,
                                                             java.lang.String aAsTable,
                                                             QuerySearchCondition aWhereClause)
#createDeleteStatement(SQLTableExpression, SQLTableCorrelation, SQLSearchCondition)
public QueryDeleteStatement createDeleteStatement(TableInDatabase aTargetTable,
                                                  TableCorrelation aAsTable,
                                                  QuerySearchCondition aWhereClause)
public DistinctUserDefinedType createDistinctUserDefinedType(java.lang.String aTypeName)
public java.util.List createExpressionList(java.util.List aExprList,
                                           QueryValueExpression aValExpr)
public java.util.List createFromClause(java.util.List aTableRefList,
                                       TableReference aTableRef)
public ValueExpressionFunction createFunctionExpression(java.lang.String aFuncName,
                                                        java.lang.String distinct,
                                                        java.util.List aFuncParmList,
                                                        java.lang.String aSchemaName)
public GroupingExpression createGroupingExpression(QueryValueExpression aExpr)
public GroupingSets createGroupingSets(java.util.List aGroupingSetsElementList)
public java.util.List createGroupingSetsElementList(java.util.List aGroupingSetsElementList,
                                                    GroupingSetsElement aGroupingSetsElement)
public GroupingSetsElementExpression createGroupingSetsElementExpression(Grouping aGrouping)
public java.util.List createGroupingSetsElementExprList(java.util.List aGroupingSetsElementExprList,
                                                        GroupingSetsElementExpression aGroupingSetsElementExpr)
public GroupingSetsElementSublist createGroupingSetsElementSublist(java.util.List aGroupingSetsElementExprList)
public java.util.List createGroupingSpecificationList(java.util.List aGroupingSpecList,
                                                      GroupingSpecification aGroupingSpec)
public java.util.List createInsertRow(java.util.List aInsertExprList,
                                      ValuesRow aInsertExpr)
public QueryInsertStatement createInsertStatement(TableInDatabase aTargetTable,
                                                  java.util.List aTargetColumnList,
                                                  java.util.List aSrcValuesRowList)
aTargetTable - aTargetColumnList - aSrcValuesRowList - 
public QueryInsertStatement createInsertStatement(TableInDatabase aTargetTable,
                                                  java.util.List aColumnList,
                                                  QueryExpressionRoot aSrcQuery)
aTargetTable - aColumnList - aSrcQuery - 
public ValuesRow createInsertValuesRow(java.util.List aExprList)
public ValuesRow createInsertValuesRow(QueryValueExpression aValueExpr)
public TableJoined createJoinedTable(TableReference aLeftTable,
                                     int aJoinType,
                                     TableReference aRightTable,
                                     QuerySearchCondition aJoinCond)
public ValueExpressionLabeledDuration createLabeledDurationExpression(QueryValueExpression aExpr,
                                                                      int aDurationType)
public QueryMergeStatement createMergeStatement(MergeTargetTable aTargetTable,
                                                MergeSourceTable aSourceTable,
                                                MergeOnCondition aOnCondition,
                                                java.util.List aOperSpecList)
public MergeTargetTable createMergeTargetTable(TableExpression aTableExpr,
                                               java.lang.String aTableAliasName)
public MergeSourceTable createMergeSourceTable(TableReference aTableRef)
public MergeOnCondition createMergeOnCondition(QuerySearchCondition aSearchCond)
public MergeInsertSpecification createMergeInsertSpecification(java.util.List aTargetColList,
                                                               ValuesRow aValuesRow)
public MergeUpdateSpecification createMergeUpdateSpecification(java.util.List aAssignmentExprList)
public java.util.List createMergeOperatationSpecificationList(java.util.List aMergeSpecList,
                                                              MergeOperationSpecification aMergeSpec)
public ValueExpressionNullValue createNullExpression()
public SearchConditionNested createNestedCondition(QuerySearchCondition aCondition)
public SearchConditionNested createNestedConditionNegated(QuerySearchCondition aCondition)
public ValueExpressionNested createNestedExpression(QueryValueExpression aNestedExpr)
public TableNested createNestedTable(TableReference aNestedTable)
public java.util.List createOrderByClause(java.util.List aOrderByList,
                                          OrderBySpecification aOrderByExpr)
public OrderBySpecification createOrderByExpression(QueryValueExpression aOrderByExpr,
                                                    int orderingSpec,
                                                    int nullOrdering)
OrderBySpecification.
aOrderByExpr - QueryValueExpression to order byorderingSpec - one of the constants ORDERING_SPEC_TYPE_ASC,
        ORDERING_SPEC_TYPE_DESC or ORDERING_SPEC_TYPE_NONEnullOrdering - one of the constants
        NULL_ORDERING_TYPE_NULLS_FIRST,
        NULL_ORDERING_TYPE_NULLS_LAST or
        NULL_ORDERING_TYPE_NONE
OrderBySpecification
public OrderBySpecification createOrderByExpression(QueryValueExpression aOrderByExpr,
                                                    java.lang.String optAscDesc)
createOrderByExpression(QueryValueExpression, int, int)
OrderBySpecification
aOrderByExpr - QueryValueExpression to order byoptAscDesc - one of the following constants ORDER_ASC or
        ORDER_DESCpublic PredefinedDataType createPredefinedDataType(java.lang.String aTypeName)
public PredicateBasic createPredicateBasic(QueryValueExpression aLeftExpr,
                                           int aRelOper,
                                           QueryValueExpression aRightExpr)
public PredicateBetween createPredicateBetween(QueryValueExpression aLeftExpr,
                                               boolean isNotBetween,
                                               QueryValueExpression aRightExpr1,
                                               QueryValueExpression aRightExpr2)
public PredicateExists createPredicateExists(QueryExpressionBody aQueryExpr)
public PredicateInValueList createPredicateInValueList(QueryValueExpression aLeftExpr,
                                                       boolean isNotIn,
                                                       java.util.List aValuesList)
public PredicateInValueRowSelect createPredicateInValueRowSelect(java.util.List aValuesList,
                                                                 boolean isNotIn,
                                                                 QueryExpressionRoot aQueryExpr)
public PredicateInValueSelect createPredicateInValueSelect(QueryValueExpression aLeftExpr,
                                                           boolean isNotIn,
                                                           QueryExpressionRoot aQueryExpr)
public PredicateLike createPredicateLike(QueryValueExpression aMatchingExpr,
                                         boolean isNotLike,
                                         QueryValueExpression aPatternExpr,
                                         QueryValueExpression aEscapeExpr)
public PredicateIsNull createPredicateNull(QueryValueExpression aValueExpr,
                                           boolean isNotNull)
public PredicateQuantifiedValueSelect createPredicateQuantifiedValueSelect(QueryValueExpression aValueExpr,
                                                                           int aRelOper,
                                                                           int aQuantType,
                                                                           QueryExpressionRoot aQueryExpr)
public PredicateQuantifiedRowSelect createPredicateQuantifiedRowSelect(java.util.List aValueExprList,
                                                                       int aQuantType,
                                                                       QueryExpressionRoot aQueryExpr)
public ProcedureReference createProcedureReference(java.lang.String aSchemaName,
                                                   java.lang.String aProcName)
public QueryCombined createQueryCombined(QueryExpressionBody aLeftQuery,
                                         int combinedOperator,
                                         QueryExpressionBody aRightQuery)
public QueryCombined createQueryCombined(QueryExpressionBody aLeftQuery,
                                         int combinedOperator,
                                         QueryExpressionBody aRightQuery,
                                         java.util.List aSortSpecList,
                                         int aRowFetchLimit)
public QueryNested createQueryNested(QueryExpressionBody queryExprBody)
public QueryNested createQueryNested(QueryExpressionBody queryExprBody,
                                     java.util.List aSortSpecList,
                                     int aRowFetchLimit)
public QuerySelect createQuerySelect(java.lang.String optAllOrDistinct,
                                     java.util.List aResultColList,
                                     java.util.List aTableRefList,
                                     QuerySearchCondition aWhereClause,
                                     java.util.List aGroupByList,
                                     QuerySearchCondition aHavingClause)
public QuerySelect createQuerySelect(java.lang.String optAllOrDistinct,
                                     java.util.List aResultColList,
                                     java.util.List aTableRefList,
                                     QuerySearchCondition aWhereClaus,
                                     java.util.List aGroupByList,
                                     QuerySearchCondition aHavingClaus,
                                     java.util.List aSortSpecList,
                                     int aRowFetchLimit)
public QueryValues createQueryValues(java.util.List aValuesRowList)
public QueryValues createQueryValues(java.util.List aValuesRowList,
                                     java.util.List aSortSpecList,
                                     int aRowFetchLimit)
public QueryExpressionRoot createQueryExpressionRoot(QueryExpressionBody aQuery,
                                                     java.util.List aWithTableSpecList)
public TableExpression createReferenceTable(java.lang.String aSchemaName,
                                            java.lang.String aTableName,
                                            java.lang.String aCorrName)
createReferenceTable(String, String, TableCorrelation)
createReferenceTable(aSchemaName, aTableName,
  createTableCorrelation(aCorrName))
public TableExpression createReferenceTable(java.lang.String aSchemaName,
                                            java.lang.String aTableName,
                                            TableCorrelation aTableCorr)
public ResultColumn createResultColumn(QueryValueExpression aResultColExpr,
                                       java.lang.String aAsName)
public ResultTableAllColumns createResultTableAllColumns(java.lang.String aTableName)
public ResultTableAllColumns createResultTableAllColumns(java.lang.String aTableName,
                                                         java.lang.String aSchemaName)
public ValueExpressionScalarSelect createScalarSelectExpression(QueryExpressionRoot aQueryExpr)
public Schema createSchema(java.lang.String aSchemaName)
public java.util.List createSelectClause(java.util.List aResultSpecList,
                                         QueryResultSpecification aResultCol)
public QuerySelectStatement createSelectStatement(QuerySelect aQrySel,
                                                  java.util.List aOrderByList)
public QuerySelectStatement createSelectStatement(QueryExpressionRoot aQryExpr,
                                                  java.util.List aOrderByList)
public QuerySelectStatement createSelectStatement(QueryExpressionRoot aQryExpr,
                                                  java.util.List aOrderByList,
                                                  UpdatabilityExpression aUpdatabilityExpr)
public ValueExpressionSimple createSimpleExpression(java.lang.String aExpr)
public TableInDatabase createSimpleTable(java.lang.String aSchemaName,
                                         java.lang.String aTableName)
public ValueExpressionFunction createSpecialRegisterExpression(java.lang.String aSpecialReg)
ValueExpressionFunction with name aSpecialReg
 and field ValueExpressionFunction.isSpecialRegister()==true
aSpecialReg - the register name, e.g. SPECIAL_REGISTER_CURRENT_DATE.
ValueExpressionFunction
public ValueExpressionFunction createSpecialRegisterExpression(java.lang.String aRegName,
                                                               UserDefinedType aDataType)
public ValueExpressionFunction createSpecialRegisterExpression(java.lang.String aSpecialReg,
                                                               java.lang.String value)
ValueExpressionFunction
public SuperGroup createSuperGroups(java.util.List aSuperGroupsElementList,
                                    int aSuperGroupType)
public java.util.List createSuperGroupsElementList(java.util.List aSuperGroupsElementList,
                                                   SuperGroupElement aSuperGroupsElement)
public SuperGroupElementExpression createSuperGroupsElementExpression(GroupingExpression aGroupingExpr)
public java.util.List createSuperGroupsElementExprList(java.util.List aSuperGroupsElementExprList,
                                                       SuperGroupElementExpression aSuperGroupsElementExpr)
public SuperGroupElementSublist createSuperGroupsElementSublist(java.util.List aSuperGroupsElementExprList)
public TableCorrelation createTableCorrelation(java.lang.String aCorrName)
aCorrName - correlation name
public TableCorrelation createTableCorrelation(java.lang.String aCorrName,
                                               java.util.List aColNameList)
public TableExpression createTableExpressionQuery(QueryExpressionBody aSubquery,
                                                  java.lang.String aCorrName)
createTableExpressionQuery(QueryExpressionBody, TableCorrelation)
createTableExpressionQuery(aSubquery,
  createTableCorrelation(aCorrName))
aSubquery - aCorrName - 
public TableExpression createTableExpressionQuery(QueryExpressionBody aSubquery,
                                                  TableCorrelation aTableCorr)
public TableFunction createTableFunction(java.lang.String aFuncName,
                                         java.util.List aFuncParmList,
                                         java.lang.String aSchemaName,
                                         TableCorrelation aTableCorr)
public UpdatabilityExpression createUpdatabilityExpression(int aUpdatabilityType,
                                                           java.util.List aUpdateOfColList)
public java.util.List createUpdateAssignmentClause(java.util.List aExprList,
                                                   UpdateAssignmentExpression aExpr)
public UpdateAssignmentExpression createUpdateAssignmentExpression(ValueExpressionColumn aTargetCol,
                                                                   QueryValueExpression aExpr)
public UpdateAssignmentExpression createUpdateAssignmentExpression(java.util.List aTargetColList,
                                                                   java.util.List aExprList)
public UpdateAssignmentExpression createUpdateAssignmentExpression(java.util.List aTargetColList,
                                                                   QueryExpressionBody aUpdateQuery)
public QueryUpdateStatement createUpdateStatement(TableInDatabase aTargetTable,
                                                  TableCorrelation aAsTable,
                                                  java.util.List aAssignmentList,
                                                  QuerySearchCondition aWhereCond)
public CallStatement createCallStatement(ProcedureReference procRef,
                                         java.util.List argList)
public DataType createUserDefinedTypeFromDomainName(java.lang.String domainName)
public ValueExpressionVariable createVariableExpression(java.lang.String aVarName)
public ValueExpressionRow createValueExpressionRow(java.util.List aExprList)
public ValuesRow createValuesRow(java.util.List aValueExprList)
public ValuesRow createValuesRow(QueryValueExpression aValueExpr)
public java.util.List createValuesRowList(java.util.List aValuesRowList,
                                          ValuesRow aValuesRow)
public WithTableSpecification createWithTableSpecification(java.lang.String aTableIdentifier,
                                                           java.util.List aColumnNameList,
                                                           QueryExpressionBody aWithSource)
public java.util.List createWithTableSpecificationList(java.util.List aTableWithSpecList,
                                                       WithTableSpecification aTableWithSpec)
public static boolean isColumnFunction(java.lang.String aFuncName)
name - the function name to check
public static boolean isDistinctColumnFunction(java.lang.String aFuncName)
name - the function name to check
public QuerySearchCondition negateCondition(QuerySearchCondition aSearchCond,
                                            boolean negate)
public Predicate negatePredicate(Predicate aPredicate,
                                 boolean negate)
public QueryValueExpression setUnaryOperator(QueryValueExpression expr,
                                             int op)
| 
 | ||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||