Class TFunctionCall
- All Implemented Interfaces:
Visitable,Iterator<TSourceToken>
- Direct Known Subclasses:
TArrayConcatAggFunction,TDaxFunction,TJsonFunction,TJsonObjectFunction,TRangeNFunction,TTableFunction
TExpression. For other
functions with the different syntax in arguments, please check the detailed information below.
this class includes function name and arguments.
There are 3 types of functions:
- Arguments is a list of expressions
- Analytic function
- Function with specific arguments, such as cast function
function([expr,expr, ...])
- function name:
getFunctionName() - args:
getArgs()
2.Analytic function
Use getWindowDef() to get over clause information.
3.Function with specific arguments
trim
- type:
EFunctionType.trim_t - arg:
getTrimArgument()
cast(expr as typename), cast(expr as typename [,datatypeAttribute]), cast(expr as datatypeAttribute)
- type:
EFunctionType.cast_t - expr:
getExpr1() - typename:
getTypename(), datatypeAttribute is included inTTypeNameas well
convert(typename,[null|not null] expr1 [,expr2]),
- type:
EFunctionType.convert_t - expr1:
getExpr1() - expr2:
getExpr2() - typename:
getTypename()
extract([time_token from expr]),
- type:
EFunctionType.extract_t - expr:
getExpr1() - time_token:
getExtract_time_token()
sql server contains function,contains(in_expr, expr [,langTerm]),
- type:
EFunctionType.contains_t - expr:
getExpr1() - in_expr:
getInExpr()
sql server freetext,freetext(contain in expr, expr [,langTerm])
,- type:
EFunctionType.freetext_t - expr:
getExpr1() - in_expr:
getInExpr()
Oracle Extract(XML): extract(XMLType_instance, XPath_string[,namespace_string]),
- type:
EFunctionType.extractxml_t - XMLType_instance:
getXMLType_Instance() - XPath_string:
getXPath_String() - namespace_string:
getNamespace_String()
Rank(value,...),
- type:
EFunctionType.rank_t - value list
getOrderByList()
XMLPassingClause of XMLExists function
- type:
EFunctionType.xmlexists_t - value list
getPassingClause()
-
Field Summary
FieldsModifier and TypeFieldDescriptionprotected TAnalyticFunctionprotected TExpressionListprotected TExpressionstatic final intDeprecated.static final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.case_n_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.cast_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.contains_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.convert_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.csum_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.date_add_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.date_sub_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.extract_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.extract_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.freetext_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.group_concat_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.match_against_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.ogc_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.position_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.range_n_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.rank_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.subdate_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.substring_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.substring_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.timestampadd_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.timestampdiff_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.translate_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.translate_chk_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.treat_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.trim_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.udf_tstatic final intDeprecated.As of v1.4.3.0, replaced byEFunctionType.xmlquery_tprotected TObjectNameprotected EFunctionTypeprotected TWindowDefprotected TWithinGroupFields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode
dbvendor, doubleLinkedTokenListToString, nodeActionAppend, nodeActionInsert, nodeActionRemove, nodeActionUnknown, nodeActionUpdate, nodeActionUpdateText, nodeChangeEndToken, nodeChangeStartToken -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoidAccept a visitorvoidAccept a visitor to iterate this class and sub-nodes of this classvoiddoParse(TCustomSqlStatement psql, ESqlClause plocation) Analyze the sub-nodes inside this node.against expr in match function of MySQLgetALL | DISTINCT | UNIQUEkeywords used in an aggregate function.Deprecated.As of v1.8.6.3, usegetWindowDef()instead window clause in window function.getArgs()get the list of parameters defined in this functionget datatype defined in Oracle XMLSERIALIZE(value_expr as datatype)get an xml type column, parameter, variable or subquery.The first operand in the cast specification.get column name or column list in SQL Server contains predicate.Not used.date, time or timestamp expression in extract function of DB2, Greenplum.getDummy()Not usedgetExpr1()paramter of following functions
teradata: position function,
sql server: convert;
oracle: convert,translate,cast,oracle XMLSERIALIZE(value_expr), oracle XMLROOT (value_expr)
mysql: substringgetExpr2()getExpr3()return TExpressionList instead of TGroupingExpressionItemList after v1.4.3.3one of the YEAR/MONTH/DAY, HOUR/MINUTE/SECOND keywords in extract functionspark sql filter clause, postgresql filter clauseintDeprecated.As of v1.4.3.0, replaced bygetFunctionType().databricks, current_version().dbsql_version;The length of thegetSourceExpression()string unit to be returned in substring function.column list in match function of MySQLarguments in rank(value,...) function.parameter in function:convert(datetype,parameter,style)XMLPassingClause of XMLExists functioncontains search condition.DB2 listagg function.An expression that specifies the string from which the result is derived in substring function.A start expression that specifies the position withingetSourceExpression()that is to be the first string unit of the result in substring function.DB2 listagg functiongetStyle()style in function:convert(datetype,parameter,style)A structured type expression in subtype-treatment.Over clause of analytic functionXMLAttribute clause in xmlelement functionXMLElement name/evalname exprXMLElement ( value_expr [,XML_attribute_clause] [,value expr list] )XMLFOREST (value_expr [as aliasName], ...booleanvoidInitialize a query tree node.voidvoidvoidbooleanstatic booleanintisColumnInThisTableFunction(TSQLEnv sqlEnv, EDbVendor dbVendor, TObjectName pColumn) voidsetAgainstExpr(TExpression againstExpr) against expr in match function of MySQLvoidsetAggregateType(EAggregateType aggregateType) setALL | DISTINCT | UNIQUEkeywords used in an aggregate function.voidsetAnalyticFunction(TAnalyticFunction analyticFunction) voidsetArgs(TExpressionList args) voidsetAsDatatype(TTypeName asDatatype) datatype defined in Oracle function:XMLSERIALIZE(value_expr as datatype)voidsetBuiltIn(boolean isBuiltIn) voidsetCallTarget(TExpressionCallTarget callTarget) set expressionCallTargetvoidsetCastOperand(TExpression castOperand) cast specification, set the first operand in the cast specificationvoidsetCheckedBuiltIn(boolean isCheckedBuiltIn) voidsetColumnNameOrListExpression(TExpression columnNameOrListExpression) set column name or column list of SQL Server contains predicate or freetext predicatevoidsetDataConversionItems(ArrayList<TDataConversionItem> dataConversionItems) voidsetDatatypeAttribute(TDatatypeAttribute datatypeAttribute) Not used.voidsetDateExpression(TExpression dateExpression) set date, time or timestamp expression in extract/extend function.voidSet value for temporary use onlyvoidsetExpr1(TExpression expr1) voidsetExpr2(TExpression expr2) voidsetExpr3(TExpression expr3) voidsetExprList(TExpressionList exprList) voidsetExtract_time_token(TSourceToken extract_time_token) set one of the YEAR/MONTH/DAY, HOUR/MINUTE/SECOND keyword in extract functionvoidsetExtractXMLArg(TExpressionList exprList) voidsetFilterClause(TDummy filterClause) voidsetFilterClause(TWhereClause filterClause) voidsetFirstArgAsDateTimePart(int pos) voidsetFunctionName(TObjectName functionName) voidvoidsetFunctionType(EFunctionType functionType) voidsetFuncType(int funcType) Deprecated.As of v1.4.3.0voidsetGroupConcatParam(TGroupConcatParam groupConcatParam) voidsetIndirection(TIndirection indirection) voidvoidsetIntervalUnit(String intervalUnit) voidsetLengthExpression(TExpression lengthExpression) set the length expression in substring function.voidsetListaggOverflow(TListaggOverflow listaggOverflow) voidsetMatchColumns(TObjectNameList matchColumns) voidsetNamespace_String(TExpression namespace_String) voidsetOrderByList(TOrderByItemList orderByList) voidsetParameter(TExpression parameter) voidsetPassingClause(TXMLPassingClause passingClause) voidsetSearchCondition(TExpression searchCondition) contains search condition.voidsetSeparatorExpr(TExpression separatorExpr) voidsetSortClause(TOrderBy sortClause) voidsetSourceExpression(TExpression sourceExpression) set an expression that specifies the string from which the result is derived in substring function.voidsetStartExpression(TExpression startExpression) set a start expression that specifies the position withingetSourceExpression()that is to be the first string unit of the result in substring function.voidsetStringExpr(TExpression stringExpr) voidsetStyle(TExpression style) voidsetTrim_Expr(TExpression trim_Expr) voidsetTrim_From_Expr(TExpression trim_From_Expr) voidsetTrimArgument(TTrimArgument trimArgument) voidsetTypeExpression(TExpression typeExpression) a structured type expression in DB2 subtype-treatment: treat.voidsetTypename(TTypeName typename) voidsetWindowDef(TWindowDef windowDef) voidsetWithinGroup(TWithinGroup withinGroup) voidsetXMLAttributesClause(TXMLAttributesClause XMLAttributesClause) voidsetXMLElementNameExpr(TExpression XMLElementNameExpr) voidsetXMLElementValueExprList(TResultColumnList XMLElementValueExprList) voidsetXMLForestValueList(TResultColumnList XMLForestValueList) voidsetXmlPassingClause(TXMLPassingClause xmlPassingClause) voidsetXMLType_Instance(TExpression XMLType_Instance) voidsetXPath_String(TExpression XPath_String) Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode
addAllMyTokensToTokenList, addToTokenChain, appendNewNode, calculateTokenCount, doAppendNewNode, fastSetString, getAnchorNode, getColumnNo, getCommentAfterNode, getCommentBeforeNode, getCompactString, getDummyTag, getEndToken, getEvaluateDatatype, getEvalValue, getGsqlparser, getLineNo, getLocation, getMd5, getNodeStatus, getNodeType, getParentObjectName, getPlainText, getStartToken, getTokenCount, hasNext, init, init, insertAfterAToken, insertNewNodeBeforeMe, isChanged, isTokensInChain, next, refreshAllNodesTokenCount, remove, removeAllMyTokensFromTokenList, removeTokens, removeTokensBetweenNodes, removeTokensBetweenToken, replaceWithNewNode, resetIterator, setAnchorNode, setChanged, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setEndToken, setEndTokenDirectly, setEvaluateDatatype, setEvalValue, setGsqlparser, setIncludingComment, setLocation, setNewSubNode, setNodeStatus, setNodeType, setParent, setPlainText, setStartToken, setStartToken, setStartToken, setStartToken, setStartTokenDirectly, setString, setString2, subNodeInNode, toScript, toString, toString2Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, waitMethods inherited from interface java.util.Iterator
forEachRemaining
-
Field Details
-
filterClause
-
withinGroup
-
windowDef
-
functionType
-
functionName
-
Trim_Expr
-
Trim_From_Expr
-
Args
-
analyticFunction
-
fntUdf
Deprecated.As of v1.4.3.0, replaced byEFunctionType.udf_t- See Also:
-
fntTrim
Deprecated.As of v1.4.3.0, replaced byEFunctionType.trim_t- See Also:
-
fntCast
Deprecated.As of v1.4.3.0, replaced byEFunctionType.cast_t- See Also:
-
fntConvert
Deprecated.As of v1.4.3.0, replaced byEFunctionType.convert_t- See Also:
-
fntExtract
Deprecated.As of v1.4.3.0, replaced byEFunctionType.extract_t- See Also:
-
fntTreat
Deprecated.As of v1.4.3.0, replaced byEFunctionType.treat_t- See Also:
-
fntContains
Deprecated.As of v1.4.3.0, replaced byEFunctionType.contains_t- See Also:
-
fntFreetext
Deprecated.As of v1.4.3.0, replaced byEFunctionType.freetext_t- See Also:
-
fntCaseN
Deprecated.As of v1.4.3.0, replaced byEFunctionType.case_n_t- See Also:
-
fntRangeN
Deprecated.As of v1.4.3.0, replaced byEFunctionType.range_n_t- See Also:
-
fntPosition
Deprecated.As of v1.4.3.0, replaced byEFunctionType.position_t- See Also:
-
fntSubstring
Deprecated.As of v1.4.3.0, replaced byEFunctionType.substring_t- See Also:
-
fntTranslate
Deprecated.As of v1.4.3.0, replaced byEFunctionType.translate_t- See Also:
-
fntTranslateCHK
Deprecated.As of v1.4.3.0, replaced byEFunctionType.translate_chk_t- See Also:
-
fntCSUM
Deprecated.As of v1.4.3.0, replaced byEFunctionType.csum_t- See Also:
-
fntRank
Deprecated.As of v1.4.3.0, replaced byEFunctionType.rank_t- See Also:
-
fntXmlQuery
Deprecated.As of v1.4.3.0, replaced byEFunctionType.xmlquery_t- See Also:
-
fntSubString
Deprecated.As of v1.4.3.0, replaced byEFunctionType.substring_t- See Also:
-
fntAddDate
Deprecated.As of v1.4.3.0, replaced byEFunctionType.adddate_t- See Also:
-
fntDateAdd
Deprecated.As of v1.4.3.0, replaced byEFunctionType.date_add_t- See Also:
-
fntSubDate
Deprecated.As of v1.4.3.0, replaced byEFunctionType.subdate_t- See Also:
-
fntDateSub
Deprecated.As of v1.4.3.0, replaced byEFunctionType.date_sub_t- See Also:
-
fntTimestampAdd
Deprecated.As of v1.4.3.0, replaced byEFunctionType.timestampadd_t- See Also:
-
fntTimestampDiff
Deprecated.As of v1.4.3.0, replaced byEFunctionType.timestampdiff_t- See Also:
-
fntGroupConcat
Deprecated.As of v1.4.3.0, replaced byEFunctionType.group_concat_t- See Also:
-
fntMatchAgainst
Deprecated.As of v1.4.3.0, replaced byEFunctionType.match_against_t- See Also:
-
fntExtractXML
Deprecated.As of v1.4.3.0, replaced byEFunctionType.extract_t- See Also:
-
fntOGC
Deprecated.As of v1.4.3.0, replaced byEFunctionType.ogc_t- See Also:
-
-
Constructor Details
-
TFunctionCall
public TFunctionCall()
-
-
Method Details
-
getFilterClause
spark sql filter clause, postgresql filter clauseSELECT COUNT(*) FILTER (WHERE bid_amount_value < 10000) AS low_range_bid_count_value FROM A
- Returns:
-
setFilterClause
-
setFilterClause
-
setIndirection
-
getIndirection
databricks, current_version().dbsql_version;- Returns:
-
setDataConversionItems
-
getDataConversionItems
-
setListaggOverflow
-
getListaggOverflow
-
setFirstArgAsDateTimePart
-
isColumnInThisTableFunction
-
setWithinGroup
-
getWithinGroup
-
setIntervalUnit
-
getIntervalUnit
-
setStringExpr
-
getStringExpr
DB2 listagg function- Returns:
- the first argument of the listagg function
-
setSeparatorExpr
-
getSeparatorExpr
DB2 listagg function.- Returns:
- the second argument of the listagg function.
-
setSearchCondition
contains search condition. or freetext_string in freetext predicate- Parameters:
searchCondition- contains search condition.
-
getSearchCondition
contains search condition. It usually a string constant or a variable. SQL Server contains predicate.CONTAINS ( { column_name | ( column_list ) | * | PROPERTY ( { column_name }, 'property_name' ) } , '<contains_search_condition>' [ , LANGUAGE language_term ] )Or freetext_string in freetext predicateFREETEXT ( { column_name | (column_list) | * } , 'freetext_string' [ , LANGUAGE language_term ] )- Returns:
- contains search condition
-
setColumnNameOrListExpression
set column name or column list of SQL Server contains predicate or freetext predicate- Parameters:
columnNameOrListExpression- column name or column list- See Also:
-
getColumnNameOrListExpression
get column name or column list in SQL Server contains predicate.CONTAINS ( { column_name | ( column_list ) | * | PROPERTY ( { column_name }, 'property_name' ) } , '<contains_search_condition>' [ , LANGUAGE language_term ] )Or column name or column list in freetext predicateFREETEXT ( { column_name | (column_list) | * } , 'freetext_string' [ , LANGUAGE language_term ] )If this expression represents a column name, then the type of this expression isEExpressionType.simple_object_name_t, if this expression represents a column list, then the type of this expression isEExpressionType.list_t,- Returns:
- column name or column list
-
setStartExpression
set a start expression that specifies the position withingetSourceExpression()that is to be the first string unit of the result in substring function.substring(sourceExpression from startExpression [for lengthExpression]) substring(sourceExpression , startExpression [, lengthExpression])- Parameters:
startExpression- an expression that specifies the position withingetSourceExpression()that is to be the first string unit of the result in substring function- See Also:
-
setLengthExpression
set the length expression in substring function.substring(sourceExpression from startExpression [for lengthExpression]) substring(sourceExpression , startExpression [, lengthExpression])- Parameters:
lengthExpression- the length expression in substring function.- See Also:
-
getStartExpression
A start expression that specifies the position withingetSourceExpression()that is to be the first string unit of the result in substring function.substring
substring(sourceExpression from startExpression [for lengthExpression]) substring(sourceExpression , startExpression [, lengthExpression])- Returns:
- an expression that specifies the position within
getSourceExpression()that is to be the first string unit of the result.
-
getLengthExpression
The length of thegetSourceExpression()string unit to be returned in substring function.substring
substring(sourceExpression from startExpression [for lengthExpression]) substring(sourceExpression , startExpression [, lengthExpression])- Returns:
- the length of the string unit to be returned.
-
setSourceExpression
set an expression that specifies the string from which the result is derived in substring function.substring(sourceExpression from startExpression [for lengthExpression]) substring(sourceExpression , startExpression [, lengthExpression])- Parameters:
sourceExpression- An expression that specifies the string from which the result is derived- See Also:
-
getSourceExpression
An expression that specifies the string from which the result is derived in substring function.substring: DB2
substring(sourceExpression from startExpression [for lengthExpression]) substring(sourceExpression , startExpression [, lengthExpression])- Returns:
- An expression that specifies the string from which the result is derived
-
setTypeExpression
a structured type expression in DB2 subtype-treatment: treat.- Parameters:
typeExpression- a structured type expression- See Also:
-
getTypeExpression
A structured type expression in subtype-treatment.treat function: DB2, Greenplum
- Returns:
- a structured type expression
-
setCastOperand
cast specification, set the first operand in the cast specification- Parameters:
castOperand- set the first operand in the cast specification- See Also:
-
getCastOperand
The first operand in the cast specification.cast specification: DB2, Greenplum,SQL Server; try_cast function of SQL Server
- Returns:
- The first operand in the cast specification
-
setDateExpression
set date, time or timestamp expression in extract/extend function.- Parameters:
dateExpression- date, time or timestamp expression- See Also:
-
getDateExpression
date, time or timestamp expression in extract function of DB2, Greenplum.datetime or date value expression in extend function of informix.
- Returns:
- date, time or timestamp expression
-
setCallTarget
set expressionCallTarget- Parameters:
callTarget- expression call target- See Also:
-
getCallTarget
get an xml type column, parameter, variable or subquery.DECLARE @myDoc xml DECLARE @ProdID int SET @myDoc = '<Root> <ProductDescription ProductID="1" ProductName="Road Bike"> <Features> <Warranty>1 year parts and labor </Warranty> <Maintenance>3 year parts and labor extended maintenance is available </Maintenance> </Features> </ProductDescription> </Root>' SET @ProdID = @myDoc.value('(/Root/ProductDescription/@ProductID)[1]', 'int' ) SELECT @ProdIDthe value returned by this method represents@myDocbefore the value() function. SQL Server value() Method performs an XQuery against the XML and returns a value of SQL type. You typically use this method to extract a value from an XML instance stored in an xml type column, parameter, or variable.- Returns:
- expressionCallTarget that represents an xml type column, parameter, variable or subquery
-
setGroupConcatParam
-
getGroupConcatParam
-
isBuiltIn
-
isBuiltIn
-
setPassingClause
-
getPassingClause
XMLPassingClause of XMLExists function- Returns:
- XMLPassingClause of XMLExists function
-
setAggregateType
setALL | DISTINCT | UNIQUEkeywords used in an aggregate function.- Parameters:
aggregateType-- See Also:
-
getAggregateType
getALL | DISTINCT | UNIQUEkeywords used in an aggregate function. An aggregate function performs a calculation on a set of values, and returns a single value.- Returns:
- aggregate type, one of those values: none,all,distinct,unique
-
setOrderByList
-
getOrderByList
arguments in rank(value,...) function.- Returns:
- a list of
TOrderByItemin function: rank, csum
-
setSortClause
-
getSortClause
-
getWindowDef
Over clause of analytic function- Returns:
- over clause
-
setWindowDef
-
setFunctionOptionsWithDummy
-
getWindowSpecification
-
setDatatypeAttribute
Not used.- Parameters:
datatypeAttribute- datatype attribute
-
getDatatypeAttribute
Not used.- Returns:
- datatype attribute
-
getExtract_time_token
one of the YEAR/MONTH/DAY, HOUR/MINUTE/SECOND keywords in extract function- Returns:
- one of the YEAR/MONTH/DAY, HOUR/MINUTE/SECOND keywords in extract function
-
setExtract_time_token
set one of the YEAR/MONTH/DAY, HOUR/MINUTE/SECOND keyword in extract function- Parameters:
extract_time_token- one of the YEAR/MONTH/DAY, HOUR/MINUTE/SECOND token
-
setDummy
Set value for temporary use only- Parameters:
dummy- a temporary value from parse tree
-
getDummy
Not used- Returns:
- a temporary value
-
setInExpr
-
getInExpr
-
setExtractXMLArg
-
getNamespace_String
-
getXPath_String
-
getXMLType_Instance
-
getMatchColumns
column list in match function of MySQL- Returns:
-
getAgainstExpr
against expr in match function of MySQLMATCH (col1,col2,...) AGAINST (expr [search_modifier])- Returns:
- expression after against keyword
-
setMatchColumns
-
setAgainstExpr
against expr in match function of MySQLMATCH (col1,col2,...) AGAINST (expr [search_modifier])- Parameters:
againstExpr- expression after against keyword
-
setTypename
-
getTypename
-
setParameter
-
setStyle
-
getParameter
parameter in function:convert(datetype,parameter,style)- Returns:
-
getStyle
style in function:convert(datetype,parameter,style)- Returns:
-
getFunctionType
-
hasParenthesis
-
getFieldDefs
-
getFieldValues
-
getFunctionName
-
setTrimArgument
-
getTrimArgument
-
setExpr1
-
setExpr2
-
setAsDatatype
datatype defined in Oracle function:XMLSERIALIZE(value_expr as datatype)- Parameters:
asDatatype- datatype defined in Oracle function:XMLSERIALIZE(value_expr as datatype)
-
setXMLForestValueList
-
setXMLElementNameExpr
-
getXMLElementNameExpr
XMLElement name/evalname expr- Returns:
- XMLElement name/evalname expr
-
setXMLAttributesClause
-
setXmlPassingClause
-
getXmlPassingClause
-
setXMLElementValueExprList
-
getXMLElementValueExprList
XMLElement ( value_expr [,XML_attribute_clause] [,value expr list] )- Returns:
- XMLElement value expr list
-
getXMLAttributesClause
XMLAttribute clause in xmlelement function- Returns:
- XMLAttribute clause in xmlelement function
-
getXMLForestValueList
XMLFOREST (value_expr [as aliasName], ... )- Returns:
- XMLFOREST value list
-
getAsDatatype
get datatype defined in Oracle XMLSERIALIZE(value_expr as datatype)- Returns:
- datatype defined in oracle XMLSERIALIZE function
-
getExpr1
paramter of following functions
teradata: position function,
sql server: convert;
oracle: convert,translate,cast,oracle XMLSERIALIZE(value_expr), oracle XMLROOT (value_expr)
mysql: substring- Returns:
-
getExpr2
-
setExpr3
-
getExpr3
-
setExprList
-
getExprList
return TExpressionList instead of TGroupingExpressionItemList after v1.4.3.3- Returns:
- expr list
-
setArgs
-
init
Description copied from class:TParseTreeNodeInitialize a query tree node. Used internally- Overrides:
initin classTParseTreeNode- Parameters:
arg1- first argument
-
init
- Overrides:
initin classTParseTreeNode
-
init
- Overrides:
initin classTParseTreeNode
-
init
- Overrides:
initin classTParseTreeNode
-
setAnalyticFunction
-
getArgs
get the list of parameters defined in this function- Returns:
- the list of parameter
-
doParse
Description copied from class:TParseTreeNodeAnalyze the sub-nodes inside this node. Such as build the relationship between table and column.- Overrides:
doParsein classTParseTreeNode- Parameters:
psql- SQL statement this node belongs toplocation- SQL clause this node belongs to
-
getAnalyticFunction
Deprecated.As of v1.8.6.3, usegetWindowDef()instead window clause in window function.- Returns:
- a value of
TAnalyticFunction - See Also:
-
accept
Description copied from class:TParseTreeNodeAccept a visitor- Specified by:
acceptin interfaceVisitable- Overrides:
acceptin classTParseTreeNode- Parameters:
v- visitor is a descendant class ofTParseTreeVisitor
-
acceptChildren
Description copied from class:TParseTreeNodeAccept a visitor to iterate this class and sub-nodes of this class- Specified by:
acceptChildrenin interfaceVisitable- Overrides:
acceptChildrenin classTParseTreeNode- Parameters:
v- visitor is a descendant class ofTParseTreeVisitor
-
setFuncType
Deprecated.As of v1.4.3.0 -
getFuncType
Deprecated.As of v1.4.3.0, replaced bygetFunctionType(). -
setCheckedBuiltIn
-
setBuiltIn
-
setXMLType_Instance
-
setXPath_String
-
setNamespace_String
-
setFunctionType
-
setFunctionName
-
setTrim_Expr
-
setTrim_From_Expr
-
EFunctionType.adddate_t