Re: dbschema and dbexport now outputs "contraint ..." syntax

Jon Strabala wrote: > > Hi, > > When transitioning from Informix 5.X to 7.X for > a client I discovered that the same engine appears > to randamly emit or not emit a new syntax as follows: > > 5.X always > date_val date not null, > > 7.X sometimes > date_val date not null constraint "rpts".n100_1, > > The real downside is that I can do a dbexport and > then a subsequent dbimport which breaks on the > the "constraint ..." stuff under 7.X, however if > I hand edit the file and remove the constrint stuff > the dbimport succeeds. Not a very good feature. > > Both dbexport and dbschema exhibit this behavior, > any idea of what is going on and how to stop it. > > - Jon A. Strabala > jon@quantumsi.com > PLEASE also E-MAIL responses - I will repost a summary > > ****** details follow for a 7.X engine on two differnt boxes ***** > > (ABNORMAL and UNEXPECTED) This is not abnormal, however, if you want to filter out the stuff you don't want you can either use sed, ed, or awk to remove it from your final dbschema output. Many of the informix tools and commands must be managed this way. I hear many of the tools are headed for GUI, but until then you'll have to make do. Another approach you can do is get the information directly from the system tables. You would need to select this from systables and of course sysindexes. Do you have time for this? Probably not. But I have a 4GL report that is already for you to use. Head over to my website, download it, and you'll be on your way. There's also a few other tools over there you might be interested in. Go to: http://www.mindspring.com/~tschaefe Happy hunting and hope this helps... Tim