com.metamatrix.query.processor.proc
Class ExecSqlInstruction

java.lang.Object
  com.metamatrix.query.processor.program.ProgramInstruction
      com.metamatrix.query.processor.proc.ExecSqlInstruction

All Implemented Interfaces:

Describable, java.lang.Cloneable

public class ExecSqlInstruction
extends ProgramInstruction

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

static java.lang.String

RS_NAME

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

ExecSqlInstruction(ProcessorPlan commandPlan, GroupSymbol intoGroup)
Constructor for ExecSqlInstruction.

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.
ProcessorPlan	getProcessorPlan()
void	process(ProcedurePlan procEnv) 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 java.lang.Object

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

Field Detail

RS_NAME

public static final java.lang.String RS_NAME

See Also:

Constant Field Values

Constructor Detail

ExecSqlInstruction

public ExecSqlInstruction(ProcessorPlan commandPlan,
                          GroupSymbol intoGroup)

Constructor for ExecSqlInstruction.

Parameters:

command - Object (such as a ProcessorPlan) that is executed when this instruction is processed.

Method Detail

process

public void process(ProcedurePlan procEnv)
             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 further 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 throws a currentVarContext

MetaMatrixComponentException

MetaMatrixProcessingException

getProcessorPlan

public ProcessorPlan getProcessorPlan()

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()