1. Oracle GoldenGate Classic Architecture Documentation
  2. Administer
  3. Data Management
  4. Mapping and Manipulating Data
  5. Testing and Transforming Data
  6. Using the Appropriate Function

Using the Appropriate Function

Use the appropriate function for the type of column that is being manipulated or evaluated. For example, numeric functions can be used only to compare numeric values. To compare character values, use one of the Oracle GoldenGate character-comparison functions. LOB columns cannot be used in conversion functions.

This statement would fail because it uses @IF, which is a numerical function, to compare string values. 

@IF (SR_AREA = 'Help Desk', 'TRUE', 'FALSE')

The following statement would succeed because it compares a numeric value.

@IF (SR_AREA = 20, 'TRUE', 'FALSE')

See Manipulating Numbers and Character Strings for more information.

Note:

Errors in argument parsing sometimes are not detected until records are processed. Verify syntax before starting processes.