OpenEdge CDC - SQL Access - Forum - OpenEdge RDBMS - Progress Community

OpenEdge CDC - SQL Access

 Forum

OpenEdge CDC - SQL Access

This question is not answered

I noticed in the documentation that it says:

"If the user is using the Authorized Data Truncation(ADT) feature or the Autonomus Schema Update(ASU) feature, any applications that work with data returned from SQL queries, will not get complete data. Progress suggests that users should set ADT and ASU to OFF while working with CDC tables."

I would think that you'd want these set to ON so that you don't have to worry about field values exceeding the field format when using SQL to read the CDC records. What happens if I set this to ON (especially ASU)?

All Replies
  • Yes.

    But note that the data replicated may be truncated.

    This is as it should be.

  • Careful: you may want to set ADT to OUTPUT, not ON. Otherwise the truncation also affects the where clause.

    Paul Koufalis
    White Star Software

    pk@wss.com
    @oeDBA (https://twitter.com/oeDBA)

    ProTop: The #1 Free OpenEdge DB Monitoring Tool
    http://protop.wss.com