com.metamatrix.query.processor.proc
Class ExecDynamicSqlInstruction

java.lang.Object
  com.metamatrix.query.processor.program.ProgramInstruction
      com.metamatrix.query.processor.proc.CommandInstruction
          com.metamatrix.query.processor.proc.ExecDynamicSqlInstruction

All Implemented Interfaces:

Describable, java.lang.Cloneable

public class ExecDynamicSqlInstruction
extends CommandInstruction

Executes a SQL statement, and remove its results from the buffer manager. Executing this instruction does not modify the values of any of the variables, hence it's results are not important so they are removed immediately.

Field Summary

Fields inherited from interface com.metamatrix.query.processor.Describable

PROP_BINDINGS, PROP_CHILDREN, PROP_CONDITIONS, PROP_CRITERIA, PROP_DATA_COL, PROP_DEFAULT, PROP_DEFAULT_PROGRAM, PROP_ELSE, PROP_ENCODING, PROP_EXECUTION_PLAN, PROP_EXPRESSION, PROP_FORMATTED, PROP_GROUP, PROP_GROUP_COLS, PROP_IN_MEMORY, PROP_INTO_GROUP, PROP_IS_STAGING, PROP_JOIN_CRITERIA, PROP_JOIN_STRATEGY, PROP_JOIN_TYPE, PROP_MESSAGE, PROP_MODEL_NAME, PROP_NAMESPACE, PROP_NAMESPACE_DECL, PROP_NODE_COST_ESTIMATES, PROP_NODE_STATS_LIST, PROP_NODE_STATS_PROPS, PROP_OPTIONAL, PROP_OUTPUT_COLS, PROP_PROGRAM, PROP_PROGRAMS, PROP_RECURSE_DIR, PROP_REMOVE_DUPS, PROP_RESULT_SET, PROP_ROW_LIMIT, PROP_ROW_OFFSET, PROP_SELECT_COLS, PROP_SORT_COLS, PROP_SQL, PROP_TAG, PROP_THEN, PROP_TYPE, PROP_VARIABLE

Constructor Summary

ExecDynamicSqlInstruction(CreateUpdateProcedureCommand parentProcCommand, DynamicCommand command, java.util.List references, QueryMetadataInterface metadata, IDGenerator idGenerator, CapabilitiesFinder capFinder)

Method Summary

java.lang.Object	clone() Returns a deep clone
java.util.Collection	getChildPlans() Finds all nested plans and returns them.
java.util.Map	getDescriptionProperties() Get a description as a set of properties of primitive types such as String, Integer, etc.
void	process(ProgramEnvironment env) Processing this instruction executes the ProcessorPlan for the command on the CommandStatement of the update procedure language.
java.lang.String	toString()

Methods inherited from class com.metamatrix.query.processor.proc.CommandInstruction

cloneReferences, getReferences, setReferences

Methods inherited from class java.lang.Object

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

Constructor Detail

ExecDynamicSqlInstruction

public ExecDynamicSqlInstruction(CreateUpdateProcedureCommand parentProcCommand,
                                 DynamicCommand command,
                                 java.util.List references,
                                 QueryMetadataInterface metadata,
                                 IDGenerator idGenerator,
                                 CapabilitiesFinder capFinder)

Method Detail

process

public void process(ProgramEnvironment env)
             throws BlockedException,
                    MetaMatrixComponentException,
                    MetaMatrixProcessingException

Processing this instruction executes the ProcessorPlan for the command on the CommandStatement of the update procedure language. Executing this plan does not effect the values of any of the variables defined as part of the update procedure and hence the results of the ProcessPlan execution need not be stored for furthur processing. The results are removed from the buffer manager immediately after execution. The program counter is incremented after execution of the plan.

Specified by:

process in class ProgramInstruction

Throws:

BlockedException - if this processing the plan thows a currentVarContext

MetaMatrixComponentException

MetaMatrixProcessingException

See Also:

ProcessorInstruction#process(ProcessorEnvironment)

clone

public java.lang.Object clone()

Returns a deep clone

Overrides:

clone in class ProgramInstruction

Returns:

shallow clone

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

getDescriptionProperties

public java.util.Map getDescriptionProperties()

Description copied from interface: Describable

Get a description as a set of properties of primitive types such as String, Integer, etc.

Specified by:

getDescriptionProperties in interface Describable

Overrides:

getDescriptionProperties in class ProgramInstruction

Returns:

Map of properties

getChildPlans

public java.util.Collection getChildPlans()

Description copied from class: ProgramInstruction

Finds all nested plans and returns them.

Overrides:

getChildPlans in class ProgramInstruction

Returns:

List of ProcessorPlan

Since:

4.2

See Also:

ProgramInstruction.getChildPlans()