gudusoft.gsqlparser.stmt.mssql

Class TMssqlCreateFunction

java.lang.Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TBlockSqlStatement

gudusoft.gsqlparser.stmt.TStoredProcedureSqlStatement

gudusoft.gsqlparser.stmt.mssql.TMssqlCreateFunction

All Implemented Interfaces:

Visitable

public class TMssqlCreateFunction
extends TStoredProcedureSqlStatement

Field Summary

Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement

dbvendor, dummytag, isparsed, joins, parser, plsqlparser, rootNode, sourcetokenlist, sqlstatementtype, tables

Constructor Summary

Constructors

Constructor and Description
TMssqlCreateFunction(EDbVendor dbvendor)

Method Summary

Modifier and Type	Method and Description
void	accept(TParseTreeVisitor v) Accept a visitor
void	acceptChildren(TParseTreeVisitor v) Accept a visitor to iterate this class and sub-nodes of this class
int	doParseStatement(TCustomSqlStatement psql)
TMssqlBlock	getBlock()
TObjectName	getFunctionName() The name that you give to the function that you are declaring or defining.
int	getFunctionType() this is used for backward compatibility of .NET version TMssqlCreateFunction.functiontype please use returnMode in java version
TPTNodeList<TProcedureOption>	getProcedureOptions()
TTypeName	getReturnDataType()
int	getReturnMode() create function of sql server may return normal datatype, or return TABLE, or TABLE with variable
TMssqlReturn	getReturnStmt()
TTableElementList	getReturnTableDefinitions()
TObjectName	getReturnTableVaraible()
TObjectName	getStoredProcedureName()
void	setBlock(TMssqlBlock block)
void	setFunctionName(TObjectName functionName)
void	setFunctionType(int functionType)
void	setProcedureOptions(TPTNodeList<TProcedureOption> procedureOptions)
void	setReturnDataType(TTypeName returnDataType)
void	setReturnMode(int returnMode)
void	setReturnStmt(TMssqlReturn returnStmt)
void	setReturnTableDefinitions(TTableElementList returnTableDefinitions)
void	setReturnTableVaraible(TObjectName returnTableVaraible)

Methods inherited from class gudusoft.gsqlparser.stmt.TStoredProcedureSqlStatement

getDeclareStatements, getParameterDeclarations, setDeclareStatements, setParameterDeclarations

Methods inherited from class gudusoft.gsqlparser.stmt.TBlockSqlStatement

getBodyStatements, setBodyStatements

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement

addToTables, addWhereClause, analyzeFromTable, analyzeJoin, analyzeTablename, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, clearError, dochecksyntax, findTable, fireOnMetaDatabaseTableColumn, getAncestorStmt, getCteList, getDaxFunctionStack, getEndlabelName, getErrorCount, getFirstPhysicalTable, getIndexColumns, getJoins, getLabelName, getOrphanColumns, getOutputClause, getParentStmt, getResultColumnList, getReturningClause, getStatements, getSymbolTable, getTables, getTargetTable, getTopClause, getTopStatement, getVariableStack, getWhereClause, isnzplsql, isoracleplsql, ispgplsql, isTableACTE, isverticaplsql, linkColumnReferenceToTable, linkColumnToTable, linkToFirstTable, locateVariableOrParameter, OracleStatementCanBeSeparatedByBeginEndPair, parseerrormessagehandle, parsestatement, searchCTEList, searchDaxVariableInStack, setCteList, setEndlabelName, setLabelName, setOutputClause, setParentStmt, setResultColumnList, setReturningClause, setTargetTable, setTopClause, setVariableStack, setWhereClause, VerticaStatementCanBeSeparatedByBeginEndPair

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, appendString, doParse, fastSetString, getColumnNo, getDummyTag, getEndToken, getGsqlparser, getLineNo, getNodeType, getStartToken, init, init, init, init, init, init, removeAllMyTokensFromTokenList, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setGsqlparser, setIncludingComment, setNodeType, setStartToken, setStartToken, setStartToken, setStartToken, setString, toScript, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

TMssqlCreateFunction

public TMssqlCreateFunction(EDbVendor dbvendor)

Method Detail

setProcedureOptions

public void setProcedureOptions(TPTNodeList<TProcedureOption> procedureOptions)

getProcedureOptions

public TPTNodeList<TProcedureOption> getProcedureOptions()

getStoredProcedureName

public TObjectName getStoredProcedureName()

Overrides:

getStoredProcedureName in class TStoredProcedureSqlStatement

getFunctionName

public TObjectName getFunctionName()

The name that you give to the function that you are declaring or defining.

Returns:

getReturnMode

public int getReturnMode()

create function of sql server may return normal datatype, or return TABLE, or TABLE with variable

TBaseType.function_return_datatype

TBaseType.function_return_table

TBaseType.function_return_table_variable

if return mode is TBaseType.function_return_datatype, check datatype in returnDataType

if return mode is TBaseType.function_return_table_variable, check returnTableVaraible and tableDefinitions.

Returns:

getBlock

public TMssqlBlock getBlock()

Returns:

statements in create function

getReturnStmt

public TMssqlReturn getReturnStmt()

Returns:

this is the only return statement in create function.

getReturnTableVaraible

public TObjectName getReturnTableVaraible()

getReturnTableDefinitions

public TTableElementList getReturnTableDefinitions()

getReturnDataType

public TTypeName getReturnDataType()

getFunctionType

public int getFunctionType()

this is used for backward compatibility of .NET version TMssqlCreateFunction.functiontype please use returnMode in java version

Returns:

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Overrides:

doParseStatement in class TCustomSqlStatement

accept

public void accept(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor

Specified by:

accept in interface Visitable

Overrides:

accept in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

acceptChildren

public void acceptChildren(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor to iterate this class and sub-nodes of this class

Specified by:

acceptChildren in interface Visitable

Overrides:

acceptChildren in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

setBlock

public void setBlock(TMssqlBlock block)

setReturnStmt

public void setReturnStmt(TMssqlReturn returnStmt)

setFunctionName

public void setFunctionName(TObjectName functionName)

setReturnMode

public void setReturnMode(int returnMode)

setReturnTableVaraible

public void setReturnTableVaraible(TObjectName returnTableVaraible)

setReturnTableDefinitions

public void setReturnTableDefinitions(TTableElementList returnTableDefinitions)

setReturnDataType

public void setReturnDataType(TTypeName returnDataType)

setFunctionType

public void setFunctionType(int functionType)