Package org.jumpmind.symmetric.db.db2

Class Db2As400TriggerTemplate

java.lang.Object

org.jumpmind.symmetric.db.AbstractTriggerTemplate

org.jumpmind.symmetric.db.db2.Db2TriggerTemplate

org.jumpmind.symmetric.db.db2.Db2As400TriggerTemplate

public class Db2As400TriggerTemplate
extends Db2TriggerTemplate

Nested Class Summary

Nested classes/interfaces inherited from class org.jumpmind.symmetric.db.AbstractTriggerTemplate

AbstractTriggerTemplate.ColumnString

Field Summary

Fields inherited from class org.jumpmind.symmetric.db.AbstractTriggerTemplate

arrayColumnTemplate, binaryColumnTemplate, blobColumnTemplate, booleanColumnTemplate, clobColumnTemplate, dateColumnTemplate, datetimeColumnTemplate, dateTimeWithLocalTimeZoneColumnTemplate, dateTimeWithTimeZoneColumnTemplate, emptyColumnTemplate, geographyColumnTemplate, geometryColumnTemplate, hashedValue, imageColumnTemplate, log, longColumnTemplate, moneyColumnTemplate, newColumnPrefix, newTriggerValue, numberColumnTemplate, oldColumnPrefix, oldTriggerValue, ORIG_TABLE_ALIAS, otherColumnTemplate, sqlTemplates, stringColumnTemplate, symmetricDialect, timeColumnTemplate, triggerConcatCharacter, wrappedBlobColumnTemplate, xmlColumnTemplate

Constructor Summary

Constructors

Constructor	Description
Db2As400TriggerTemplate(ISymmetricDialect symmetricDialect)

Method Summary

Modifier and Type	Method	Description
String	createInitalLoadSql(Node node, TriggerRouter triggerRouter, Table originalTable, TriggerHistory triggerHistory, Channel channel, String overrideSelectSql)
boolean	useTriggerTemplateForColumnTemplatesDuringInitialLoad()	When ParameterConstants.INITIAL_LOAD_CONCAT_CSV_IN_SQL_ENABLED is false most dialects are going to want to still use the trigger templates because they have type translation details (like geometry templates).
protected boolean	useTriggerTemplateForColumnTemplatesDuringInitialLoad(Column column)	When INITIAL_LOAD_USE_COLUMN_TEMPLATES_ENABLED is true, column templates are used for all columns.

Methods inherited from class org.jumpmind.symmetric.db.db2.Db2TriggerTemplate

toClobExpression

Methods inherited from class org.jumpmind.symmetric.db.AbstractTriggerTemplate

adjustColumnTemplate, aliasedPrimaryKeyJoin, aliasedPrimaryKeyJoinVar, buildColumnNameString, buildColumnsString, buildKeyVariablesDeclare, buildKeyVariablesString, buildVirtualTableSql, castDatetimeColumnToString, createCsvDataSql, createCsvPrimaryKeySql, createDdlTrigger, createPostDdlTriggerDDL, createPostTriggerDDL, createTriggerDDL, eval, fillOutColumnTemplate, getBlobColumnTemplate, getChannelExpression, getClobColumnTemplate, getClobType, getColumnPositionUsingTemplate, getColumnSize, getCreateTriggerString, getDateColumnTemplate, getDefaultTargetTableName, getHasPrimaryKeysDefinedString, getImageColumnTemplate, getNewTriggerValue, getOldTriggerValue, getOtherColumnTemplate, getPrimaryKeysUpdatedString, getPrimaryKeyWhereString, getSchemaNameOnly, getSourceTablePrefix, getSourceTablePrefix, getSourceTableSchema, getSourceTableSchema, getTimeColumnTemplate, getWrappedBlobColumnTemplate, isLob, isUniTextColumn, noDateColumnTemplate, noTimeColumnTemplate, replaceDefaultCatalog, replaceDefaultSchema, replaceDefaultSchemaAndCatalog, replaceDefaultSchemaAndCatalog, replaceOracleQueryHint, replaceTemplateVariables, requiresEmptyLobTemplateForDeletes, requiresWrappedBlobTemplateForBlobType, setBooleanColumnTemplate, setDateColumnTemplate, setImageColumnTemplate, setTimeColumnTemplate, toHashedValue

Methods inherited from class java.lang.Object

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

Constructor Details

Db2As400TriggerTemplate

public Db2As400TriggerTemplate(ISymmetricDialect symmetricDialect)

Method Details

useTriggerTemplateForColumnTemplatesDuringInitialLoad

public boolean useTriggerTemplateForColumnTemplatesDuringInitialLoad()

Description copied from class: AbstractTriggerTemplate

When ParameterConstants.INITIAL_LOAD_CONCAT_CSV_IN_SQL_ENABLED is false most dialects are going to want to still use the trigger templates because they have type translation details (like geometry templates). However, some dialects cannot handle the complex SQL generated (Firebird). We needed a way to tell the dialect that we want to select the columns straight up.

Overrides:

useTriggerTemplateForColumnTemplatesDuringInitialLoad in class AbstractTriggerTemplate

useTriggerTemplateForColumnTemplatesDuringInitialLoad

protected boolean useTriggerTemplateForColumnTemplatesDuringInitialLoad(Column column)

Description copied from class: AbstractTriggerTemplate

When INITIAL_LOAD_USE_COLUMN_TEMPLATES_ENABLED is true, column templates are used for all columns. When false, only specific column types have been implemented to format data in code.

Overrides:

useTriggerTemplateForColumnTemplatesDuringInitialLoad in class AbstractTriggerTemplate

createInitalLoadSql

public String createInitalLoadSql(Node node,
 TriggerRouter triggerRouter,
 Table originalTable,
 TriggerHistory triggerHistory,
 Channel channel,
 String overrideSelectSql)

Overrides:

createInitalLoadSql in class AbstractTriggerTemplate