com.jdc.rdb.sql.dml.clause
Class With

java.lang.Object
  |
  +--com.jdc.lang.Object
        |
        +--com.jdc.rdb.sql.SQLClause
              |
              +--com.jdc.rdb.sql.dml.DMLClause
                    |
                    +--com.jdc.rdb.sql.dml.clause.With

All Implemented Interfaces:

Clause, DeleteClause, InsertClause, Serializable, UpdateClause

public class With

extends DMLClause

implements InsertClause, UpdateClause, DeleteClause

With represents a Insert, Update, or Delete SQL statement WITH clause. The WITH clause specifies the isolation level used when locating the rows to be inserted, updated, or deleted. Valid isolation levels are:

• RR - Repeatable Read
• RS - Read Stability
• CS - Cursor Stability
• UR - Uncommitted Read

Reference:

IBM® DB2 Universal Database™ SQL Reference Volume 2 Version 8, Page 500.

Note:

These isolation levels are applicable to IBM® DB2 Universal Database™ only.

Version:

2.0

Author:

Jay Damon

See Also:

Insert, Update, Delete, IsolationLevel, Serialized Form

Field Summary

Fields inherited from class com.jdc.rdb.sql.dml.DMLClause

sqlClause

Fields inherited from class com.jdc.lang.Object

string

Constructor Summary

With()
Constructs a new With clause object.

With(String isolationLevel)
Constructs a new With clause object for the specified Database isolation level.

Method Summary

String	getKeyword() Returns the With clause keyword.
String	getValue() Returns the With clause value.
With	setIsolationLevel(String isolationLevel) Sets the Database isolation level to use when locating rows for SQL statement execution.
String	toString() Returns a String representation of this With clause.

Methods inherited from class com.jdc.rdb.sql.dml.DMLClause

getKeyword

Methods inherited from class com.jdc.rdb.sql.SQLClause

contains, setKeyword, setValue

Methods inherited from class java.lang.Object

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

Constructor Detail

With

public With()

Constructs a new With clause object.

With

public With(String isolationLevel)

Constructs a new With clause object for the specified Database isolation level. Refer to the IsolationLevel class for a list of valid isolation levels.

Throws:

SQLInvalidException - An invalid isolation level is specified.

See Also:

setIsolationLevel(String)

Method Detail

getKeyword

public String getKeyword()

Returns the With clause keyword.

Overrides:

getKeyword in class SQLClause

Returns:

The With clause keyword.

getValue

public String getValue()

Returns the With clause value.

Overrides:

getValue in class SQLClause

Returns:

The With clause value.

setIsolationLevel

public With setIsolationLevel(String isolationLevel)

Sets the Database isolation level to use when locating rows for SQL statement execution. Refer to the IsolationLevel class for a list of valid isolation levels.

Returns:

This With clause object.

Throws:

SQLInvalidException - An invalid isolation level is specified.

toString

public String toString()

Returns a String representation of this With clause.

Specified by:

toString in interface InsertClause

Overrides:

toString in class SQLClause

Returns:

A String representation of this With clause.