Class ExecSQL

  • All Implemented Interfaces:
    org.pentaho.di.core.ExtensionDataInterface, HasLogChannelInterface, org.pentaho.di.core.logging.LoggingObjectInterface, org.pentaho.di.core.logging.LoggingObjectLifecycleInterface, org.pentaho.di.core.variables.VariableSpace, StepInterface

    public class ExecSQL
    extends BaseStep
    implements StepInterface
    Execute one or more SQL statements in a script, one time or parameterised (for every row)
    Since:
    10-sep-2005
    Author:
    Matt
    • Method Detail

      • getResultRow

        public static final org.pentaho.di.core.RowMetaAndData getResultRow​(org.pentaho.di.core.Result result,
                                                                            String upd,
                                                                            String ins,
                                                                            String del,
                                                                            String read)
      • processRow

        public boolean processRow​(StepMetaInterface smi,
                                  StepDataInterface sdi)
                           throws org.pentaho.di.core.exception.KettleException
        Description copied from interface: StepInterface
        Perform the equivalent of processing one row. Typically this means reading a row from input (getRow()) and passing a row to output (putRow)).
        Specified by:
        processRow in interface StepInterface
        Overrides:
        processRow in class BaseStep
        Parameters:
        smi - The steps metadata to work with
        sdi - The steps temporary working data to work with (database connections, result sets, caches, temporary variables, etc.)
        Returns:
        false if no more rows can be processed or an error occurred.
        Throws:
        org.pentaho.di.core.exception.KettleException
      • stopRunning

        public void stopRunning​(StepMetaInterface smi,
                                StepDataInterface sdi)
                         throws org.pentaho.di.core.exception.KettleException
        Stop the running query
        Specified by:
        stopRunning in interface StepInterface
        Overrides:
        stopRunning in class BaseStep
        Parameters:
        smi - The metadata that might be needed by the step to stop running.
        sdi - The interface to the step data containing the connections, resultsets, open files, etc.
        Throws:
        org.pentaho.di.core.exception.KettleException - in case something goes wrong