gudusoft.gsqlparser.nodes
Class TForUpdate

java.lang.Object
  extended by gudusoft.gsqlparser.nodes.TParseTreeNode
      extended by gudusoft.gsqlparser.nodes.TForUpdate
All Implemented Interfaces:
Visitable

public class TForUpdate
extends TParseTreeNode

The FOR UPDATE clause lets you lock the selected rows so that other users cannot lock or update the rows until you end your transaction. This clause only in a top-level SELECT statement, not in subqueries.


Constructor Summary
TForUpdate()
           
 
Method Summary
 void accept(TParseTreeVisitor v)
           
 void doParse(TCustomSqlStatement psql, ESqlClause plocation)
          analyze this node
 TObjectNameList getColumnRefs()
          Use the OF ...
 void init(java.lang.Object arg1)
          Initialize a query tree node.
 
Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode
addAllMyTokensToTokenList, getColumnNo, getDummyTag, getEndToken, getGsqlparser, getLineNo, getNodeType, getStartToken, init, init, init, init, init, setDummyTag, setEndToken, setEndToken, setGsqlparser, setNodeType, setStartToken, setStartToken, setString, toString
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

TForUpdate

public TForUpdate()
Method Detail

getColumnRefs

public TObjectNameList getColumnRefs()
Use the OF ... column clause to lock the select rows only for a particular table or view in a join. The columns in the OF clause only indicate which table or view rows are locked. The specific columns that you specify are not significant. However, you must specify an actual column name, not a column alias. If you omit this clause, then the database locks the selected rows from all the tables in the query.

Returns:

init

public void init(java.lang.Object arg1)
Description copied from class: TParseTreeNode
Initialize a query tree node.

Overrides:
init in class TParseTreeNode

doParse

public void doParse(TCustomSqlStatement psql,
                    ESqlClause plocation)
Description copied from class: TParseTreeNode
analyze this node

Overrides:
doParse in class TParseTreeNode

accept

public void accept(TParseTreeVisitor v)
Specified by:
accept in interface Visitable
Overrides:
accept in class TParseTreeNode