Cross-platform 'dbschema'

This is a multi-part message in MIME format. --------------3A45BBE428DCC445771B7D27 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Greetings all! I've installed IDS 2000 on my PC and am trying to get a dbschema of a database on a remote UNIX machine running v7.31 and I get the following error: > -206 - The specified table (informix.sysxtdtypes) is not in the database. > -111 - ISAM error: no record found. > I figure this is because dbschema for IDS 2000 works a little differently from dbschema for IDS7.31. Can anyone confirm this for me? Cams -- Everything has it's wonders, even darkness and silence. and I learn, whatever state I may be in, therein to be content. -- Helen Keller --------------3A45BBE428DCC445771B7D27 Content-Type: text/x-vcard; charset=us-ascii; name="cmoore.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Camille Moore Content-Disposition: attachment; filename="cmoore.vcf" begin:vcard n:Moore;Camille tel;work:(876) 927-1125 Ext. 379 x-mozilla-html:TRUE url:www.fsl.org.jm org:Fiscal Services Ltd.;Technical Support version:2.1 email;internet:cmoore@fsl.org.jm title:Database Administrator adr;quoted-printable:;;235B Old Hope Rd.,=0D=0AKingston 6;;;;Jamaica fn:Camille Moore end:vcard --------------3A45BBE428DCC445771B7D27--

Camille Moore wrote: > > This is a multi-part message in MIME format. > --------------3A45BBE428DCC445771B7D27 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Greetings all! > > I've installed IDS 2000 on my PC and am trying to get a dbschema of a > database on a remote UNIX machine running v7.31 and I get the following > error: > > > -206 - The specified table (informix.sysxtdtypes) is not in the database. > > -111 - ISAM error: no record found. > > > > I figure this is because dbschema for IDS 2000 works a little > differently from dbschema for IDS7.31. Can anyone confirm this for me? Yes. I'm not convinced the 9.2x DB-Schema should fail simply because it is run against an older database server, but that's a separate discussion. In the 9.x family of products, there are user-defined types, and the sysxtdtypes (system extended data types) table stores that information. If it doesn't exist, the database is a good old-fashioned 7.x or earlier database. It's a bug of sorts; I'm not certain that it would be accepted as a bug by Tech Support, as it depends on whether DB-Schema 9.x is supposed to work against 7.x servers or not. In my book, it should. The official rule book may read differently. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"

Camille, it's not necessary for you to have IDS running locally on your machine to get the dbschema of a table running on another machine. Simply telnet into that remote machine and execute dbschema from there. The error message you're getting is because it seems you're running the dbschema on your local PC which contains no records of that table on the unix machine. Camille Moore wrote: > This is a multi-part message in MIME format. > --------------3A45BBE428DCC445771B7D27 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Greetings all! > > I've installed IDS 2000 on my PC and am trying to get a dbschema of a > database on a remote UNIX machine running v7.31 and I get the following > error: > > > -206 - The specified table (informix.sysxtdtypes) is not in the database. > > -111 - ISAM error: no record found. > > > > I figure this is because dbschema for IDS 2000 works a little > differently from dbschema for IDS7.31. Can anyone confirm this for me? > > Cams > > -- > -- Phillip Tien Database Administrator Whole Foods Market, Inc. Doctors say he has a 10% chance of living, though there's only a 50% chance of that.