Re: Portable schema?

Adrian Shepherd wrote: > > Although I have never used it , you can set the FIPS flagger option on in > Oracle that will tell you if you are using non ANSI standard SQL (i.e. > Oracle enhanced), if this was an option in Informix then you could generate > standardised code which of course is the goal of portablity) > > Roger Tomas wrote in message <35A14160.81E820F6@agcs.com>... > >I'm trying to set up a schema (ie. SQL script) that I can use > >with both Oracle and Informix. Constraint definitions seem > >to be the where the most syntactic differences are. I've tried > >to use the C preprocessor to conditionalize a lot of the code > >but I've gotten to where there's more conditional code than > >shared code. It's pretty ugly. > > > >Is this a lost cause? Does anyone know a good way to do > >this? > > > >TIA! > > > >Roger Tomas > >AG Communication Systems > > > > Unfortunately, I suspect it would be a subset. Informix names constraints in a non-ANSI way (name at end instead of beginning). -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/