Re: Want V6 to V7 war stories

From: Divad777 <divad777_at_aol.com>
Date: 11 Jun 1994 01:09:01 -0400
Message-ID: <2tbgtd$bs8_at_search01.news.aol.com>


A few pointers:
- Do a full export from V6 and import into V7. This will
automatically change the CHAR's to VARCHAR2's in your tables.
- If you have PRO*C programs that DID NOT use indicator variables
when querying for null values, you now get a warning message. If you were doing error checking using sqlca.sqlcode, you may get errors since the code returned will no longer be a 0.
- Some uses of LIKE may no longer work correctly. This is only in
cases where LIKE was being use to verify against null values. V7 follows the correct ANSI interpretation of null which is NOTHING -- not even zero.

In general, most conversions from V6 to V7 that I have seen have been painless. The features of V7 make the conversion well worth it. Received on Sat Jun 11 1994 - 07:09:01 CEST

Original text of this message