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 @COLTEST

Using @COLTEST

Use the @COLTEST function to check for the following conditions:

  • PRESENT tests whether a column is present and not null.

  • NULL tests whether a column is present and null.

  • MISSING tests whether a column is not present.

  • INVALID tests whether a column is present but contains invalid data.

The following example checks whether the AMOUNT column is present and NULL and whether it is present but invalid. 

@COLTEST (AMOUNT, NULL, INVALID)