ContextSql (Maximo API)

Skip navigation links

All Classes

Summary:
Nested |
Field |
Constr |
Method

Detail:
Field |
Constr |
Method

java.lang.Object
- com.ibm.tivoli.maximo.dbmanage.connection.ContextSql

```
public class ContextSql
extends java.lang.Object
```
This object is used to link a SQL statement, a context, and a Statement. The context is used to get a connection where the statement is created to execute the SQL.

Constructor Summary

Constructors
Constructor and Description

ContextSql(MTContext context, java.lang.String sql)

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`static java.util.Collection`	`createContexts(java.util.Collection contexts, java.lang.String sql)` Build multiple ContextSql with the same SQL.
`MTContext`	`getContext()`
`java.lang.String`	`getSql()`
`java.sql.Statement`	`getStatement()`
`int`	`getSubParamIndex(int parameterIndex)` Get the parameter number.
`void`	`setIndexRenumbering(int[] renumberIndex)` Give the renumbering array.
`void`	`setStatement(java.sql.Statement statement)`
`java.lang.String`	`toString()`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

ContextSql

public ContextSql(MTContext context,
                  java.lang.String sql)

Method Detail
- setStatement
```
public void setStatement(java.sql.Statement statement)
```
- getContext
```
public MTContext getContext()
```
- getSql
```
public java.lang.String getSql()
```
- getStatement
```
public java.sql.Statement getStatement()
```
- toString
```
public java.lang.String toString()
```
  Overrides:
  
  toString in class java.lang.Object
- createContexts
```
public static java.util.Collection createContexts(java.util.Collection contexts,
                                                  java.lang.String sql)
```
  Build multiple ContextSql with the same SQL.
  
  Parameters:
  
  contexts -
  
  sql -
  
  Returns:
- setIndexRenumbering
```
public void setIndexRenumbering(int[] renumberIndex)
```
  Give the renumbering array. The value at the index position gives the renumber value.
  
  Parameters:
  
  renumberIndex -
- getSubParamIndex
```
public int getSubParamIndex(int parameterIndex)
```
  Get the parameter number. If there is a renumbering array, it's used to give the renumbered index number.
  
  Parameters:
  
  parameterIndex -
  
  Returns:
  
  the parameter index to use.