Identifying In-place Alters before IDS upgrade

Posted in 2000

Bernstein, Rick — Mon, 16 Oct 2000 12:28:21 -0700 — source: Informix-list mailing list archive (1991-1998)

We are planning an Informix upgrade. Before-hand we need to consolidate each table into one version. It is not practical for us to run "oncheck -pt <database>:<table>" commands against 11,000 tables. Are there SQL commands, which can identify tables with multiple versions from "in-place ALTER" commands? If so, can someone provide the proper syntax? Your assistance in this endeavor would be appreciated. Thanks, Rick