RE: dbschema and dbaccess different.
Hi there
David Harvey Wrote>
} >Hi all,
}
} >We are running Online 7.12.UC1 on AIX V4, and I have a table (possibly
} >several), which has different columns as far as dbschema and
} >dbaccess->Table->Info->Columns is concerned. Querying against
} >syscolumns gets the columns in the dbschema order. What is wrong with
} >dbaccess? Is my only option to dbexport and dbimport all the affected
} >databases, as most of the databases here were onloaded from this
} >corrupt one?
}
} >I've tried onchecking everything about the table, but no problems are
} >ever reported.
}
} >Help!
Just a wild shot in the dark here but...have you run update statistics
lately? You do realize that
system catalogues are not updated automatically?
Type the following in DBaccess and run it :
UPDATE STATISTICS
If the catalogues are really behind, then this will run for quite some
time : )
Good luck
David
}
}
}david@west.co.za
}Senior Software Consultant
}The West Solutions Group
}Friends help you move...REAL friends help you move bodies!
}