com.ibm.di.connector.ccmdb.provider
Class QuerySet

java.lang.Object
  com.ibm.di.connector.ccmdb.provider.QuerySet

public class QuerySet
extends Object

This class is responsible for reading of static SQL statements stored in a configurationXML file.

Field Summary

static String	ACTCI_DELETE_BY_GUID
static String	ACTCI_SELECT_ALL
static String	ACTCI_SELECT_BY_CLASSSTRUCTURE
static String	ACTCI_SELECT_BY_GUID
static String	ACTCI_SELECT_CLASSIFICATIONS
static String	ACTCI_SELECT_CLASSIFICATIONS_BY_PARENT
static String	ACTCI_SELECT_NEXT_ACTCIID
static String	ACTCI_SELECT_PROPERTIES_DEF
static String	ACTCIRELATION_DELETE
static String	ACTCIRELATION_DELETE_BY_GUID
static String	ACTCIRELATION_SELECT_ALL
static String	ACTCIRELATION_SELECT_BY_RELATIONNUM
static String	ACTCIRELATION_SELECT_BY_RST
static String	ACTCIRELATION_SELECT_BY_SRC
static String	ACTCIRELATION_SELECT_BY_TRG
static String	ACTCIRELATION_SELECT_CLASSIFICATIONS
static String	ACTCIRELATION_SELECT_NEXT_ACTCIRELID
static String	ACTCIRELATION_SELECT_PROPERTIES_DEF
static String	ACTCISPEC_DELETE
static String	ACTCISPEC_DELETE_BY_ACTCINUM
static String	ACTCISPEC_SELECT_BY_ACTCINUM
static String	ACTCISPEC_SELECT_NEXT_ID
static String	ASSETATTRID_SELECT_MODEL_OBJECT
static String	CCIDELETEDACTCI_SELECT_BY_SRC
static String	CCIDELETEDACTCI_SELECT_PROPERTIES_DEF
static String	CLASSSPEC_SELECT_BY_CLASSSTRUCTURE
static String	OMP_SELECT_BY_GUID
static String	OMP_SELECT_PROPERTIES_DEF
static String	OMPCIRLN_SELECT_BY_ACTCIGUID
static String	OMPCIRLN_SELECT_PROPERTIES_DEF
static String	RELATIONRULES_SELECT_BY_SRC
static String	RELATIONRULES_SELECT_BY_TRG
static String	RELATIONRULES_SELECT_ST

Constructor Summary

QuerySet()

Method Summary

String

getSQLQuery(String queryName)

Methods inherited from class java.lang.Object

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

Field Detail

ACTCIRELATION_SELECT_CLASSIFICATIONS

public static final String ACTCIRELATION_SELECT_CLASSIFICATIONS

See Also:

Constant Field Values

ACTCIRELATION_SELECT_NEXT_ACTCIRELID

public static final String ACTCIRELATION_SELECT_NEXT_ACTCIRELID

See Also:

Constant Field Values

ACTCIRELATION_SELECT_ALL

public static final String ACTCIRELATION_SELECT_ALL

See Also:

Constant Field Values

ACTCIRELATION_SELECT_BY_RST

public static final String ACTCIRELATION_SELECT_BY_RST

See Also:

Constant Field Values

ACTCIRELATION_SELECT_BY_TRG

public static final String ACTCIRELATION_SELECT_BY_TRG

See Also:

Constant Field Values

ACTCIRELATION_SELECT_BY_SRC

public static final String ACTCIRELATION_SELECT_BY_SRC

See Also:

Constant Field Values

ACTCIRELATION_SELECT_BY_RELATIONNUM

public static final String ACTCIRELATION_SELECT_BY_RELATIONNUM

See Also:

Constant Field Values

ACTCIRELATION_SELECT_PROPERTIES_DEF

public static final String ACTCIRELATION_SELECT_PROPERTIES_DEF

See Also:

Constant Field Values

ACTCIRELATION_DELETE

public static final String ACTCIRELATION_DELETE

See Also:

Constant Field Values

ACTCIRELATION_DELETE_BY_GUID

public static final String ACTCIRELATION_DELETE_BY_GUID

See Also:

Constant Field Values

ACTCI_SELECT_CLASSIFICATIONS

public static final String ACTCI_SELECT_CLASSIFICATIONS

See Also:

Constant Field Values

ACTCI_SELECT_CLASSIFICATIONS_BY_PARENT

public static final String ACTCI_SELECT_CLASSIFICATIONS_BY_PARENT

See Also:

Constant Field Values

ACTCI_SELECT_NEXT_ACTCIID

public static final String ACTCI_SELECT_NEXT_ACTCIID

See Also:

Constant Field Values

ACTCI_SELECT_BY_GUID

public static final String ACTCI_SELECT_BY_GUID

See Also:

Constant Field Values

ACTCI_SELECT_ALL

public static final String ACTCI_SELECT_ALL

See Also:

Constant Field Values

ACTCI_SELECT_BY_CLASSSTRUCTURE

public static final String ACTCI_SELECT_BY_CLASSSTRUCTURE

See Also:

Constant Field Values

ACTCI_SELECT_PROPERTIES_DEF

public static final String ACTCI_SELECT_PROPERTIES_DEF

See Also:

Constant Field Values

ACTCI_DELETE_BY_GUID

public static final String ACTCI_DELETE_BY_GUID

See Also:

Constant Field Values

OMP_SELECT_BY_GUID

public static final String OMP_SELECT_BY_GUID

See Also:

Constant Field Values

OMP_SELECT_PROPERTIES_DEF

public static final String OMP_SELECT_PROPERTIES_DEF

See Also:

Constant Field Values

OMPCIRLN_SELECT_BY_ACTCIGUID

public static final String OMPCIRLN_SELECT_BY_ACTCIGUID

See Also:

Constant Field Values

OMPCIRLN_SELECT_PROPERTIES_DEF

public static final String OMPCIRLN_SELECT_PROPERTIES_DEF

See Also:

Constant Field Values

CCIDELETEDACTCI_SELECT_PROPERTIES_DEF

public static final String CCIDELETEDACTCI_SELECT_PROPERTIES_DEF

See Also:

Constant Field Values

CCIDELETEDACTCI_SELECT_BY_SRC

public static final String CCIDELETEDACTCI_SELECT_BY_SRC

See Also:

Constant Field Values

ACTCISPEC_SELECT_BY_ACTCINUM

public static final String ACTCISPEC_SELECT_BY_ACTCINUM

See Also:

Constant Field Values

ACTCISPEC_SELECT_NEXT_ID

public static final String ACTCISPEC_SELECT_NEXT_ID

See Also:

Constant Field Values

ACTCISPEC_DELETE

public static final String ACTCISPEC_DELETE

See Also:

Constant Field Values

ACTCISPEC_DELETE_BY_ACTCINUM

public static final String ACTCISPEC_DELETE_BY_ACTCINUM

See Also:

Constant Field Values

RELATIONRULES_SELECT_ST

public static final String RELATIONRULES_SELECT_ST

See Also:

Constant Field Values

RELATIONRULES_SELECT_BY_TRG

public static final String RELATIONRULES_SELECT_BY_TRG

See Also:

Constant Field Values

RELATIONRULES_SELECT_BY_SRC

public static final String RELATIONRULES_SELECT_BY_SRC

See Also:

Constant Field Values

CLASSSPEC_SELECT_BY_CLASSSTRUCTURE

public static final String CLASSSPEC_SELECT_BY_CLASSSTRUCTURE

See Also:

Constant Field Values

ASSETATTRID_SELECT_MODEL_OBJECT

public static final String ASSETATTRID_SELECT_MODEL_OBJECT

See Also:

Constant Field Values

Constructor Detail

QuerySet

public QuerySet()
         throws InvalidPropertiesFormatException,
                IOException

Throws:

InvalidPropertiesFormatException

IOException

Method Detail

getSQLQuery

public String getSQLQuery(String queryName)

Parameters:

queryName -

Returns:

String