com.metamatrix.query.sql.util
Class UpdateProcedureGenerator

java.lang.Object
  com.metamatrix.query.sql.util.UpdateProcedureGenerator

public class UpdateProcedureGenerator
extends java.lang.Object

Use existing query transformation to create a simple insert/update/delete procedure. Only works for the virtual group that maps to single physical group. No expression is allowed in SELECT statement. All required elements must be specified.

Field Summary

static int	DELETE_PROCEDURE
static int	INSERT_PROCEDURE
static int	UPDATE_PROCEDURE

Constructor Summary

UpdateProcedureGenerator()

Method Summary

static CreateUpdateProcedureCommand

createProcedure(int procedureType, java.lang.String virtualGroup, Command queryTransformation, QueryMetadataInterface metadata) Create CreateUpdateProcedureCommand for the specific virtual group.

Methods inherited from class java.lang.Object

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

Field Detail

INSERT_PROCEDURE

public static final int INSERT_PROCEDURE

See Also:

Constant Field Values

UPDATE_PROCEDURE

public static final int UPDATE_PROCEDURE

See Also:

Constant Field Values

DELETE_PROCEDURE

public static final int DELETE_PROCEDURE

See Also:

Constant Field Values

Constructor Detail

UpdateProcedureGenerator

public UpdateProcedureGenerator()

Method Detail

createProcedure

public static CreateUpdateProcedureCommand createProcedure(int procedureType,
                                                           java.lang.String virtualGroup,
                                                           Command queryTransformation,
                                                           QueryMetadataInterface metadata)
                                                    throws MetaMatrixComponentException,
                                                           QueryMetadataException

Create CreateUpdateProcedureCommand for the specific virtual group.

Returns:

Generated procedure or null if no procedure could be generated

Throws:

MetaMatrixComponentException

QueryMetadataException