Re: 7.x -> 5.x joins

Ron: The 7.x INFORMIX ver makes the transformation of differents types of data, well the thing is if you join of a char type with an integer the engine makes the conversion of data types before retriving the data so you better check the types between de new instance and the old one. Ron M. Flannery wrote: > I'm currently migrating a bunch of 5x databases to 7x. We're migrating > one database at a time. The old databases are running on a > Compaq Sypro running SCO and Online version 5.00.UD6. The new databases > are on an HP running IDS 7.24.UC3. When I run a particular query on the > 7x instance and join to the other instance, it takes an incredible > amount of time (query supplied below). If I eliminate the 7x table from > the query and just access the 5x tables, it works great. So it seems > like the problems only occur when doing this particular join. The table > sizes are fairly small, about 50-60K rows. > > Has anyone else run into such a problem and how might I go about fixing it? > > Thanks, > Ron > > QUERY (7x local table is uxct; the others are on 5x): > select > uxct.sno,uxct.uocc_no,uxct.cov_type,uxct.xact_date,uxct.amount, > uxct.pay_fyear > ,uocc.fyear ,occ.occ_auth_code,occ.occ_fyear,occ.occ_mbr_no, > occ.occ_seq_no > ,occ.occ_close_date,occ.occ_rptd_date,occ.occ_date,mbr.mbr_name > > from uxct, uocc, occ, mbr > where uxct.rins_code = '10' and uxct.xact_type = 'P' and > uxct.pay_fyear >= 1998 and uxct.pay_fyear <= 1998 and uxct.uocc_no = > uocc.uocc_no and uocc.uocc_no = occ.uocc_no and occ.occ_mbr_no = > mbr.mbr_no and occ.occ_auth_code= mbr.mbr_auth_code ;