Destination (Toolsverse API Reference 5.9)

Object
- com.toolsverse.etl.common.ConditionalExecution
- - com.toolsverse.etl.common.OnException
  - - com.toolsverse.etl.core.engine.Destination

All Implemented Interfaces:

CacheProvider<String,Object>, Block, LocationProvider, Serializable
```
public class Destination
extends OnException
implements Block, CacheProvider<String,Object>
```
Destination is a one of the two building blocks of the ETL scenario: etl process extracts data from the Sources and loads into the Destinations. It implements Block interface and adds some methods and members specific for the Destination. There are can be multiple destinations in the scenario, each with its own DataSet and linked to the different Source. Also it is possible to have destination without source, and special type of destination such as database stored procedure or function. In some cases the code for the destination can be executed in the separate thread.
Example of destination declaration in the scenario file:

<destination>

<name>image</name>

<source>image</source>

<load>

<connection>mssql</connection>

<driver>com.toolsverse.etl.driver.mysql.MsSqlDriver</driver>

</load>

</destination>

Since:

1.0

Version:

2.0

See Also:

Serialized Form

Nested Class Summary
- Nested classes/interfaces inherited from interface com.toolsverse.etl.core.engine.Block
  Block.BlockType

Field Summary

Fields
Modifier and Type	Field and Description
`static String`	`ACTUAL_CONNECTION_NAME_ATTR` The Constant ACTUAL_CONNECTION_NAME_ATTR.
`static String`	`AS_SOURCE_ATTR` The Constant AS_SOURCE_ATTR.
`static String`	`BATCH_WINDOW_ATTR` The Constant BATCH_WINDOW_ATTR.
`static String`	`COND_CONNECTION_ATTR` The Constant COND_CONNECTION_ATTR.
`static String`	`COND_lANG_ATTR` The Constant COND_lANG_ATTR.
`static String`	`CONDITION_ATTR` The Constant CONDITION_ATTR.
`static String`	`CREATE_TABLE_TEMPLATE_ATTR` The Constant CREATE_TABLE_TEMPLATE_ATTR.
`static String`	`CURSOR_NAME_ATTR` The Constant CURSOR_NAME_ATTR.
`static String`	`CURSOR_ON_FINISH_ATTR` The Constant CURSOR_ON_FINISH_ATTR.
`static String`	`CURSOR_SQL_ATTR` The Constant CURSOR_SQL_ATTR.
`static String`	`CURSOR_TABLE_ATTR` The Constant CURSOR_TABLE_ATTR.
`static String`	`CURSOR_TABLE_REGULAR_TYPE` The regular table is used to created cursor.
`static String`	`CURSOR_TABLE_TEMP_TYPE` The temporary table is used to created cursor.
`static String`	`CURSOR_TABLE_TEMPORARY_TYPE` types of the table which is used to create cursor.
`static String`	`CURSOR_TABLE_TYPE_ATTR` The Constant CURSOR_TABLE_TYPE_ATTR.
`static String`	`DDL_TYPE` DDL (data definition) sql.
`static String`	`DEST_ATTR` The Constant DEST_ATTR.
`static String`	`DEST_CONNECTION_NAME_ATTR` The Constant DEST_CONNECTION_NAME_ATTR.
`static String`	`EMPTY_ATTR` The Constant EMPTY_ATTR.
`static String`	`ENABLED_ATTR` The Constant ENABLED_ATTR.
`static String`	`ENCODE_ATTR` The Constant ENCODE_ATTR.
`static String`	`ETL_DRIVER_ATTR` The Constant ETL_DRIVER_ATTR.
`static String`	`ETL_DRIVER_CASE_ATTR` The Constant ETL_DRIVER_CASE_ATTR.
`static String`	`FUNC_TYPE` Database function.
`static String`	`GROUP_PARALLEL_ATTR` The Constant GROUP_PARALLEL_ATTR.
`static String`	`HIGH_WATERMARK_ATTR` The Constant HIGH_WATERMARK_ATTR.
`static String`	`HIGH_WATERMARK_CODE_ATTR` The Constant HIGH_WATERMARK_CODE_ATTR.
`static String`	`HIGH_WATERMARK_EXCEPTION_TO_IGNORE_ATTR` The Constant HIGH_WATERMARK_EXCEPTION_TO_IGNORE_ATTR.
`static String`	`HIGH_WATERMARK_START_VALUE_ATTR` The Constant HIGH_WATERMARK_START_VALUE_ATTR.
`static String`	`HIGH_WATERMARK_VALUE_ATTR` The Constant HIGH_WATERMARK_VALUE_ATTR.
`static String`	`IF_AFTER_ATTR` The Constant IF_AFTER_ATTR.
`static String`	`IF_COND_ATTR` The Constant IF_COND_ATTR.
`static String`	`IF_ELSE_ATTR` The Constant IF_ELSE_ATTR.
`static String`	`IF_THEN_ATTR` The Constant IF_THEN_ATTR.
`static String`	`LOAD_ACTION_ATTR` The Constant LOAD_ACTION_ATTR.
`static String`	`LOAD_ACTION_COND` The Constant LOAD_ACTION_COND.
`static String`	`LOAD_ACTION_KEY_ATTR` The Constant LOAD_ACTION_KEY_ATTR.
`static String`	`LOAD_ACTION_LANG` The Constant LOAD_ACTION_LANG.
`static Set<String>`	`LOAD_ACTIONS` The LOAD_ACTIONS.
`static String`	`LOAD_CONDITIONAL` The CONDITIONAL action.
`static String`	`LOAD_DELETE` The DELETE action.
`static String`	`LOAD_IF_EXIST_UPDATE` The AUTOMATED CONDITIONAL action.
`static String`	`LOAD_INSERT` The INSERT action.
`static String`	`LOAD_KEY_AUTOSELECT_ATTR` The Constant LOAD_KEY_AUTOSELECT_ATTR.
`static String`	`LOAD_MERGE` The MERGE action.
`static String`	`LOAD_NOTHING` The DO NOT LOAD action.
`static String`	`LOAD_SKIP_DELETE_WITH_MERGE_ATTR` The Constant LOAD_SKIP_DELETE_WITH_MERGE_ATTR.
`static String`	`LOAD_UPDATE` The LOAD action.
`static String`	`MERGE_CDC_ACTION` The CDC MERGE action.
`static String`	`METADATA_ALTER_ATTR` The Constant METADATA_ALTER_ATTR.
`static String`	`METADATA_ATTR` The Constant METADATA_ATTR.
`static String`	`METADATA_CREATE_ATTR` The Constant METADATA_CREATE_ATTR.
`static String`	`METADATA_DEST_ATTR` The Constant METADATA_DEST_ATTR.
`static String`	`METADATA_INDEXES_ATTR` The Constant METADATA_INDEXES_ATTR.
`static String`	`METADATA_ORDER_ATTR` The Constant METADATA_ORDER_ATTR.
`static String`	`METADATA_SOURCE_ATTR` The Constant METADATA_SOURCE_ATTR.
`static String`	`METADATA_SUFFIX_ATTR` The Constant METADATA_SUFFIX_ATTR.
`static String`	`METADATA_TYPES_ATTR` The Constant METADATA_TYPES_ATTR.
`static String`	`METRICS_ENABLED_ATTR` The Constant METRICS_ENABLED_ATTR.
`static String`	`NAME_ATTR` The Constant NAME_ATTR.
`static String`	`NEW_CONNECTION_ATTR` The NEW_CONNECTION_ATTR.
`static String`	`NO_CONNECTION_ATTR` The Constant NO_CONNECTION_ATTR.
`static String`	`OBJECT_NAME_ATTR` The Constant OBJECT_NAME_ATTR.
`static String`	`ON_EXCEPTION_ACTION_ATTR` The Constant ON_EXCEPTION_ACTION_ATTR.
`static String`	`ON_EXCEPTION_MASK_ATTR` The Constant ON_EXCEPTION_MASK_ATTR.
`static String`	`ON_EXCEPTION_SAVE_POINT_ATTR` The Constant ON_EXCEPTION_SAVE_POINT_ATTR.
`static Map<String,Integer>`	`ON_FINISH` The ON_FINISH.
`static int`	`ON_FINISH_DROP` If destination uses database cursor to load data and cursor is created from the table, previously populated during extract ON_FINISH_DROP means table should be dropped right after etl processed finished with the destination.
`static String`	`ON_FINISH_DROP_STR` The ON_FINISH_DROP code.
`static int`	`ON_FINISH_KEEP` If destination uses database cursor to load data and cursor is created from the table, previously populated during extract ON_FINISH_KEEP means table should not be dropped right after etl processed finished with the destination.
`static String`	`ON_FINISH_KEEP_STR` The ON_FINISH_KEEP code.
`static String`	`OWNER_ATTR` The Constant OWNER_ATTR.
`static String`	`PARALLEL_ATTR` The Constant PARALLEL_ATTR.
`static String`	`PARENT_ETL_DRIVER_ATTR` The Constant PARENT_ETL_DRIVER_ATTR.
`static String`	`PER_RECORD` The PER RECORD action.
`static String`	`PER_RECORD_IFEXIST` The PER RECORD IFEXIST action.
`static String`	`PER_RECORD_MERGE` The PER RECORD MERGE action.
`static Map<String,String>`	`PER_RECORD_TO_DESTINATION_ACTION` The per record to destination action.
`static String`	`PROC_TYPE` Database stored procedure.
`static String`	`READER_ATTR` The Constant READER_ATTR.
`static String`	`REGULAR_TYPE` Destination with data set.
`static String`	`REPLICATION_ATTR` The Constant REPLICATION_ATTR.
`static String`	`SCOPE_ATTR` The Constant SCOPE_ATTR.
`static String`	`SCOPE_GLOBAL` The global scope.
`static String`	`SCOPE_SINGLE` The single scope.
`static String`	`SOURCE_ATTR` The Constant SOURCE_ATTR.
`static String`	`SQL_ATTR` The Constant SQL_ATTR.
`static String`	`STREAM_ATTR` The Constant STREAM_ATTR.
`static String`	`TABLE_TYPE` Database table.
`static String`	`TARGET_ATTR` The Constant TARGET_ATTR.
`static String`	`TARGET_DRIVER_ATTR` The Constant TARGET_DRIVER_ATTR.
`static String`	`TEMP_TABLE_ATTR` The TEMP_TABLE_ATTR.
`static String`	`TYPE_ATTR` The Constant TYPE_ATTR.
`static String`	`USE_BIND_VARS_ATTR` The Constant USE_BIND_VARS_ATTR.
`static String`	`WAIT_TYPE` The empty destination which does nothing except all running destination threads have to finish before this one..
`static String`	`WRITER_ATTR` The Constant WRITER_ATTR.

Fields inherited from class com.toolsverse.etl.common.OnException
ON_EXCEPTION, ON_EXCEPTION_CONTINUE, ON_EXCEPTION_CONTINUE_STR, ON_EXCEPTION_IGNORE, ON_EXCEPTION_IGNORE_STR, ON_EXCEPTION_MERGE, ON_EXCEPTION_MERGE_STR, ON_EXCEPTION_RAISE, ON_EXCEPTION_RAISE_KEY, ON_EXCEPTION_RAISE_STR, ON_EXCEPTION_TYPE, ON_PARSE_EXCEPTION, ON_PARSE_EXCEPTION_STR

Constructor Summary

Constructors
Constructor and Description

Destination()
Instantiates a new destination.

Constructors
Constructor and Description
`Destination()` Instantiates a new destination.

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addDataSetChangeListener(DataSetChangeListener dataSetChangeListener)` Add the data set change listener.
`void`	`addStatement(String sql, Object statement)` Add the prepared SQL statement.
`void`	`enableMetrics(boolean value)` Enable/disable capturing metrics.
`void`	`fireDataSetChangeListeners(DataSetFields fields, DataSetRecord record)` Fire data set change listeners.
`int`	`getActualBatchWindow()` Gets the actual batch window.
`String`	`getActualConnectionName()` Gets the actual connection name.
`String`	`getActualLoadAction()` Gets the actual load action.
`String`	`getAfter()` Gets the block of code which is executed after all auto generated and conditional blocks of the destination.
`int`	`getBatchCounter()` Gets the batch counter.
`int`	`getBatchWindow()` Gets the number of statements to add to the batch.
`ListHashMap<String,Task>`	`getBeforeEtlTasks()` Gets the tasks which are executed before etl framework starts processing the `DataSet` object associated with the particular scenario block but after initializing is done.
`Block.BlockType`	`getBlockType()` Gets the {#link BlockType}.
`Cache<String,Object>`	`getCache()` Gets the cache associated with the destination.
`String`	`getCalculatedTableName()` Gets the calculated table name.
`String`	`getCondition()` Gets the condition string, usually sql, executed before the code for the destination.
`Connection`	`getConnection()` Gets the actual JDBC connection associated with the scenario block.
`String`	`getConnectionName()` Gets the name of the connection associated with the scenario block.
`String`	`getConnectionNameForHighWatermark()` Gets the connection name to calculate the high-watermark field value.
`String`	`getCreateTableTemplate()` Gets the creates the table template.
`String`	`getCursorSql()` Gets the cursor sql.
`String`	`getCursorTableName()` Gets the name of source table for the cursor.
`String`	`getCursorTableName(Driver driver)` Gets the name of the source table for the cursor using database specific semantic implemented in the `Driver`.
`String`	`getCursorTableType()` Gets the type of the source table for the cursor.
`String`	`getDataReaderClassName()` Gets the class name of the data reader.
`Map<String,String>`	`getDataReaderParams()` Gets the data reader params.
`DataSet`	`getDataSet()` Gets the `DataSet` object associated with the scenario block.
`List<DataSetChangeListener>`	`getDataSetChangeListeners()` Gets the list of data set change listeners.
`String`	`getDataWriterClassName()` Gets the data writer class name.
`Map<String,String>`	`getDataWriterParams()` Gets the data writer params.
`String`	`getDefaultConnectionName()` Gets the default connection name.
`Map<String,Object>`	`getDefaultValues(Scenario scenario)` Gets the default values for the model used to edit the destination.
`Destination`	`getDestination()` Gets the linked destination.
`Driver`	`getDriver()` Gets the ETL driver.
`String`	`getDriverClassName()` Gets the class name of the driver.
`String`	`getElse()` Gets the block of code which is executed after "else" in the `if something then then_code else else_code end if;`.
`Point`	`getEndLocation()` Gets the end location.
`String`	`getHighWatermarkCode()` Gets the high watermark code.
`String`	`getHighWatermarkField()` Gets the high watermark field.
`Object`	`getHighWatermarkFieldValue()` Gets the high watermark field value.
`Object`	`getHighWatermarkFieldValueOnStart()` Gets the high watermark field value on start.
`String`	`getHwmSqlExceptionToIgnore()` Gets the hwm sql Exception to ignore.
`String`	`getIdForException()` Gets the id for exception.
`String`	`getIndexSuffix()` Gets the index suffix.
`ListHashMap<String,Task>`	`getInlineTasks()` Gets the tasks which are executed for each row of the `DataSet` object associated with the scenario block.
`String`	`getLoadAction()` Gets the load action.
`String`	`getLoadActionConditions()` Gets the load action evaluation conditions.
`String`	`getLoadActionLang()` Gets the load action evaluation language (null = JavaScript).
`String`	`getLoadKey()` Gets the load key.
`LinkedCaseInsensitiveMap<String>`	`getLoadKeys()` Gets the load keys.
`TypedKeyValue<Point,Point>`	`getLocation(String key)` Gets the location of the collection artifact such as tasks, variables, etc.
`Map<String,TypedKeyValue<Point,Point>>`	`getLocations()` The the locations of the collection artifacts such as tasks, variables, etc.
`String`	`getLowerCaseLoadActionCond()` Gets the lower case load action conditions.
`Map<String,FieldDef>`	`getMetaData()` Gets the meta data.
`String`	`getMetadataExtractorClass()` Gets the metadata extractor class.
`List<String>`	`getMissingFields()` Gets the fields missing in destination.
`String`	`getName()` Gets the name.
`String`	`getObjectName()` Gets the name of the object.
`ListHashMap<String,Task>`	`getOnExceptionTasks()` Gets the tasks which are executed when there is an exception during processing of the etl block.
`int`	`getOnFinish()` Gets the type of action on finish (when etl process finished processing destination).
`int`	`getOnFinish(String action)` Parses string value of the type of action on finish.
`String`	`getOriginalName()` Gets the original block name.
`String`	`getOwnerName()` Gets the owner name.
`ListHashMap<String,Task>`	`getPostTasks()` Gets the tasks which are executed after etl framework finished with the processing of the particular scenario block.
`ListHashMap<String,Variable>`	`getScenarioVariables()` Gets the variables linked to the scenario.
`String`	`getScope()` Gets the scope.
`Source`	`getSource()` Gets the source, linked to the destination.
`String`	`getSourceName()` Gets the name of the source how it set in the ETL scenario.
`Source`	`getSourceToUse()` Gets the source, linked to the destination or if exists - source derived from the linked destination.
`String`	`getSql()` Gets the sql for the load.
`Point`	`getStartLocation()` Gets the start location.
`LinkedHashMap<String,Object>`	`getStatements()` Gets the prepared SQL statements.
`String`	`getTarget()` Gets the target.
`String`	`getTargetDriver()` Gets the target driver.
`ListHashMap<String,Task>`	`getTasks()` Gets the tasks which are executed before etl framework starts processing of the particular scenario block.
`String`	`getThen()` Gets the block of code which is executed after "then" in the `if something then then_code else else_code end if;`.
`String`	`getThreadGroupName()` Gets the thread group name.
`String`	`getType()` Gets the type of the Destination.
`boolean`	`getUseMetadataDataTypes()` Gets the "use the metadata data types" flag.
`Variable`	`getVariable(String... name)` Gets the variable by name.
`ListHashMap<String,Variable>`	`getVariables()` Gets the variables.
`void`	`incBatchCounter()` Increment batch counter.
`boolean`	`isAlter()` Checks if the destination table must be altered.
`boolean`	`isAutoSelectLoadKey()` Checks if is auto select load key.
`boolean`	`isCreateIndexes()` Checks if indexes need to be created from the source when creating a table.
`boolean`	`isCursorTableTemp()` Checks if the source table for the cursor is temporary.
`boolean`	`isEmpty()` Checks if `DataSet` object associated with the scenario block is empty.
`boolean`	`isEnableChangeReplication()` Checks if change replication is enabled.
`boolean`	`isEnabled()` Checks if scenario block is enabled.
`boolean`	`isEncoded()` Checks if encoded flag set for the `DataSet` object associated with the scenario block.
`boolean`	`isGroupThreads()` Returns the flag which enables grouping destinations with the same threadGroupName.
`boolean`	`isIgnoreBindVarCheck()` Checks if is ignore bind var check.
`boolean`	`isKeepDataSet()` Checks if destination should keep data set if it is already exists (default is false).
`boolean`	`isLoadActionSkipDeletesWithMerge()` Checks if is load should skip deletes with cdc merge.
`boolean`	`isLoadKeySet()` Checks if is load key set.
`boolean`	`isMetadataAlter()` Checks if etl process should check if the destination table should be altered.
`boolean`	`isMetadataCreate()` Checks if etl process should check if the destination table should be re-created.
`boolean`	`isMetadataDest()` Checks if is metadata dest.
`boolean`	`isMetadataOrder()` Checks if is metadata order.
`boolean`	`isMetadataSource()` Checks if is metadata source.
`boolean`	`isMetricsEnabled()` Checks if capturing metrics enabled.
`boolean`	`isNewConnection()` Checks if new destination connection should be created for each transformation.
`boolean`	`isNoReader()` Checks if destination should have no reader.
`boolean`	`isNoWriter()` Checks if destination should have no writer.
`boolean`	`isParallel()` Checks if code for the particular scenario block can be executed in the separate thread.
`boolean`	`isProcOrFunc()` Checks if is destination is a stored procedure or function.
`boolean`	`isReCreate()` Checks if the destination table must be re-created.
`boolean`	`isStream()` Checks if data should be streamed from the source to the destination.
`boolean`	`isTempTable()` Checks if destination is a temp table.
`boolean`	`isUsedByOtherDestination()` Checks if this destination is used by other destination.
`boolean`	`needToPopulateLoadKey()` Checks if load key needs to be populated.
`boolean`	`noConnection()` Check if no database connection should be associated with the block.
`void`	`removeDataSetChangeListener(DataSetChangeListener dataSetChangeListener)` Removes the data set change listener.
`void`	`resetBatchCounter()` Reset batch counter.
`void`	`setActualBatchWindow(int actualBatchWindow)` Sets the actual batch window.
`void`	`setActualConnectionName(String actualConnectionName)` Sets the actual connection name.
`void`	`setActualLoadAction(String actualLoadAction)` Sets the actual load action.
`void`	`setAfter(String value)` Sets the block of code which is executed after all auto generated and conditional blocks of the destination.
`void`	`setAlter(boolean alter)` Sets the flag which controls if the destination table must be altered.
`void`	`setAutoSelectLoadKey(boolean autoSelectLoadKey)` Sets the auto select load key.
`void`	`setBatchWindow(int value)` Sets the batch window.
`void`	`setBeforeEtlTasks(ListHashMap<String,Task> value)` Sets the tasks which are executed before etl framework starts processing the `DataSet` object associated with the particular scenario block but after initializing is done.
`void`	`setBlockType(Block.BlockType value)` Sets the block type.
`void`	`setCache(Cache<String,Object> value)` Sets the cache associated with the destination.
`void`	`setCalculatedTableName(String calculatedTableName)` Sets the calculated table name.
`void`	`setCondition(String value)` Sets the condition, usually sql, executed before the code for the destination.
`void`	`setConnection(Connection value)` Sets the actual JDBC connection associated with the scenario block.
`void`	`setConnectionName(String value)` Sets the name of the connection associated with the scenario block.
`void`	`setCreateIndexes(boolean value)` Sets the value of the "create indexes when creating a table from the source" flag.
`void`	`setCreateTableTemplate(String createTableTemplate)` Sets the creates the table template.
`void`	`setCursorSql(String value)` Sets the cursor sql.
`void`	`setCursorTableName(String value)` Sets the name of the source table for the cursor.
`void`	`setCursorTableType(String value)` Sets the type of the source table for the cursor.
`void`	`setDataReaderClassName(String value)` Sets the class name of the data reader.
`void`	`setDataReaderParams(Map<String,String> value)` Sets the data reader params.
`void`	`setDataSet(DataSet value, boolean adjust)` Sets the `DataSet` object associated with the scenario block.
`void`	`setDataWriterClassName(String value)` Sets the data writer class name.
`void`	`setDataWriterParams(Map<String,String> value)` Sets the data writer params.
`void`	`setDestination(Destination value)` Sets the destination, linked to the destination.
`void`	`setDriverClassName(String value)` Sets the class name of the driver.
`void`	`setElse(String value)` Sets the block of code which is executed after "else" in the `if something then then_code else else_code end if;`
`void`	`setEnableChangeReplication(boolean enableChangeReplication)` Sets the "enable change replication" flag.
`void`	`setEnabled(boolean value)` Sets the enabled property of the scenario block.
`void`	`setEncoded(boolean value)` Sets the encoded flag for the `DataSet` object associated with the scenario block.
`void`	`setGroupThreads(boolean groupThreads)` Sets the flag which enables grouping destinations with the same threadGroupName
`void`	`setHighWatermarkCode(String highWatermarkCode)` Sets the high watermark code.
`void`	`setHighWatermarkField(String highWatermarkField)` Sets the high watermark field.
`void`	`setHighWatermarkFieldValue(Object highWatermarkFieldValue)` Sets the high watermark field value.
`void`	`setHighWatermarkFieldValueOnStart(Object highWatermarkFieldValueOnStart)` Sets the high watermark field value on start.
`void`	`setHwmSqlExceptionToIgnore(String hwmSqlExceptionToIgnore)` Sets the hwm sql exception to ignore.
`void`	`setIgnoreBindVarCheck(boolean ignoreBindVarCheck)` Sets the ignore bind var check.
`void`	`setIndexSuffix(String value)` Sets the index suffix.
`void`	`setInlineTasks(ListHashMap<String,Task> value)` Sets the tasks which are executed for each row of the `DataSet` object associated with the scenario block.
`void`	`setIsEmpty(boolean value)` Sets the state of the field `isEmpty` for the scenario block regardless of the actual state of the `DataSet` object.
`void`	`setKeepDataSet(boolean value)` Sets the "is keep data set" flag.
`void`	`setLoadAction(String value)` Sets the load action.
`void`	`setLoadActionCond(String value)` Sets the load action evaluation conditions.
`void`	`setLoadActionLang(String value)` Sets the load action evaluation language.
`void`	`setLoadActionSkipDeletesWithMerge(boolean loadActionSkipDeletesWithMerge)` Sets the flag which when enabled will trigger skipping the deletes when executing cdc merge action.
`void`	`setLoadKey(String value)` Sets the load key.
`void`	`setLoadKeySet(boolean loadKeySet)` Sets the load key set.
`void`	`setLocation(boolean doSet, String key, org.w3c.dom.Node treesNode)` Set the location for the artifacts such as tasks, variables, etc.
`void`	`setLocation(boolean doSet, String key, TypedKeyValue<Point,Point> location)` Set the location for the artifacts such as tasks, variables, etc.
`void`	`setMetaData(Map<String,FieldDef> value)` Sets the meta data.
`void`	`setMetadataAlter(boolean metadataAlter)` Sets the flag which controls if the etl process should check if the destination table should be altered
`void`	`setMetadataCreate(boolean metadataCreate)` Sets the flag which controls if the etl process should check if the destination table should be re-created
`void`	`setMetadataDest(boolean metadataDest)` Sets the metadata dest.
`void`	`setMetadataExtractorClass(String value)` Sets the metadata extractor class name.
`void`	`setMetadataOrder(boolean metadataOrder)` Sets the metadata order.
`void`	`setMetadataSource(boolean metadataSource)` Sets the metadata source.
`void`	`setMissingFields(List<String> missingFields)` Sets the fields missing in destination.
`void`	`setName(String value)` Sets the name.
`void`	`setNewConnection(boolean newConnection)` Sets the "new connection" flag.
`void`	`setNoConnection(boolean value)` Sets the "no connection" flag.
`void`	`setNoReader(boolean value)` Sets the "no reader" flag.
`void`	`setNoWriter(boolean value)` Sets the "no writer" flag.
`void`	`setObjectName(String value)` Sets the name of the object.
`void`	`setOnExceptionTasks(ListHashMap<String,Task> value)` Sets the tasks which are executed when there is an exception during processing of the etl block.
`void`	`setOnFinish(int value)` Sets the type of action on finish (when etl process finished processing destination).
`void`	`setOnFinish(String action)` Sets the the type of action on finish based on string value.
`void`	`setOriginalName(String name)` Sets the original block name.
`void`	`setOwnerName(String value)` Sets the owner name.
`void`	`setParallel(boolean value)` Sets the the property isParallel for the scenario block.
`void`	`setPostTasks(ListHashMap<String,Task> value)` Sets the tasks which are executed after etl framework finished with the processing of the particular scenario block.
`void`	`setReCreate(boolean reCreate)` Sets the flag which controls if the destination table must be re-created.
`void`	`setScenarioVariables(ListHashMap<String,Variable> value)` Sets the variables which belongs to the scenario.
`void`	`setScope(String value)` Sets the scope.
`void`	`setSource(Source value)` Sets the source, linked to the destination.
`void`	`setSourceName(String value)` Sets the name of the source.
`void`	`setSql(String value)` Sets the sql for the load.
`void`	`setStream(boolean value)` Sets the "stream" flag.
`void`	`setTarget(String target)` Sets the target.
`void`	`setTargetDriver(String targetDriver)` Sets the target driver.
`void`	`setTasks(ListHashMap<String,Task> value)` Sets the tasks which are executed before etl framework starts processing of the particular scenario block.
`void`	`setTempTable(boolean tempTable)` Sets the "temp table" flag.
`void`	`setThen(String value)` Sets the block of code which is executed after "then" in the `if something then then_code else else_code end if;` It is important to understand that the auto generated code, for example "insert into" will be executed in the same block as "then".
`void`	`setThreadGroupName(String threadGroupName)` Sets the thread group name.
`void`	`setType(String value)` Sets the type of the destination.
`void`	`setUseBindVars(boolean value)` Sets the "use bind vars" flag.
`void`	`setUsedByOtherDestination(boolean value)` Sets the "used by other destination" flag.
`void`	`setUseMetadataDataTypes(boolean value)` Sets the "use the metadata data types" flag.
`void`	`setVariables(ListHashMap<String,Variable> value)` Sets the variables for the block.
`List<FieldDef>`	`updateFields(Driver driver, boolean add)` Updates fields visibility based on variable.isInclude() flag.
`boolean`	`useBindVars()` If true framework will try to use bind variables on insert/update/delete.

Methods inherited from class com.toolsverse.etl.common.OnException
findException, getExceptionActions, getExceptionMask, getKeyFields, getMessage, getOnExceptionAction, getOnExceptionActions, handleException, hasAllExceptions, isSavePoint, log, setExceptionMask, setKeyFields, setMessage, setOnExceptionAction, setOnExceptionAction, setSavePoint

Methods inherited from class com.toolsverse.etl.common.ConditionalExecution
getConditionCode, getConditionConnectionName, getConditionLang, setConditionCode, setConditionConnectionName, setConditionLang

Methods inherited from class Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - DEST_ATTR
```
public static final String DEST_ATTR
```
    The Constant DEST_ATTR.
    
    See Also:
    
    Constant Field Values
  - NAME_ATTR
```
public static final String NAME_ATTR
```
    The Constant NAME_ATTR.
    
    See Also:
    
    Constant Field Values
  - OBJECT_NAME_ATTR
```
public static final String OBJECT_NAME_ATTR
```
    The Constant OBJECT_NAME_ATTR.
    
    See Also:
    
    Constant Field Values
  - OWNER_ATTR
```
public static final String OWNER_ATTR
```
    The Constant OWNER_ATTR.
    
    See Also:
    
    Constant Field Values
  - SOURCE_ATTR
```
public static final String SOURCE_ATTR
```
    The Constant SOURCE_ATTR.
    
    See Also:
    
    Constant Field Values
  - NO_CONNECTION_ATTR
```
public static final String NO_CONNECTION_ATTR
```
    The Constant NO_CONNECTION_ATTR.
    
    See Also:
    
    Constant Field Values
  - PARALLEL_ATTR
```
public static final String PARALLEL_ATTR
```
    The Constant PARALLEL_ATTR.
    
    See Also:
    
    Constant Field Values
  - GROUP_PARALLEL_ATTR
```
public static final String GROUP_PARALLEL_ATTR
```
    The Constant GROUP_PARALLEL_ATTR.
    
    See Also:
    
    Constant Field Values
  - NEW_CONNECTION_ATTR
```
public static final String NEW_CONNECTION_ATTR
```
    The NEW_CONNECTION_ATTR.
    
    See Also:
    
    Constant Field Values
  - TEMP_TABLE_ATTR
```
public static final String TEMP_TABLE_ATTR
```
    The TEMP_TABLE_ATTR.
    
    See Also:
    
    Constant Field Values
  - CREATE_TABLE_TEMPLATE_ATTR
```
public static final String CREATE_TABLE_TEMPLATE_ATTR
```
    The Constant CREATE_TABLE_TEMPLATE_ATTR.
    
    See Also:
    
    Constant Field Values
  - EMPTY_ATTR
```
public static final String EMPTY_ATTR
```
    The Constant EMPTY_ATTR.
    
    See Also:
    
    Constant Field Values
  - ENABLED_ATTR
```
public static final String ENABLED_ATTR
```
    The Constant ENABLED_ATTR.
    
    See Also:
    
    Constant Field Values
  - METRICS_ENABLED_ATTR
```
public static final String METRICS_ENABLED_ATTR
```
    The Constant METRICS_ENABLED_ATTR.
    
    See Also:
    
    Constant Field Values
  - ENCODE_ATTR
```
public static final String ENCODE_ATTR
```
    The Constant ENCODE_ATTR.
    
    See Also:
    
    Constant Field Values
  - TYPE_ATTR
```
public static final String TYPE_ATTR
```
    The Constant TYPE_ATTR.
    
    See Also:
    
    Constant Field Values
  - SCOPE_ATTR
```
public static final String SCOPE_ATTR
```
    The Constant SCOPE_ATTR.
    
    See Also:
    
    Constant Field Values
  - AS_SOURCE_ATTR
```
public static final String AS_SOURCE_ATTR
```
    The Constant AS_SOURCE_ATTR.
    
    See Also:
    
    Constant Field Values
  - METADATA_ATTR
```
public static final String METADATA_ATTR
```
    The Constant METADATA_ATTR.
    
    See Also:
    
    Constant Field Values
  - METADATA_TYPES_ATTR
```
public static final String METADATA_TYPES_ATTR
```
    The Constant METADATA_TYPES_ATTR.
    
    See Also:
    
    Constant Field Values
  - METADATA_INDEXES_ATTR
```
public static final String METADATA_INDEXES_ATTR
```
    The Constant METADATA_INDEXES_ATTR.
    
    See Also:
    
    Constant Field Values
  - METADATA_SOURCE_ATTR
```
public static final String METADATA_SOURCE_ATTR
```
    The Constant METADATA_SOURCE_ATTR.
    
    See Also:
    
    Constant Field Values
  - METADATA_DEST_ATTR
```
public static final String METADATA_DEST_ATTR
```
    The Constant METADATA_DEST_ATTR.
    
    See Also:
    
    Constant Field Values
  - METADATA_CREATE_ATTR
```
public static final String METADATA_CREATE_ATTR
```
    The Constant METADATA_CREATE_ATTR.
    
    See Also:
    
    Constant Field Values
  - METADATA_ALTER_ATTR
```
public static final String METADATA_ALTER_ATTR
```
    The Constant METADATA_ALTER_ATTR.
    
    See Also:
    
    Constant Field Values
  - METADATA_ORDER_ATTR
```
public static final String METADATA_ORDER_ATTR
```
    The Constant METADATA_ORDER_ATTR.
    
    See Also:
    
    Constant Field Values
  - METADATA_SUFFIX_ATTR
```
public static final String METADATA_SUFFIX_ATTR
```
    The Constant METADATA_SUFFIX_ATTR.
    
    See Also:
    
    Constant Field Values
  - CURSOR_NAME_ATTR
```
public static final String CURSOR_NAME_ATTR
```
    The Constant CURSOR_NAME_ATTR.
    
    See Also:
    
    Constant Field Values
  - CURSOR_TABLE_ATTR
```
public static final String CURSOR_TABLE_ATTR
```
    The Constant CURSOR_TABLE_ATTR.
    
    See Also:
    
    Constant Field Values
  - CURSOR_SQL_ATTR
```
public static final String CURSOR_SQL_ATTR
```
    The Constant CURSOR_SQL_ATTR.
    
    See Also:
    
    Constant Field Values
  - CURSOR_TABLE_TYPE_ATTR
```
public static final String CURSOR_TABLE_TYPE_ATTR
```
    The Constant CURSOR_TABLE_TYPE_ATTR.
    
    See Also:
    
    Constant Field Values
  - CURSOR_ON_FINISH_ATTR
```
public static final String CURSOR_ON_FINISH_ATTR
```
    The Constant CURSOR_ON_FINISH_ATTR.
    
    See Also:
    
    Constant Field Values
  - STREAM_ATTR
```
public static final String STREAM_ATTR
```
    The Constant STREAM_ATTR.
    
    See Also:
    
    Constant Field Values
  - LOAD_ACTION_ATTR
```
public static final String LOAD_ACTION_ATTR
```
    The Constant LOAD_ACTION_ATTR.
    
    See Also:
    
    Constant Field Values
  - LOAD_ACTION_KEY_ATTR
```
public static final String LOAD_ACTION_KEY_ATTR
```
    The Constant LOAD_ACTION_KEY_ATTR.
    
    See Also:
    
    Constant Field Values
  - LOAD_KEY_AUTOSELECT_ATTR
```
public static final String LOAD_KEY_AUTOSELECT_ATTR
```
    The Constant LOAD_KEY_AUTOSELECT_ATTR.
    
    See Also:
    
    Constant Field Values
  - LOAD_SKIP_DELETE_WITH_MERGE_ATTR
```
public static final String LOAD_SKIP_DELETE_WITH_MERGE_ATTR
```
    The Constant LOAD_SKIP_DELETE_WITH_MERGE_ATTR.
    
    See Also:
    
    Constant Field Values
  - LOAD_ACTION_LANG
```
public static final String LOAD_ACTION_LANG
```
    The Constant LOAD_ACTION_LANG.
    
    See Also:
    
    Constant Field Values
  - LOAD_ACTION_COND
```
public static final String LOAD_ACTION_COND
```
    The Constant LOAD_ACTION_COND.
    
    See Also:
    
    Constant Field Values
  - USE_BIND_VARS_ATTR
```
public static final String USE_BIND_VARS_ATTR
```
    The Constant USE_BIND_VARS_ATTR.
    
    See Also:
    
    Constant Field Values
  - BATCH_WINDOW_ATTR
```
public static final String BATCH_WINDOW_ATTR
```
    The Constant BATCH_WINDOW_ATTR.
    
    See Also:
    
    Constant Field Values
  - HIGH_WATERMARK_ATTR
```
public static final String HIGH_WATERMARK_ATTR
```
    The Constant HIGH_WATERMARK_ATTR.
    
    See Also:
    
    Constant Field Values
  - HIGH_WATERMARK_CODE_ATTR
```
public static final String HIGH_WATERMARK_CODE_ATTR
```
    The Constant HIGH_WATERMARK_CODE_ATTR.
    
    See Also:
    
    Constant Field Values
  - HIGH_WATERMARK_VALUE_ATTR
```
public static final String HIGH_WATERMARK_VALUE_ATTR
```
    The Constant HIGH_WATERMARK_VALUE_ATTR.
    
    See Also:
    
    Constant Field Values
  - HIGH_WATERMARK_START_VALUE_ATTR
```
public static final String HIGH_WATERMARK_START_VALUE_ATTR
```
    The Constant HIGH_WATERMARK_START_VALUE_ATTR.
    
    See Also:
    
    Constant Field Values
  - HIGH_WATERMARK_EXCEPTION_TO_IGNORE_ATTR
```
public static final String HIGH_WATERMARK_EXCEPTION_TO_IGNORE_ATTR
```
    The Constant HIGH_WATERMARK_EXCEPTION_TO_IGNORE_ATTR.
    
    See Also:
    
    Constant Field Values
  - REPLICATION_ATTR
```
public static final String REPLICATION_ATTR
```
    The Constant REPLICATION_ATTR.
    
    See Also:
    
    Constant Field Values
  - ETL_DRIVER_ATTR
```
public static final String ETL_DRIVER_ATTR
```
    The Constant ETL_DRIVER_ATTR.
    
    See Also:
    
    Constant Field Values
  - PARENT_ETL_DRIVER_ATTR
```
public static final String PARENT_ETL_DRIVER_ATTR
```
    The Constant PARENT_ETL_DRIVER_ATTR.
    
    See Also:
    
    Constant Field Values
  - ETL_DRIVER_CASE_ATTR
```
public static final String ETL_DRIVER_CASE_ATTR
```
    The Constant ETL_DRIVER_CASE_ATTR.
    
    See Also:
    
    Constant Field Values
  - DEST_CONNECTION_NAME_ATTR
```
public static final String DEST_CONNECTION_NAME_ATTR
```
    The Constant DEST_CONNECTION_NAME_ATTR.
    
    See Also:
    
    Constant Field Values
  - ACTUAL_CONNECTION_NAME_ATTR
```
public static final String ACTUAL_CONNECTION_NAME_ATTR
```
    The Constant ACTUAL_CONNECTION_NAME_ATTR.
    
    See Also:
    
    Constant Field Values
  - TARGET_ATTR
```
public static final String TARGET_ATTR
```
    The Constant TARGET_ATTR.
    
    See Also:
    
    Constant Field Values
  - TARGET_DRIVER_ATTR
```
public static final String TARGET_DRIVER_ATTR
```
    The Constant TARGET_DRIVER_ATTR.
    
    See Also:
    
    Constant Field Values
  - SQL_ATTR
```
public static final String SQL_ATTR
```
    The Constant SQL_ATTR.
    
    See Also:
    
    Constant Field Values
  - ON_EXCEPTION_ACTION_ATTR
```
public static final String ON_EXCEPTION_ACTION_ATTR
```
    The Constant ON_EXCEPTION_ACTION_ATTR.
    
    See Also:
    
    Constant Field Values
  - ON_EXCEPTION_MASK_ATTR
```
public static final String ON_EXCEPTION_MASK_ATTR
```
    The Constant ON_EXCEPTION_MASK_ATTR.
    
    See Also:
    
    Constant Field Values
  - ON_EXCEPTION_SAVE_POINT_ATTR
```
public static final String ON_EXCEPTION_SAVE_POINT_ATTR
```
    The Constant ON_EXCEPTION_SAVE_POINT_ATTR.
    
    See Also:
    
    Constant Field Values
  - IF_COND_ATTR
```
public static final String IF_COND_ATTR
```
    The Constant IF_COND_ATTR.
    
    See Also:
    
    Constant Field Values
  - IF_THEN_ATTR
```
public static final String IF_THEN_ATTR
```
    The Constant IF_THEN_ATTR.
    
    See Also:
    
    Constant Field Values
  - IF_ELSE_ATTR
```
public static final String IF_ELSE_ATTR
```
    The Constant IF_ELSE_ATTR.
    
    See Also:
    
    Constant Field Values
  - IF_AFTER_ATTR
```
public static final String IF_AFTER_ATTR
```
    The Constant IF_AFTER_ATTR.
    
    See Also:
    
    Constant Field Values
  - COND_lANG_ATTR
```
public static final String COND_lANG_ATTR
```
    The Constant COND_lANG_ATTR.
    
    See Also:
    
    Constant Field Values
  - COND_CONNECTION_ATTR
```
public static final String COND_CONNECTION_ATTR
```
    The Constant COND_CONNECTION_ATTR.
    
    See Also:
    
    Constant Field Values
  - CONDITION_ATTR
```
public static final String CONDITION_ATTR
```
    The Constant CONDITION_ATTR.
    
    See Also:
    
    Constant Field Values
  - READER_ATTR
```
public static final String READER_ATTR
```
    The Constant READER_ATTR.
    
    See Also:
    
    Constant Field Values
  - WRITER_ATTR
```
public static final String WRITER_ATTR
```
    The Constant WRITER_ATTR.
    
    See Also:
    
    Constant Field Values
  - SCOPE_GLOBAL
```
public static final String SCOPE_GLOBAL
```
    The global scope.
    
    See Also:
    
    Constant Field Values
  - SCOPE_SINGLE
```
public static final String SCOPE_SINGLE
```
    The single scope.
    
    See Also:
    
    Constant Field Values
  - REGULAR_TYPE
```
public static String REGULAR_TYPE
```
    Destination with data set. Basically the destination which represents some data.
  - PROC_TYPE
```
public static String PROC_TYPE
```
    Database stored procedure.
  - FUNC_TYPE
```
public static String FUNC_TYPE
```
    Database function.
  - DDL_TYPE
```
public static String DDL_TYPE
```
    DDL (data definition) sql.
  - WAIT_TYPE
```
public static String WAIT_TYPE
```
    The empty destination which does nothing except all running destination threads have to finish before this one..
  - TABLE_TYPE
```
public static String TABLE_TYPE
```
    Database table.
  - ON_FINISH_KEEP
```
public static final int ON_FINISH_KEEP
```
    If destination uses database cursor to load data and cursor is created from the table, previously populated during extract ON_FINISH_KEEP means table should not be dropped right after etl processed finished with the destination.
    
    See Also:
    
    Constant Field Values
  - ON_FINISH_DROP
```
public static final int ON_FINISH_DROP
```
    If destination uses database cursor to load data and cursor is created from the table, previously populated during extract ON_FINISH_DROP means table should be dropped right after etl processed finished with the destination.
    
    See Also:
    
    Constant Field Values
  - ON_FINISH_KEEP_STR
```
public static final String ON_FINISH_KEEP_STR
```
    The ON_FINISH_KEEP code.
    
    See Also:
    
    Constant Field Values
  - ON_FINISH_DROP_STR
```
public static final String ON_FINISH_DROP_STR
```
    The ON_FINISH_DROP code.
    
    See Also:
    
    Constant Field Values
  - ON_FINISH
```
public static final Map<String,Integer> ON_FINISH
```
    The ON_FINISH.
  - CURSOR_TABLE_TEMPORARY_TYPE
```
public static String CURSOR_TABLE_TEMPORARY_TYPE
```
    types of the table which is used to create cursor.
  - CURSOR_TABLE_TEMP_TYPE
```
public static String CURSOR_TABLE_TEMP_TYPE
```
    The temporary table is used to created cursor.
  - CURSOR_TABLE_REGULAR_TYPE
```
public static String CURSOR_TABLE_REGULAR_TYPE
```
    The regular table is used to created cursor.
  - LOAD_INSERT
```
public static final String LOAD_INSERT
```
    The INSERT action.
    
    See Also:
    
    Constant Field Values
  - LOAD_MERGE
```
public static final String LOAD_MERGE
```
    The MERGE action.
    
    See Also:
    
    Constant Field Values
  - LOAD_UPDATE
```
public static final String LOAD_UPDATE
```
    The LOAD action.
    
    See Also:
    
    Constant Field Values
  - LOAD_DELETE
```
public static final String LOAD_DELETE
```
    The DELETE action.
    
    See Also:
    
    Constant Field Values
  - LOAD_CONDITIONAL
```
public static final String LOAD_CONDITIONAL
```
    The CONDITIONAL action.
    
    See Also:
    
    Constant Field Values
  - LOAD_IF_EXIST_UPDATE
```
public static final String LOAD_IF_EXIST_UPDATE
```
    The AUTOMATED CONDITIONAL action.
    
    See Also:
    
    Constant Field Values
  - PER_RECORD
```
public static final String PER_RECORD
```
    The PER RECORD action.
    
    See Also:
    
    Constant Field Values
  - PER_RECORD_MERGE
```
public static final String PER_RECORD_MERGE
```
    The PER RECORD MERGE action.
    
    See Also:
    
    Constant Field Values
  - PER_RECORD_IFEXIST
```
public static final String PER_RECORD_IFEXIST
```
    The PER RECORD IFEXIST action.
    
    See Also:
    
    Constant Field Values
  - LOAD_NOTHING
```
public static final String LOAD_NOTHING
```
    The DO NOT LOAD action.
    
    See Also:
    
    Constant Field Values
  - MERGE_CDC_ACTION
```
public static final String MERGE_CDC_ACTION
```
    The CDC MERGE action.
    
    See Also:
    
    Constant Field Values
  - LOAD_ACTIONS
```
public static final Set<String> LOAD_ACTIONS
```
    The LOAD_ACTIONS.
  - PER_RECORD_TO_DESTINATION_ACTION
```
public static Map<String,String> PER_RECORD_TO_DESTINATION_ACTION
```
    The per record to destination action.
- Constructor Detail
  - Destination
```
public Destination()
```
    Instantiates a new destination.
- Method Detail
  - isIgnoreBindVarCheck
```
public boolean isIgnoreBindVarCheck()
```
    Checks if is ignore bind var check.
    
    Returns:
    
    true, if is ignore bind var check
  - setIgnoreBindVarCheck
```
public void setIgnoreBindVarCheck(boolean ignoreBindVarCheck)
```
    Sets the ignore bind var check.
    
    Parameters:
    
    ignoreBindVarCheck - the new ignore bind var check
  - addDataSetChangeListener
```
public void addDataSetChangeListener(DataSetChangeListener dataSetChangeListener)
```
    Add the data set change listener.
    
    Parameters:
    
    dataSetChangeListener - the dataSetChangeListener to add
  - addStatement
```
public void addStatement(String sql,
                         Object statement)
```
    Add the prepared SQL statement.
    
    Parameters:
    
    sql - the sql
    
    statement - the statement
  - enableMetrics
```
public void enableMetrics(boolean value)
```
    Description copied from interface: Block
    
    Enable/disable capturing metrics.
    
    Specified by:
    
    enableMetrics in interface Block
    
    Parameters:
    
    value - the value
  - fireDataSetChangeListeners
```
public void fireDataSetChangeListeners(DataSetFields fields,
                                       DataSetRecord record)
```
    Fire data set change listeners.
    
    Parameters:
    
    fields - the fields
    
    record - the record
  - getAfter
```
public String getAfter()
```
    Gets the block of code which is executed after all auto generated and conditional blocks of the destination. For example there are blocks "condition", "then" and "else". ETL framework will generated something like if something then then_code else else_code end if; The "after" block will be executed after latest "end if;"
    
    Returns:
    
    the block of code which is executed after if something then then_code else else_code end if;
  - getBatchCounter
```
public int getBatchCounter()
```
    Gets the batch counter.
    
    Returns:
    
    the batch counter
  - getBatchWindow
```
public int getBatchWindow()
```
    Gets the number of statements to add to the batch. Default is -1 which means none. Used only when destination is configured to use bind variables.
    
    Returns:
    
    the the number of statements to add to the batch
  - getBeforeEtlTasks
```
public ListHashMap<String,Task> getBeforeEtlTasks()
```
    Description copied from interface: Block
    
    Gets the tasks which are executed before etl framework starts processing the DataSet object associated with the particular scenario block but after initializing is done. For example: after metadata are collected.
    
    Specified by:
    
    getBeforeEtlTasks in interface Block
    
    Returns:
    
    the tasks as an ListHashMap object
  - getBlockType
```
public Block.BlockType getBlockType()
```
    Description copied from interface: Block
    
    Gets the {#link BlockType}.
    
    Specified by:
    
    getBlockType in interface Block
    
    Returns:
    
    the block type
  - getCache
```
public Cache<String,Object> getCache()
```
    Gets the cache associated with the destination. Cache can be used by the external functions.
    
    Specified by:
    
    getCache in interface CacheProvider<String,Object>
    
    Returns:
    
    the cache
  - getCondition
```
public String getCondition()
```
    Gets the condition string, usually sql, executed before the code for the destination. The simplest example would be "if" condition: something is not null. The etl framework generates code which splits sql on the blocks so the actual code for the destination (for example insert, update or delete) will be executed only if condition applies.
    
    Returns:
    
    the condition
  - getConnection
```
public Connection getConnection()
```
    Description copied from interface: Block
    
    Gets the actual JDBC connection associated with the scenario block.
    
    Specified by:
    
    getConnection in interface Block
    
    Returns:
    
    the connection
  - getConnectionName
```
public String getConnectionName()
```
    Description copied from interface: Block
    
    Gets the name of the connection associated with the scenario block. By default (if not named specifically) the name of the source connection is a "source" and the name of the destination connection is "dest". Connection can be referenced by name from the scenario block such as Source or Destination
    Example of named connection in the scenario file:
    
    <destination>
    
    <name>image</name>
    
    <source>image</source>
    
    <load>
    
    <connection>mssql</connection>
    
    <driver>com.toolsverse.etl.driver.mysql.MsSqlDriver</driver>
    
    </load>
    
    </destination>
    
    Specified by:
    
    getConnectionName in interface Block
    
    Returns:
    
    the name of the connection
  - getCursorSql
```
public String getCursorSql()
```
    Gets the cursor sql.
    
    Returns:
    
    the cursor sql
  - getCursorTableName
```
public String getCursorTableName()
```
    Gets the name of source table for the cursor. This name is used to open and fetch data from the cursor for the load.
    
    Returns:
    
    the name of the source table
  - getCursorTableName
```
public String getCursorTableName(Driver driver)
```
    Gets the name of the source table for the cursor using database specific semantic implemented in the Driver.
    
    Parameters:
    
    driver - The driver
    
    Returns:
    
    the name of the source table
  - getCursorTableType
```
public String getCursorTableType()
```
    Gets the type of the source table for the cursor. Can be either temporary or permanent. The table is used to open cursor and fetch data for the load from from it. The default is temporary if not set otherwise.
    
    Returns:
    
    the type of the source table
  - getDataReaderClassName
```
public String getDataReaderClassName()
```
    Gets the class name of the data reader.
    
    Returns:
    
    the class name of the data reader
  - getDataReaderParams
```
public Map<String,String> getDataReaderParams()
```
    Gets the data reader params.
    
    Returns:
    
    the data reader params
  - getDataSet
```
public DataSet getDataSet()
```
    Description copied from interface: Block
    
    Gets the DataSet object associated with the scenario block.
    
    Specified by:
    
    getDataSet in interface Block
    
    Returns:
    
    the data set
  - getDataSetChangeListeners
```
public List<DataSetChangeListener> getDataSetChangeListeners()
```
    Gets the list of data set change listeners.
    
    Returns:
    
    the list
  - getDataWriterClassName
```
public String getDataWriterClassName()
```
    Gets the data writer class name.
    
    Returns:
    
    the data writer class name
  - getDataWriterParams
```
public Map<String,String> getDataWriterParams()
```
    Gets the data writer params.
    
    Returns:
    
    the data writer params
  - getDefaultConnectionName
```
public String getDefaultConnectionName()
```
    Description copied from class: ConditionalExecution
    
    Gets the default connection name.
    
    Specified by:
    
    getDefaultConnectionName in class ConditionalExecution
    
    Returns:
    
    the default connection name
  - getConnectionNameForHighWatermark
```
public String getConnectionNameForHighWatermark()
```
    Gets the connection name to calculate the high-watermark field value.
    
    Returns:
    
    the connection name to calculate the high-watermark field value
  - getDefaultValues
```
public Map<String,Object> getDefaultValues(Scenario scenario)
```
    Gets the default values for the model used to edit the destination.
    
    Parameters:
    
    scenario - the scenario
    
    Returns:
    
    the default values
  - getDriver
```
public Driver getDriver()
                 throws Exception
```
    Gets the ETL driver.
    
    Returns:
    
    the driver
    
    Throws:
    
    Exception - the exception
  - getDestination
```
public Destination getDestination()
```
    Gets the linked destination.
    
    Returns:
    
    the linked destination
  - getDriverClassName
```
public String getDriverClassName()
```
    Gets the class name of the driver. Driver is used to generate database specific SQL.
    
    Specified by:
    
    getDriverClassName in interface Block
    
    Returns:
    
    the driver class name
  - getElse
```
public String getElse()
```
    Gets the block of code which is executed after "else" in the if something then then_code else else_code end if;.
    
    Returns:
    
    the else
  - getEndLocation
```
public Point getEndLocation()
```
    Description copied from interface: LocationProvider
    
    Gets the end location.
    
    Specified by:
    
    getEndLocation in interface LocationProvider
    
    Returns:
    
    the location
  - getHighWatermarkField
```
public String getHighWatermarkField()
```
    Description copied from interface: Block
    
    Gets the high watermark field.
    
    Specified by:
    
    getHighWatermarkField in interface Block
    
    Returns:
    
    the high watermark field
  - getIndexSuffix
```
public String getIndexSuffix()
```
    Gets the index suffix. It will be added to the index name when index is created from the source.
    
    Returns:
    
    the index suffix
  - getInlineTasks
```
public ListHashMap<String,Task> getInlineTasks()
```
    Description copied from interface: Block
    
    Gets the tasks which are executed for each row of the DataSet object associated with the scenario block.
    
    Specified by:
    
    getInlineTasks in interface Block
    
    Returns:
    
    the inline tasks as an ListHashMap object
  - getLoadAction
```
public String getLoadAction()
```
    Gets the load action.
    
    Returns:
    
    the load action
  - getLoadActionConditions
```
public String getLoadActionConditions()
```
    Gets the load action evaluation conditions.
    
    Returns:
    
    the load action evaluation conditions
  - getLoadActionLang
```
public String getLoadActionLang()
```
    Gets the load action evaluation language (null = JavaScript).
    
    Returns:
    
    the load action evaluation language
  - getLoadKey
```
public String getLoadKey()
```
    Gets the load key.
    
    Returns:
    
    the load key
  - getLocation
```
public TypedKeyValue<Point,Point> getLocation(String key)
```
    Description copied from interface: Block
    
    Gets the location of the collection artifact such as tasks, variables, etc.
    
    Specified by:
    
    getLocation in interface Block
    
    Parameters:
    
    key - the artifact type name
    
    Returns:
    
    the location
  - getLocations
```
public Map<String,TypedKeyValue<Point,Point>> getLocations()
```
    Description copied from interface: Block
    
    The the locations of the collection artifacts such as tasks, variables, etc. The key is an artifact type.
    
    Specified by:
    
    getLocations in interface Block
    
    Returns:
    
    the locations
  - getMetaData
```
public Map<String,FieldDef> getMetaData()
```
    Gets the meta data.
    
    Returns:
    
    the meta data
  - getMetadataExtractorClass
```
public String getMetadataExtractorClass()
```
    Gets the metadata extractor class. Meta data automatically populated during the load if metadata class name is specified at the scenario or destination level.
    
    Returns:
    
    the metadata extractor class name
  - getName
```
public String getName()
```
    Description copied from class: OnException
    
    Gets the name.
    
    Specified by:
    
    getName in interface Block
    
    Overrides:
    
    getName in class OnException
    
    Returns:
    
    the name
  - getObjectName
```
public String getObjectName()
```
    Gets the name of the object. Can be a table name or stored procedure or function name. It used by registered code generator to create database specific load code for the destination.
    
    Returns:
    
    the object name
  - getOnExceptionTasks
```
public ListHashMap<String,Task> getOnExceptionTasks()
```
    Description copied from interface: Block
    
    Gets the tasks which are executed when there is an exception during processing of the etl block.
    
    Specified by:
    
    getOnExceptionTasks in interface Block
    
    Returns:
    
    the on exception tasks as an ListHashMap object
  - getOnFinish
```
public int getOnFinish()
```
    Gets the type of action on finish (when etl process finished processing destination). Possible actions are: ON_FINISH_KEEP, ON_FINISH_DROP.
    
    Returns:
    
    the type of action on finish
  - getOnFinish
```
public int getOnFinish(String action)
```
    Parses string value of the type of action on finish.
    
    Parameters:
    
    action - The action
    
    Returns:
    
    the type of action on finish
  - getOwnerName
```
public String getOwnerName()
```
    Gets the owner name.
    
    Returns:
    
    the owner name
  - getPostTasks
```
public ListHashMap<String,Task> getPostTasks()
```
    Description copied from interface: Block
    
    Gets the tasks which are executed after etl framework finished with the processing of the particular scenario block.
    
    Specified by:
    
    getPostTasks in interface Block
    
    Returns:
    
    the post tasks as an ListHashMap object
  - getScenarioVariables
```
public ListHashMap<String,Variable> getScenarioVariables()
```
    Gets the variables linked to the scenario.
    
    Returns:
    
    the scenario variables
  - getScope
```
public String getScope()
```
    Gets the scope.
    
    Returns:
    
    the scope
  - getSource
```
public Source getSource()
```
    Gets the source, linked to the destination. It is possible to have a destination without source.
    
    Returns:
    
    the source
  - getSourceName
```
public String getSourceName()
```
    Gets the name of the source how it set in the ETL scenario.
    
    Returns:
    
    the source name
  - getSourceToUse
```
public Source getSourceToUse()
```
    Gets the source, linked to the destination or if exists - source derived from the linked destination.
    
    Returns:
    
    the source
  - getSql
```
public String getSql()
```
    Gets the sql for the load. By default etl framework auto generates code for the destination, using associated driver but it is possible to add it manually. Code will be merged with the variables.
    
    Returns:
    
    the sql
  - getStartLocation
```
public Point getStartLocation()
```
    Description copied from interface: LocationProvider
    
    Gets the start location.
    
    Specified by:
    
    getStartLocation in interface LocationProvider
    
    Returns:
    
    the location
  - getStatements
```
public LinkedHashMap<String,Object> getStatements()
```
    Gets the prepared SQL statements.
    
    Returns:
    
    the statements
  - getTasks
```
public ListHashMap<String,Task> getTasks()
```
    Description copied from interface: Block
    
    Gets the tasks which are executed before etl framework starts processing of the particular scenario block.
    
    Specified by:
    
    getTasks in interface Block
    
    Returns:
    
    the tasks as an ListHashMap object
  - getThen
```
public String getThen()
```
    Gets the block of code which is executed after "then" in the if something then then_code else else_code end if;.
    
    Returns:
    
    the block of code executed after "then"
  - getType
```
public String getType()
```
    Gets the type of the Destination. The possible types are: REGULAR_TYPE, PROC_TYPE, FUNC_TYPE, DDL_TYPE, WAIT_TYPE, TABLE_TYPE.
    
    Returns:
    
    the type
  - getUseMetadataDataTypes
```
public boolean getUseMetadataDataTypes()
```
    Gets the "use the metadata data types" flag. If true the dataset data types inherited by the Destination from the Source will be replaced on data types returned by MetadataExtractor
    
    Returns:
    
    the "use metadata data types" flag
  - getVariable
```
public Variable getVariable(String... name)
```
    Description copied from interface: Block
    
    Gets the variable by name.
    
    Specified by:
    
    getVariable in interface Block
    
    Parameters:
    
    name - the name of the variable
    
    Returns:
    
    the variable
  - getVariables
```
public ListHashMap<String,Variable> getVariables()
```
    Description copied from interface: Block
    
    Gets the variables.
    
    Specified by:
    
    getVariables in interface Block
    
    Returns:
    
    the variables
  - incBatchCounter
```
public void incBatchCounter()
```
    Increment batch counter.
  - isCreateIndexes
```
public boolean isCreateIndexes()
```
    Checks if indexes need to be created from the source when creating a table.
    
    Returns:
    
    true, if indexes need to be created from the source when creating a table
  - isCursorTableTemp
```
public boolean isCursorTableTemp()
```
    Checks if the source table for the cursor is temporary.
    
    Returns:
    
    true, if is the source table for the cursor is temporary
  - isEmpty
```
public boolean isEmpty()
```
    Description copied from interface: Block
    
    Checks if DataSet object associated with the scenario block is empty. Scenario block can be configured to be treated as empty regardless of the actual state of the DataSet object.
    
    Specified by:
    
    isEmpty in interface Block
    
    Returns:
    
    true, if empty
  - isEnabled
```
public boolean isEnabled()
```
    Description copied from interface: Block
    
    Checks if scenario block is enabled. For disabled blocks no code will be executed.
    
    Specified by:
    
    isEnabled in interface Block
    
    Returns:
    
    true, if enabled
  - isEncoded
```
public boolean isEncoded()
```
    Description copied from interface: Block
    
    Checks if encoded flag set for the DataSet object associated with the scenario block. Usually only Clob and Blob fields can be encoded. ETL framework uses open source implementation of the Base64 encoding.
    
    Specified by:
    
    isEncoded in interface Block
    
    Returns:
    
    true, if encoded
  - isKeepDataSet
```
public boolean isKeepDataSet()
```
    Checks if destination should keep data set if it is already exists (default is false).
    
    Returns:
    
    true, if destination should keep data set if it is already exists
  - isMetricsEnabled
```
public boolean isMetricsEnabled()
```
    Description copied from interface: Block
    
    Checks if capturing metrics enabled.
    
    Specified by:
    
    isMetricsEnabled in interface Block
    
    Returns:
    
    true, if is metrics enabled
  - isNoReader
```
public boolean isNoReader()
```
    Checks if destination should have no reader.
    
    Returns:
    
    true, if destination should have no reader
  - isNoWriter
```
public boolean isNoWriter()
```
    Checks if destination should have no writer.
    
    Returns:
    
    true, if destination should have no writer
  - isParallel
```
public boolean isParallel()
```
    Description copied from interface: Block
    
    Checks if code for the particular scenario block can be executed in the separate thread.
    
    Specified by:
    
    isParallel in interface Block
    
    Returns:
    
    true, if is parallel
  - isProcOrFunc
```
public boolean isProcOrFunc()
```
    Checks if is destination is a stored procedure or function.
    
    Returns:
    
    true, if destination is a stored procedure or function
  - isStream
```
public boolean isStream()
```
    Checks if data should be streamed from the source to the destination. If true the memory will be allocated only for the current row.
    
    Returns:
    
    true, if data should be streamed from the source to the destination.
  - isUsedByOtherDestination
```
public boolean isUsedByOtherDestination()
```
    Checks if this destination is used by other destination.
    
    Returns:
    
    true, if is used by other destination
  - noConnection
```
public boolean noConnection()
```
    Description copied from interface: Block
    
    Check if no database connection should be associated with the block.
    
    Specified by:
    
    noConnection in interface Block
    
    Returns:
    
    true, if successful
  - removeDataSetChangeListener
```
public void removeDataSetChangeListener(DataSetChangeListener dataSetChangeListener)
```
    Removes the data set change listener.
    
    Parameters:
    
    dataSetChangeListener - the data set change listener
  - resetBatchCounter
```
public void resetBatchCounter()
```
    Reset batch counter.
  - setAfter
```
public void setAfter(String value)
```
    Sets the block of code which is executed after all auto generated and conditional blocks of the destination.
    Example of the "after":
    <destination>
    
    <name>test</name>
    
    <load>
    
    <condition>(v_NAME IS NOT NULL and v_count = 0)</condition>
    
    <after>v_CUSTOMER_NUM:= 1;
    
    </after>
    
    </load>
    
    </destination>
    
    Parameters:
    
    value - The new block of code which is executed after all auto generated and conditional blocks of the destination
  - setBatchWindow
```
public void setBatchWindow(int value)
```
    Sets the batch window.
    
    Parameters:
    
    value - the new batch window
  - setBeforeEtlTasks
```
public void setBeforeEtlTasks(ListHashMap<String,Task> value)
```
    Description copied from interface: Block
    
    Sets the tasks which are executed before etl framework starts processing the DataSet object associated with the particular scenario block but after initializing is done. For example after metadata are collected. Tasks get instantiated by parsing scenario file.
    
    Specified by:
    
    setBeforeEtlTasks in interface Block
    
    Parameters:
    
    value - the new before etl tasks
  - setBlockType
```
public void setBlockType(Block.BlockType value)
```
    Sets the block type.
    
    Parameters:
    
    value - the new block type
  - setCache
```
public void setCache(Cache<String,Object> value)
```
    Sets the cache associated with the destination.
    
    Parameters:
    
    value - The new cache
  - setCondition
```
public void setCondition(String value)
```
    Sets the condition, usually sql, executed before the code for the destination.
    Example of the condition. In this example auto generated code for the destination, most probably "insert into some table" will be executed only if condition v_NAME IS NOT NULL and v_count = 0 applies:
    
    <destination>
    
    <name>test</name>
    
    <load>
    
    <condition>(v_NAME IS NOT NULL and v_count = 0)</condition>
    
    </load>
    
    </destination>
    
    Parameters:
    
    value - the new condition
  - setConnection
```
public void setConnection(Connection value)
```
    Description copied from interface: Block
    
    Sets the actual JDBC connection associated with the scenario block.
    
    Specified by:
    
    setConnection in interface Block
    
    Parameters:
    
    value - the new connection
  - setConnectionName
```
public void setConnectionName(String value)
```
    Description copied from interface: Block
    
    Sets the name of the connection associated with the scenario block.
    
    Specified by:
    
    setConnectionName in interface Block
    
    Parameters:
    
    value - the new name of the connection
  - setCreateIndexes
```
public void setCreateIndexes(boolean value)
```
    Sets the value of the "create indexes when creating a table from the source" flag.
    
    Parameters:
    
    value - the new value of the "create indexes when creating a table from the source" flag
  - setCursorSql
```
public void setCursorSql(String value)
```
    Sets the cursor sql.
    
    Parameters:
    
    value - the new cursor sql
  - setCursorTableName
```
public void setCursorTableName(String value)
```
    Sets the name of the source table for the cursor.
    Example of the setting of the name of the source table at the destination level in the scenario file:
    
    <destination>
    
    <name>test</name>
    
    <sourcetable name="tmp_table" onfinish="keep" />
    
    </destination>
    
    Parameters:
    
    value - The new name of the source table
  - setCursorTableType
```
public void setCursorTableType(String value)
```
    Sets the type of the source table for the cursor.
    Example of the setting the type of the source table in the scenario file:
    
    <destination>
    
    <name>test</name>
    
    <sourcetable name="tmp_table" onfinish="delete" type= "regular" />
    
    </destination>
    
    Parameters:
    
    value - The new type of the source table
  - setDataReaderClassName
```
public void setDataReaderClassName(String value)
```
    Sets the class name of the data reader. Data reader must implement DataSetConnector interface.
    Example of the DataReader at the destination level:
    
    <destination>
    
    <name>test</name>
    
    <load>
    
    <reader>com.toolsverse.etl.connector.text.TextConnector</reader>
    
    </load>
    
    </destination>
    
    Parameters:
    
    value - The new class name of the data reader.
  - setDataReaderParams
```
public void setDataReaderParams(Map<String,String> value)
```
    Sets the data reader params.
    
    Parameters:
    
    value - the value
  - setDataSet
```
public void setDataSet(DataSet value,
                       boolean adjust)
```
    Description copied from interface: Block
    
    Sets the DataSet object associated with the scenario block.
    
    Specified by:
    
    setDataSet in interface Block
    
    Parameters:
    
    value - the new data set
    
    adjust - if true adjust data set fields
  - setDataWriterClassName
```
public void setDataWriterClassName(String value)
```
    Sets the data writer class name. Data writer must implement DataSetConnector interface.
    
    Parameters:
    
    value - the new data writer class name
  - setDataWriterParams
```
public void setDataWriterParams(Map<String,String> value)
```
    Sets the data writer params.
    
    Parameters:
    
    value - the value
  - setDestination
```
public void setDestination(Destination value)
```
    Sets the destination, linked to the destination. Usually it is done by referencing destination by name. *
    Example:
    <destination>
    
    <name>test</name>
    
    <source>linked_destination</source>
    
    </destination>
    
    Parameters:
    
    value - The new source
  - setDriverClassName
```
public void setDriverClassName(String value)
```
    Sets the class name of the driver. Driver is used to generate database specific SQL.
    Example:
    
    <destination>
    
    <name>image</name>
    
    <source>image</source>
    
    <load>
    
    <driver>com.toolsverse.etl.driver.sqlserver.MsSqlDriver</driver>
    
    </load>
    
    </destination>
    
    Specified by:
    
    setDriverClassName in interface Block
    
    Parameters:
    
    value - The new class name of the driver
  - setElse
```
public void setElse(String value)
```
    Sets the block of code which is executed after "else" in the if something then then_code else else_code end if;
    Example of the "else". In this example if condition v_NAME IS NOT NULL and v_count = 0 does not applie the code v_CUSTOMER_NUM:= 1; will be executed.
    
    <destination>
    
    <name>test</name>
    
    <load>
    
    <condition>(v_NAME IS NOT NULL and v_count = 0)</condition>
    
    <else>v_CUSTOMER_NUM:= 1;
    
    </else>
    
    </load>
    
    </destination>
    
    Parameters:
    
    value - The new block of code which is executed after "else"
  - setEnabled
```
public void setEnabled(boolean value)
```
    Description copied from interface: Block
    
    Sets the enabled property of the scenario block. The default value is true.
    Example of the manually set enabled flag in the scenario file:
    
    <source enabled="No">
    
    <name>test</name>
    
    <extract>
    
    <sql>select * from test</sql>
    
    </extract>
    
    </source>
    
    Specified by:
    
    setEnabled in interface Block
    
    Parameters:
    
    value - the new enabled
  - setEncoded
```
public void setEncoded(boolean value)
```
    Description copied from interface: Block
    
    Sets the encoded flag for the DataSet object associated with the scenario block. By default all DataSet objects which contain Clob or Blob fields are encoded and compressed using zip algorithm.
    Example of the manually set encoded flag in the scenario file:
    
    <source encode="No">
    
    <name>clobs</name>
    
    <extract>
    
    <sql>select * from clobs</sql>
    
    </extract>
    
    </source>
    
    Specified by:
    
    setEncoded in interface Block
    
    Parameters:
    
    value - the new encoded
  - setHighWatermarkField
```
public void setHighWatermarkField(String highWatermarkField)
```
    Sets the high watermark field.
    
    Parameters:
    
    highWatermarkField - the new high watermark field
  - setIndexSuffix
```
public void setIndexSuffix(String value)
```
    Sets the index suffix. It will be added to the index name when index is created from the source.
    
    Parameters:
    
    value - the new index suffix
  - setInlineTasks
```
public void setInlineTasks(ListHashMap<String,Task> value)
```
    Description copied from interface: Block
    
    Sets the tasks which are executed for each row of the DataSet object associated with the scenario block. Inline tasks get instantiated by parsing scenario file.
    Example of the inline task in the scenario file:
    
    <tasks>
    
    <task>
    
    <name>replace</name>
    
    Specified by:
    
    setInlineTasks in interface Block
    
    Parameters:
    
    value - the value <class>com.toolsverse.etl.core.task.common.RegexpTransformator</class>
    
    <variables>
    
    <FIELD value="DESCRIPTION" />
    
    <REGEXP value="Substitution" />
    
    <REPLACE value="something" />
    
    </variables>
    
    </task>
    
    </tasks>
  - setIsEmpty
```
public void setIsEmpty(boolean value)
```
    Description copied from interface: Block
    
    Sets the state of the field isEmpty for the scenario block regardless of the actual state of the DataSet object. In the majority of cases etl framework can automatically set this flag however it doesn't hurt to do it manually.
    Example of the always empty scenario block in the scenario file:
    
    <source empty="Yes">
    
    <name>init</name>
    
    <extract>
    
    <tasks>
    
    <task>
    
    <name>prepare</name>
    
    <class>com.toolsverse.etl.core.task.sql.SqlTask</class>
    
    <sql>drop table tmp_cp</sql>
    
    <onexception action="ignore"/>
    
    </task>
    
    </tasks>
    
    </extract>
    
    </source>
    
    Specified by:
    
    setIsEmpty in interface Block
    
    Parameters:
    
    value - the new isEmpty
  - setKeepDataSet
```
public void setKeepDataSet(boolean value)
```
    Sets the "is keep data set" flag.
    
    Parameters:
    
    value - the new value of the "keep data set" flag
  - setLoadAction
```
public void setLoadAction(String value)
```
    Sets the load action. Possible action: LOAD_INSERT, LOAD_UPDATE, LOAD_DELETE, LOAD_MERGE, LOAD_NOTHING
    
    Parameters:
    
    value - the new load action
  - setLoadActionCond
```
public void setLoadActionCond(String value)
```
    Sets the load action evaluation conditions.
    
    Parameters:
    
    value - the new load action evaluation conditions
  - getLowerCaseLoadActionCond
```
public String getLowerCaseLoadActionCond()
```
    Gets the lower case load action conditions.
    
    Returns:
    
    the lower case load action conditions
  - setLoadActionLang
```
public void setLoadActionLang(String value)
```
    Sets the load action evaluation language. Null = javaScript
    
    Parameters:
    
    value - the new load action evaluation language
  - setLoadKey
```
public void setLoadKey(String value)
```
    Sets the load key.
    
    Parameters:
    
    value - the new load key
  - setLocation
```
public void setLocation(boolean doSet,
                        String key,
                        org.w3c.dom.Node treesNode)
```
    Description copied from interface: Block
    
    Set the location for the artifacts such as tasks, variables, etc.
    
    Specified by:
    
    setLocation in interface Block
    
    Parameters:
    
    doSet - if false do not add location info for the artifact
    
    key - the artifact type
    
    treesNode - the DOM node which holds location information
  - setLocation
```
public void setLocation(boolean doSet,
                        String key,
                        TypedKeyValue<Point,Point> location)
```
    Description copied from interface: Block
    
    Set the location for the artifacts such as tasks, variables, etc.
    
    Specified by:
    
    setLocation in interface Block
    
    Parameters:
    
    doSet - if false do not add location info for the artifact
    
    key - the artifact type
    
    location - the location
  - setMetaData
```
public void setMetaData(Map<String,FieldDef> value)
```
    Sets the meta data.
    
    Parameters:
    
    value - the value
  - setMetadataExtractorClass
```
public void setMetadataExtractorClass(String value)
```
    Sets the metadata extractor class name.
    Example:
    
    <destination>
    
    <name>test</name>
    
    <metadata class= "com.toolsverse.etl.metadata.GenericMetadataExtractor" />
    
    </destination>
    
    Parameters:
    
    value - The new metadata extractor class
  - setName
```
public void setName(String value)
```
    Description copied from class: OnException
    
    Sets the name.
    
    Specified by:
    
    setName in interface Block
    
    Overrides:
    
    setName in class OnException
    
    Parameters:
    
    value - the new name
  - setNoConnection
```
public void setNoConnection(boolean value)
```
    Sets the "no connection" flag. If true no connection will be created for the destination.
    
    Parameters:
    
    value - the new "no connection" flag
  - setNoReader
```
public void setNoReader(boolean value)
```
    Sets the "no reader" flag.
    
    Parameters:
    
    value - the new value of the "no reader" flag
  - setNoWriter
```
public void setNoWriter(boolean value)
```
    Sets the "no writer" flag.
    
    Parameters:
    
    value - the new value of the "no writer" flag
  - setObjectName
```
public void setObjectName(String value)
```
    Sets the name of the object.
    Example of the objectname at the destination level in the scenario file:
    
    <destination>
    
    <name>test</name>
    
    <objectname>CLIENT</objectname>
    
    </destination>
    
    Parameters:
    
    value - The new name of the object
  - setOnExceptionTasks
```
public void setOnExceptionTasks(ListHashMap<String,Task> value)
```
    Description copied from interface: Block
    
    Sets the tasks which are executed when there is an exception during processing of the etl block. On exception tasks get instantiated by parsing scenario file.
    Example of the post task in the scenario file:
    
    <tasks>
    
    <task scope="onexception">
    
    <name>delete</name>
    
    <class>com.toolsverse.etl.core.task.common.FileManagerTask</class>
    
    <variables>
    
    <COMMAND value="delete" />
    
    <SOURCE_TYPE value="file" />
    
    <FILES value="*.dat" />
    
    </variables>
    
    </task>
    
    </tasks>
    
    Specified by:
    
    setOnExceptionTasks in interface Block
    
    Parameters:
    
    value - the new post tasks
  - setOnFinish
```
public void setOnFinish(int value)
```
    Sets the type of action on finish (when etl process finished processing destination). Possible actions are: ON_FINISH_KEEP, ON_FINISH_DROP. The default action is ON_FINISH_DROP.
    Example of the setting of the type of action on finish in the scenario file:
    
    <destination>
    
    <name>test</name>
    
    <sourcetable name="tmp_table" onfinish="delete" />
    
    </destination>
    
    Parameters:
    
    value - The new type of action on finish
  - setOnFinish
```
public void setOnFinish(String action)
```
    Sets the the type of action on finish based on string value.
    
    Parameters:
    
    action - The new type of action on finish
  - setOwnerName
```
public void setOwnerName(String value)
```
    Sets the owner name.
    
    Parameters:
    
    value - the new owner name
  - setParallel
```
public void setParallel(boolean value)
```
    Description copied from interface: Block
    
    Sets the the property isParallel for the scenario block. If set to true the code for this block can be executed in the separate thread. The default value is false.
    Example of the parallel scenario block in the scenario file:
    
    <source parallel="Yes">
    
    <name>test</name>
    
    <extract>
    
    <sql>select * from test</sql>
    
    </extract>
    
    </source>
    
    Specified by:
    
    setParallel in interface Block
    
    Parameters:
    
    value - the new parallel
  - setPostTasks
```
public void setPostTasks(ListHashMap<String,Task> value)
```
    Description copied from interface: Block
    
    Sets the tasks which are executed after etl framework finished with the processing of the particular scenario block. Post tasks get instantiated by parsing scenario file.
    Example of the post task in the scenario file:
    
    <tasks>
    
    <task scope="after">
    
    <name>delete</name>
    
    <class>com.toolsverse.etl.core.task.common.FileManagerTask</class>
    
    <variables>
    
    <COMMAND value="delete" />
    
    <SOURCE_TYPE value="file" />
    
    <FILES value="*.dat" />
    
    </variables>
    
    </task>
    
    </tasks>
    
    Specified by:
    
    setPostTasks in interface Block
    
    Parameters:
    
    value - the new post tasks
  - setScenarioVariables
```
public void setScenarioVariables(ListHashMap<String,Variable> value)
```
    Sets the variables which belongs to the scenario.
    Example of the scenario variables:
    
    <scenario>
    
    <name>test</name>
    
    <variables>
    
    <CUSTOMER value="test1" />
    
    <PRODUCT value="test2" />
    
    </variables>
    
    Parameters:
    
    value - The new scenario variables
  - setScope
```
public void setScope(String value)
```
    Sets the scope. Possible values: SCOPE_GLOBAL - code for the destination will be included in the code for the scenario, SCOPE_SINGLE - code for the destination will be executed separatelly.
    
    Parameters:
    
    value - the new scope
  - setSource
```
public void setSource(Source value)
```
    Sets the source, linked to the destination. Usually it is done by referencing source by name. By default the etl framework is trying to find source with the same name as destination.
    Example:
    <destination>
    
    <name>test</name>
    
    <source>test_source</source>
    
    </destination>
    
    Parameters:
    
    value - The new source
  - setSourceName
```
public void setSourceName(String value)
```
    Sets the name of the source.
    
    Parameters:
    
    value - the new name of the source
  - setSql
```
public void setSql(String value)
```
    Sets the sql for the load.
    Example:
    <destination>
    
    <name>test</name>
    
    <load>
    
    <sql>insert into table1 (field1, field2) values({VAR1}, {VAR2});
    
    </sql>
    
    </load>
    
    </destination>
    
    Parameters:
    
    value - The new sql
  - setStream
```
public void setStream(boolean value)
```
    Sets the "stream" flag. If true the data from the source to the destination will be streamed.
    
    Parameters:
    
    value - the new "stream" flag
  - setTasks
```
public void setTasks(ListHashMap<String,Task> value)
```
    Description copied from interface: Block
    
    Sets the tasks which are executed before etl framework starts processing of the particular scenario block. Tasks get instantiated by parsing scenario file.
    Example of the task in the scenario file:
    
    <tasks>
    
    <task>
    
    <name>copy</name>
    
    <connection>dest</connection>
    
    <class>com.toolsverse.etl.core.task.oracle.OracleCopyTask</class>
    
    <sql>
    
    insert temp USING
    
    select * from some_table
    
    </sql>
    
    </task>
    
    </tasks>
    
    Specified by:
    
    setTasks in interface Block
    
    Parameters:
    
    value - the new tasks
  - setThen
```
public void setThen(String value)
```
    Sets the block of code which is executed after "then" in the if something then then_code else else_code end if; It is important to understand that the auto generated code, for example "insert into" will be executed in the same block as "then".
    Example of the "then". In this example if condition v_NAME IS NOT NULL and v_count = 0 applies the code which starts from EXECUTE IMMEDIATE will be executed.
    
    <destination>
    
    <name>test</name>
    
    <load>
    
    <condition>(v_NAME IS NOT NULL and v_count = 0)</condition>
    
    <then>EXECUTE IMMEDIATE 'insert into primary_keys_table (field_name, pk, old_pk) values(''CUSTOMER_NUM'',:C_NUM, :CUSTOMER_NUM)'
    
    USING v_C_NUM, v_CUSTOMER_NUM;
    
    v_CUSTOMER_NUM:= v_C_NUM;
    
    </then>
    
    </load>
    
    </destination>
    
    Parameters:
    
    value - The new block of code executed after "then"
  - setType
```
public void setType(String value)
```
    Sets the type of the destination.
    Example of destination with the FUNCTION type in the scenario file:
    
    <destination>
    
    <name>test</name>
    
    <driver>com.toolsverse.etl.driver.sqlserver.MsSqlDriver</driver>
    
    <sql>
    
    CREATE FUNCTION convert_value(@value VARCHAR(3000)) RETURNS VARCHAR(3000)
    AS
    BEGIN
    return @value;
    END;
    </sql>
    
    </destination>
    
    Parameters:
    
    value - The new type
  - setUseBindVars
```
public void setUseBindVars(boolean value)
```
    Sets the "use bind vars" flag.
    
    Parameters:
    
    value - the new "use bind vars" value
  - setUsedByOtherDestination
```
public void setUsedByOtherDestination(boolean value)
```
    Sets the "used by other destination" flag.
    
    Parameters:
    
    value - the new value for the "used by other destination" flag
  - setUseMetadataDataTypes
```
public void setUseMetadataDataTypes(boolean value)
```
    Sets the "use the metadata data types" flag.
    
    Parameters:
    
    value - The new value for the "use metadata data types" flag
  - setVariables
```
public void setVariables(ListHashMap<String,Variable> value)
```
    Description copied from interface: Block
    
    Sets the variables for the block. Variables get instantiated by parsing scenario file.
    Example of the variables in the scenario file:
    
    <variables>
    
    <STEP_NUM function="getPk" />
    
    <CONFIG_NUM function="getFk" />
    
    <USER function="getUser" />
    
    <ID include="No" />
    
    </variables>
    
    Specified by:
    
    setVariables in interface Block
    
    Parameters:
    
    value - The new variables
  - updateFields
```
public List<FieldDef> updateFields(Driver driver,
                                   boolean add)
```
    Updates fields visibility based on variable.isInclude() flag. Also sets sql and native data types if variable attributes Variable.NATIVE_TYPE_ATTR or Variable.SQL_TYPE_ATTR are set. If field is not visible it will not be included into the insert/update/merge actions.
    
    Parameters:
    
    driver - the driver
    
    add - if true add fields from variables
    
    Returns:
    
    the list of added fields
  - useBindVars
```
public boolean useBindVars()
```
    If true framework will try to use bind variables on insert/update/delete.
    
    Returns:
    
    true, if framework should try to use bind variables
  - isEnableChangeReplication
```
public boolean isEnableChangeReplication()
```
    Checks if change replication is enabled. Works together with highWatermark.
    
    Returns:
    
    true, if change replication is enabled
  - setEnableChangeReplication
```
public void setEnableChangeReplication(boolean enableChangeReplication)
```
    Sets the "enable change replication" flag.
    
    Parameters:
    
    enableChangeReplication - the new value for the "enable change replication" flag.
  - getOriginalName
```
public String getOriginalName()
```
    Description copied from interface: Block
    
    Gets the original block name. The actual name is typically uppercased
    
    Specified by:
    
    getOriginalName in interface Block
    
    Returns:
    
    the original block name
  - setOriginalName
```
public void setOriginalName(String name)
```
    Description copied from interface: Block
    
    Sets the original block name. The actual name is typically uppercased.
    
    Specified by:
    
    setOriginalName in interface Block
    
    Parameters:
    
    name - String the new original name
  - getHighWatermarkFieldValue
```
public Object getHighWatermarkFieldValue()
```
    Gets the high watermark field value.
    
    Returns:
    
    the high watermark field value
  - setHighWatermarkFieldValue
```
public void setHighWatermarkFieldValue(Object highWatermarkFieldValue)
```
    Sets the high watermark field value.
    
    Parameters:
    
    highWatermarkFieldValue - the new high watermark field value
  - getHighWatermarkFieldValueOnStart
```
public Object getHighWatermarkFieldValueOnStart()
```
    Gets the high watermark field value on start.
    
    Returns:
    
    the high watermark field value on start
  - setHighWatermarkFieldValueOnStart
```
public void setHighWatermarkFieldValueOnStart(Object highWatermarkFieldValueOnStart)
```
    Sets the high watermark field value on start.
    
    Parameters:
    
    highWatermarkFieldValueOnStart - the new high watermark field value on start
  - getActualConnectionName
```
public String getActualConnectionName()
```
    Gets the actual connection name. The actual connection name is used when the transformation has a final destination, which is different from the transformation itself, for example Snowflake.
    
    Returns:
    
    the actual connection name
  - setActualConnectionName
```
public void setActualConnectionName(String actualConnectionName)
```
    Sets the actual connection name.
    
    Parameters:
    
    actualConnectionName - the new actual connection name
  - getActualBatchWindow
```
public int getActualBatchWindow()
```
    Gets the actual batch window.
    
    Returns:
    
    the actual batch window
  - setActualBatchWindow
```
public void setActualBatchWindow(int actualBatchWindow)
```
    Sets the actual batch window.
    
    Parameters:
    
    actualBatchWindow - the new actual batch window
  - getActualLoadAction
```
public String getActualLoadAction()
```
    Gets the actual load action.
    
    Returns:
    
    the actual load action
  - setActualLoadAction
```
public void setActualLoadAction(String actualLoadAction)
```
    Sets the actual load action.
    
    Parameters:
    
    actualLoadAction - the new actual load action
  - getHwmSqlExceptionToIgnore
```
public String getHwmSqlExceptionToIgnore()
```
    Gets the hwm sql Exception to ignore.
    
    Returns:
    
    the hwm sql Exception to ignore
  - setHwmSqlExceptionToIgnore
```
public void setHwmSqlExceptionToIgnore(String hwmSqlExceptionToIgnore)
```
    Sets the hwm sql exception to ignore.
    
    Parameters:
    
    hwmSqlExceptionToIgnore - the new hwm sql exception to ignore
  - getTarget
```
public String getTarget()
```
    Gets the target.
    
    Returns:
    
    the target
  - setTarget
```
public void setTarget(String target)
```
    Sets the target.
    
    Parameters:
    
    target - the new target
  - getTargetDriver
```
public String getTargetDriver()
```
    Gets the target driver.
    
    Returns:
    
    the target driver
  - setTargetDriver
```
public void setTargetDriver(String targetDriver)
```
    Sets the target driver.
    
    Parameters:
    
    targetDriver - the new target driver
  - isMetadataSource
```
public boolean isMetadataSource()
```
    Checks if is metadata source.
    
    Returns:
    
    true, if is metadata source
  - setMetadataSource
```
public void setMetadataSource(boolean metadataSource)
```
    Sets the metadata source.
    
    Parameters:
    
    metadataSource - the new metadata source
  - isMetadataDest
```
public boolean isMetadataDest()
```
    Checks if is metadata dest.
    
    Returns:
    
    true, if is metadata dest
  - setMetadataDest
```
public void setMetadataDest(boolean metadataDest)
```
    Sets the metadata dest.
    
    Parameters:
    
    metadataDest - the new metadata dest
  - getCalculatedTableName
```
public String getCalculatedTableName()
```
    Gets the calculated table name.
    
    Returns:
    
    the calculated table name
  - setCalculatedTableName
```
public void setCalculatedTableName(String calculatedTableName)
```
    Sets the calculated table name.
    
    Parameters:
    
    calculatedTableName - the new calculated table name
  - getIdForException
```
public String getIdForException()
```
    Description copied from class: ConditionalExecution
    
    Gets the id for exception.
    
    Specified by:
    
    getIdForException in class ConditionalExecution
    
    Returns:
    
    the id for exception
  - isLoadKeySet
```
public boolean isLoadKeySet()
```
    Checks if is load key set.
    
    Returns:
    
    true, if is load key set
  - setLoadKeySet
```
public void setLoadKeySet(boolean loadKeySet)
```
    Sets the load key set.
    
    Parameters:
    
    loadKeySet - the new load key set
  - isAutoSelectLoadKey
```
public boolean isAutoSelectLoadKey()
```
    Checks if is auto select load key.
    
    Returns:
    
    true, if is auto select load key
  - setAutoSelectLoadKey
```
public void setAutoSelectLoadKey(boolean autoSelectLoadKey)
```
    Sets the auto select load key.
    
    Parameters:
    
    autoSelectLoadKey - the new auto select load key
  - needToPopulateLoadKey
```
public boolean needToPopulateLoadKey()
```
    Checks if load key needs to be populated.
    
    Returns:
    
    true, if load key needs to be populated
  - isReCreate
```
public boolean isReCreate()
```
    Checks if the destination table must be re-created.
    
    Returns:
    
    true, if the destination table must be re-created.
  - setReCreate
```
public void setReCreate(boolean reCreate)
```
    Sets the flag which controls if the destination table must be re-created.
    
    Parameters:
    
    reCreate - boolean
  - isMetadataCreate
```
public boolean isMetadataCreate()
```
    Checks if etl process should check if the destination table should be re-created.
    
    Returns:
    
    true, if etl process should check if the destination table should be re-created
  - setMetadataCreate
```
public void setMetadataCreate(boolean metadataCreate)
```
    Sets the flag which controls if the etl process should check if the destination table should be re-created
    
    Parameters:
    
    metadataCreate - boolean
  - isMetadataAlter
```
public boolean isMetadataAlter()
```
    Checks if etl process should check if the destination table should be altered.
    
    Returns:
    
    true, if etl process should check if the destination table should be altered
  - setMetadataAlter
```
public void setMetadataAlter(boolean metadataAlter)
```
    Sets the flag which controls if the etl process should check if the destination table should be altered
    
    Parameters:
    
    metadataAlter - boolean
  - isAlter
```
public boolean isAlter()
```
    Checks if the destination table must be altered.
    
    Returns:
    
    true, if the destination table must be altered.
  - setAlter
```
public void setAlter(boolean alter)
```
    Sets the flag which controls if the destination table must be altered.
    
    Parameters:
    
    alter - boolean
  - getMissingFields
```
public List<String> getMissingFields()
```
    Gets the fields missing in destination.
    
    Returns:
    
    the missing fields
  - setMissingFields
```
public void setMissingFields(List<String> missingFields)
```
    Sets the fields missing in destination.
    
    Parameters:
    
    missingFields - the new missing fields
  - isMetadataOrder
```
public boolean isMetadataOrder()
```
    Checks if is metadata order.
    
    Returns:
    
    true, if is metadata order
  - setMetadataOrder
```
public void setMetadataOrder(boolean metadataOrder)
```
    Sets the metadata order.
    
    Parameters:
    
    metadataOrder - the new metadata order
  - getLoadKeys
```
public LinkedCaseInsensitiveMap<String> getLoadKeys()
```
    Gets the load keys.
    
    Returns:
    
    the load keys
  - getThreadGroupName
```
public String getThreadGroupName()
```
    Gets the thread group name.
    
    Returns:
    
    the thread group name
  - setThreadGroupName
```
public void setThreadGroupName(String threadGroupName)
```
    Sets the thread group name.
    
    Parameters:
    
    threadGroupName - the new thread group name
  - isGroupThreads
```
public boolean isGroupThreads()
```
    Returns the flag which enables grouping destinations with the same threadGroupName.
    
    Returns:
    
    true if the flag is enabled
  - setGroupThreads
```
public void setGroupThreads(boolean groupThreads)
```
    Sets the flag which enables grouping destinations with the same threadGroupName
    
    Parameters:
    
    groupThreads - the new value of the flag
  - getHighWatermarkCode
```
public String getHighWatermarkCode()
```
    Gets the high watermark code.
    
    Returns:
    
    the high watermark code
  - setHighWatermarkCode
```
public void setHighWatermarkCode(String highWatermarkCode)
```
    Sets the high watermark code.
    
    Parameters:
    
    highWatermarkCode - the new high watermark code
  - isNewConnection
```
public boolean isNewConnection()
```
    Checks if new destination connection should be created for each transformation.
    
    Returns:
    
    true, if new destination connection should be created for each transformation
  - setNewConnection
```
public void setNewConnection(boolean newConnection)
```
    Sets the "new connection" flag.
    
    Parameters:
    
    newConnection - boolean
  - isLoadActionSkipDeletesWithMerge
```
public boolean isLoadActionSkipDeletesWithMerge()
```
    Checks if is load should skip deletes with cdc merge.
    
    Returns:
    
    true, if the load should skip deletes with cdc merge
  - setLoadActionSkipDeletesWithMerge
```
public void setLoadActionSkipDeletesWithMerge(boolean loadActionSkipDeletesWithMerge)
```
    Sets the flag which when enabled will trigger skipping the deletes when executing cdc merge action.
    
    Parameters:
    
    loadActionSkipDeletesWithMerge - boolean
  - isTempTable
```
public boolean isTempTable()
```
    Checks if destination is a temp table.
    
    Returns:
    
    true, if destination is a temp table
  - setTempTable
```
public void setTempTable(boolean tempTable)
```
    Sets the "temp table" flag.
    
    Parameters:
    
    tempTable - boolean
  - getCreateTableTemplate
```
public String getCreateTableTemplate()
```
    Gets the creates the table template.
    
    Returns:
    
    the creates the table template
  - setCreateTableTemplate
```
public void setCreateTableTemplate(String createTableTemplate)
```
    Sets the creates the table template.
    
    Parameters:
    
    createTableTemplate - the new creates the table template

Class Destination

Nested Class Summary

Nested classes/interfaces inherited from interface com.toolsverse.etl.core.engine.Block

Field Summary

Fields inherited from class com.toolsverse.etl.common.OnException

Constructor Summary

Method Summary

Methods inherited from class com.toolsverse.etl.common.OnException

Methods inherited from class com.toolsverse.etl.common.ConditionalExecution

Methods inherited from class Object

Field Detail

DEST_ATTR

NAME_ATTR

OBJECT_NAME_ATTR

OWNER_ATTR

SOURCE_ATTR

NO_CONNECTION_ATTR

PARALLEL_ATTR

GROUP_PARALLEL_ATTR

NEW_CONNECTION_ATTR

TEMP_TABLE_ATTR

CREATE_TABLE_TEMPLATE_ATTR

EMPTY_ATTR

ENABLED_ATTR

METRICS_ENABLED_ATTR

ENCODE_ATTR

TYPE_ATTR

SCOPE_ATTR

AS_SOURCE_ATTR

METADATA_ATTR

METADATA_TYPES_ATTR

METADATA_INDEXES_ATTR

METADATA_SOURCE_ATTR

METADATA_DEST_ATTR

METADATA_CREATE_ATTR

METADATA_ALTER_ATTR

METADATA_ORDER_ATTR

METADATA_SUFFIX_ATTR

CURSOR_NAME_ATTR

CURSOR_TABLE_ATTR

CURSOR_SQL_ATTR

CURSOR_TABLE_TYPE_ATTR

CURSOR_ON_FINISH_ATTR

STREAM_ATTR

LOAD_ACTION_ATTR

LOAD_ACTION_KEY_ATTR

LOAD_KEY_AUTOSELECT_ATTR

LOAD_SKIP_DELETE_WITH_MERGE_ATTR

LOAD_ACTION_LANG

LOAD_ACTION_COND

USE_BIND_VARS_ATTR

BATCH_WINDOW_ATTR

HIGH_WATERMARK_ATTR

HIGH_WATERMARK_CODE_ATTR

HIGH_WATERMARK_VALUE_ATTR

HIGH_WATERMARK_START_VALUE_ATTR

HIGH_WATERMARK_EXCEPTION_TO_IGNORE_ATTR

REPLICATION_ATTR

ETL_DRIVER_ATTR

PARENT_ETL_DRIVER_ATTR

ETL_DRIVER_CASE_ATTR

DEST_CONNECTION_NAME_ATTR

ACTUAL_CONNECTION_NAME_ATTR

TARGET_ATTR

TARGET_DRIVER_ATTR

SQL_ATTR

ON_EXCEPTION_ACTION_ATTR

ON_EXCEPTION_MASK_ATTR

ON_EXCEPTION_SAVE_POINT_ATTR

IF_COND_ATTR

IF_THEN_ATTR

IF_ELSE_ATTR

IF_AFTER_ATTR

COND_lANG_ATTR

COND_CONNECTION_ATTR

CONDITION_ATTR

READER_ATTR

WRITER_ATTR

SCOPE_GLOBAL

SCOPE_SINGLE