1. Oracle GoldenGate Classic Architecture Documentation
  2. Administer
  3. Data Management
  4. Mapping and Manipulating Data
  5. Testing and Transforming Data
  6. Handling Null, Invalid, and Missing Data
  7. Using @IF

Using @IF

Use the @IF function to return one of two values based on a condition. Use it with the @COLSTAT and @COLTEST functions to begin a conditional argument that tests for one or more exception conditions and then directs processing based on the results of the test. 

NEW_BALANCE = @IF (@COLTEST (BALANCE, NULL, INVALID) OR
@COLTEST (AMOUNT, NULL, INVALID), @COLSTAT (NULL), BALANCE + AMOUNT)

This conversion returns one of the following:

  • NULL when BALANCE or AMOUNT is NULL or INVALID

  • MISSING when either column is missing

  • The sum of the columns.