Running a Function/Query

Get Metadata (Optional)

Once there is a connection to an EIS, it is possible to obtain metadata on available functions and query objects.

For Functions:

From IConnection get IFunctionsMetadata , from which you get a list of functions, and can drill down for parameter information.

For Queries:

From IConnection get IObjectsMetadata and drill down for information about relations.

Execute

For Functions:

1. IConnection.createInteractionEx() to get IInteraction .

2. Iinteraction.getIInteractionSpec() to get InteractionSpec .

3. With IInteractionSpec :

   1. Set name of function.

   2. Set input (if necessary).

      From IInteraction you can create an indexed or mapped record.

      IInteraction.getRecordFactory

      RecordFactory.createIndexedRecord or RecordFactory.createMappedRecord

   3. Iinteraction.execute(IinteractionSpec,Record)

For Queries:

The connector can have query execution capability. If the back end has a hierarchical object model and the connector supports execution by query string, you can do the following:

1. From IConnection get INativeQuery .

2. INativeQuery.execute(String queryString)

This would be typical if you are accessing an RDBMS using the JDBC Connector . However not all connectors to back ends that have a hierarchical object model support this type of execution, for example, the SAP System Connector . An alternative for the query string execution is:

1. From IConnection get IExecution .

2. IExecution.execute(IOperation operation)