dbschema and dbaccess different.

Message is sent with MIME. Attachments are base64 encoded --TFS-with-MIME-and-DIME Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable Hi all, =20 We are running Online 7=2E12=2EUC1 on AIX V4, and I have a table (poss= ibly=20 several), which has different columns as far as dbschema and=20 dbaccess->Table->Info->Columns is concerned=2E Querying against=20 syscolumns gets the columns in the dbschema order=2E What is wrong wi= th=20 dbaccess? Is my only option to dbexport and dbimport all the affected= =20 databases, as most of the databases here were onloaded from this=20 corrupt one? =20 I've tried onchecking everything about the table, but no problems are=20 ever reported=2E =20 Help! =20 Ta Davin ********************************************************************** DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu= k=20 This message and any attachments to it is intended only for the=20 individual or company to which it is addressed and may contain=20 information which is privileged, confidential or prohibited from=20 disclosure or unauthorised use=2E If the recipient of this=20 transmission is not the intended recipient, or the employee or agent=20 responsible for delivering such materials to the intended recipient,=20 you are hereby notified that any use, any form of reproduction,=20 dissemination, copying, disclosure, modification, distribution and/or=20 publication of this e-mail message or its attachments other than by=20 its intended recipient is strictly prohibited by the sender=2E =20 If you have received it in error, please notify us immediately by=20 telephone on the number above and destroy the message and all copies=20 in your possession=2E ********************************************************************** --TFS-with-MIME-and-DIME Content-Type: text/rtf; name="MSGCC.RTF" Content-transfer-encoding: base64 {\\rtf1\\ansi \\deff0\\deflang1024{\\fonttbl{\\f0\\froman Tms Rmn;}{\\f1\\froman Symbol;}{\\f2\\fswiss Helv;}} {\\colortbl;\\red0\\green0\\blue127;\\red0\\green127\\blue0;\\red0\\green127\\blue127;\\red127\\green0\\blue0; \\red127\\green0\\blue127;\\red127\\green127\\blue0;\\red127\\green127\\blue127;;\\red0\\green0\\blue255; \\red0\\green255\\blue0;\\red0\\green255\\blue255;\\red255\\green0\\blue0;\\red255\\green0\\blue255; \\red255\\green255\\blue0;\\red255\\green255\\blue255;}\\paperw12240\\paperh15840\\margl1800\\margr1800\\margt1440\\margb1440 \\gutter0 \\defformat\\sectd \\pard\\plain {\\plain \\f0 \\cb7 \\cf0 \\cb1 \\cf14 \\cb1 \\cf14 Hi all,\\ \\cb1 \\cf14 \\ \\cb1 \\cf14 \\cb1 \\cf14 We are running Online 7.12.UC1 on AIX V4, and I have a table (possibly \\ \\cb1 \\cf14 \\cb1 \\cf14 several), which has different columns as far as dbschema and \\ \\cb1 \\cf14 \\cb1 \\cf14 dbaccess->Table->Info->Columns is concerned. Querying against \\ \\cb1 \\cf14 \\cb1 \\cf14 syscolumns gets the columns in the dbschema order. What is wrong with \\ \\cb1 \\cf14 \\cb1 \\cf14 dbaccess? Is my only option to dbexport and dbimport all the affected \\ \\cb1 \\cf14 \\cb1 \\cf14 databases, as most of the databases here were onloaded from this \\ \\cb1 \\cf14 \\cb1 \\cf14 corrupt one?\\ \\cb1 \\cf14 \\ \\cb1 \\cf14 \\cb1 \\cf14 I've tried onchecking everything about the table, but no problems are \\ \\cb1 \\cf14 \\cb1 \\cf14 ever reported.\\ \\cb1 \\cf14 \\ \\cb1 \\cf14 \\cb1 \\cf14 Help!\\ \\cb1 \\cf14 \\ \\cb1 \\cf14 \\cb1 \\cf14 Ta\\ \\cb1 \\cf14 \\cb1 \\cf14 Davin\\ \\par }}4 --TFS-with-MIME-and-DIME--