1. Using Oracle GoldenGate Classic Architecture for Non-Oracle Databases
  2. Using Oracle GoldenGate for NonStop SQL/MX
  3. Understanding What's Supported for NonStop SQL/MX
  4. Supported SQL/MX Data Types

Supported SQL/MX Data Types

The SQL/MX data types supported by Oracle GoldenGate are:

  • CHAR

  • VARCHAR

  • REAL

  • DOUBLE

  • NUMERIC

  • SMALLINT

  • LARGEINT

  • DECIMAL

  • VARCHAR(1)-(4040)

  • FLOAT

  • PIC

  • DATE

  • TIME

  • TIMESTAMP

  • SYSKEY

Limitations of support:

  • The original SYSKEY values are not preserved on the target. The target database generates a new unique value.

  • Oracle GoldenGate does not support negative dates.

  • Oracle GoldenGate supports timestamp data from 0001/01/03:00:00:00 to 9999/12/31:23:59:59. If a timestamp is converted from GMT to local time, these limits also apply to the resulting timestamp. Depending on the time zone, conversion may add or subtract hours, which can cause the timestamp to exceed the lower or upper supported limit.

Parent topic: Understanding What's Supported for NonStop SQL/MX