com.toolsverse.etl.core.function.informix

Class InformixFunctions

Object

com.toolsverse.etl.core.function.DefFunctions

com.toolsverse.etl.core.function.informix.InformixFunctions

All Implemented Interfaces:

Function

public class InformixFunctions
extends DefFunctions

The Informix specific functions. For example it uses Informix sequence object to get a new value for the primary key. By default used by InformixDriver.

Since:

1.0

Version:

2.0

See Also:

InformixDriver

Field Summary

Fields

Modifier and Type	Field and Description
static String[]	AFTER_FUNCTIONS The AFTER_FUNCTIONS.
static String[]	BEFORE_FUNCTIONS The BEFORE_FUNCTIONS.
static String[]	EXCLUDE_FUNCTIONS The EXCLUDE_FUNCTIONS.

Fields inherited from class com.toolsverse.etl.core.function.DefFunctions

DEFAULT_FUNCTION, SCENARIO_VARIABLE_ATTR, SCRIPT_FUNCTION, START_ATTR

Constructor Summary

Constructors

Constructor and Description
InformixFunctions()

Method Summary

Modifier and Type	Method and Description
String	assignVar(LoadFunctionContext context, String value) Assigns value to variable.
String[]	getAfterFunctions() Gets the array of functions which will be executed after main etl action (insert, update, delete, merge, etc).
String[]	getBeforeFunctions() Gets the array of functions which will be executed before main etl action (insert, update, delete, merge, etc).
String[]	getExcludeFunctions() Gets the array of functions which will be executed to calculate visibility of the field.
String	getFk(LoadFunctionContext context) Gets the new value for the field from the corresponding "primary key" field.
String	getPk(LoadFunctionContext context) Gets the new value for the field using in-memory map or other mechanism, for example db sequence.
String[]	getRuntimeFunctions() Gets the array of functions which will be executed at run time.
String	getSerial(LoadFunctionContext context) Gets the new value for the field using dbinfo('sqlca.sqlerrd1') or dbinfo('serial8').
String	getValue(LoadFunctionContext context) Gets the current field value.

Methods inherited from class com.toolsverse.etl.core.function.DefFunctions

assignVar, getGlobalVarValue, getSeq, getSql, getSqlType, getValueFromRecordOrVar, getVariableValue, getVarSql, getVarSql, script

Methods inherited from class Object

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

Field Detail

BEFORE_FUNCTIONS

public static final String[] BEFORE_FUNCTIONS

The BEFORE_FUNCTIONS.

AFTER_FUNCTIONS

public static final String[] AFTER_FUNCTIONS

The AFTER_FUNCTIONS.

EXCLUDE_FUNCTIONS

public static final String[] EXCLUDE_FUNCTIONS

The EXCLUDE_FUNCTIONS.

Constructor Detail

InformixFunctions

public InformixFunctions()

Method Detail

assignVar

public String assignVar(LoadFunctionContext context,
                        String value)
                 throws Exception

Description copied from class: DefFunctions

Assigns value to variable.

Overrides:

assignVar in class DefFunctions

Parameters:

context - the context

value - the value

Returns:

the string

Throws:

Exception - the exception

getAfterFunctions

public String[] getAfterFunctions()

Description copied from interface: Function

Gets the array of functions which will be executed after main etl action (insert, update, delete, merge, etc).

Specified by:

getAfterFunctions in interface Function

Overrides:

getAfterFunctions in class DefFunctions

Returns:

the array of "after" functions

getBeforeFunctions

public String[] getBeforeFunctions()

Description copied from interface: Function

Gets the array of functions which will be executed before main etl action (insert, update, delete, merge, etc).

Specified by:

getBeforeFunctions in interface Function

Overrides:

getBeforeFunctions in class DefFunctions

Returns:

the array of "before" functions

getExcludeFunctions

public String[] getExcludeFunctions()

Description copied from interface: Function

Gets the array of functions which will be executed to calculate visibility of the field. Can be used to exclude field from the main etl action (insert, update, delete, merge, etc).

Specified by:

getExcludeFunctions in interface Function

Overrides:

getExcludeFunctions in class DefFunctions

Returns:

the array of "exclude" functions

getFk

public String getFk(LoadFunctionContext context)

Description copied from class: DefFunctions

Gets the new value for the field from the corresponding "primary key" field.

Overrides:

getFk in class DefFunctions

Parameters:

context - the context

Returns:

the foreign key

getPk

public String getPk(LoadFunctionContext context)

Description copied from class: DefFunctions

Gets the new value for the field using in-memory map or other mechanism, for example db sequence.

Overrides:

getPk in class DefFunctions

Parameters:

context - the context

Returns:

the primary key

getRuntimeFunctions

public String[] getRuntimeFunctions()

Description copied from interface: Function

Gets the array of functions which will be executed at run time. Use them to calculate field values.

Specified by:

getRuntimeFunctions in interface Function

Overrides:

getRuntimeFunctions in class DefFunctions

Returns:

the array of "runtime" functions

getSerial

public String getSerial(LoadFunctionContext context)
                 throws Exception

Gets the new value for the field using dbinfo('sqlca.sqlerrd1') or dbinfo('serial8').

Parameters:

context - the context

Returns:

the serial

Throws:

Exception - the exception

getValue

public String getValue(LoadFunctionContext context)
                throws Exception

Description copied from class: DefFunctions

Gets the current field value.

Overrides:

getValue in class DefFunctions

Parameters:

context - the context

Returns:

the current field value

Throws:

Exception - in case of any error