1

We are migrating Informix database to oracle. Please help us to extract SYNONYM and SEQUENCE from Informix metadata using query.

migrated from stackoverflow.com Dec 1 '15 at 9:42

This question came from our site for professional and enthusiast programmers.

4

Although you don't mention the version of the informix, try the ones above.

I believe that since V9.4 there is a system catalog table named SYSSEQUENCES where you can find the information about sequences on each database.

For the synonyms the one to be used is SYSSYNTABLE, if you have an older version try the SYSSYNONYMS.

  • 1
    No current version of Informix uses syssynonyms; it is a relic from the days of yore — Informix 1.10, 2.00, 2.10 — and has not been used since version 4.00 (there never was a version 3.00 for various good enough reasons at the time, and the time under discussion is 1986-1988). – Jonathan Leffler Dec 2 '15 at 8:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy