Re: Informix and Oracle

In article <55815u$4lo@cssun.mathcs.emory.edu>, Jack Parker <jparker@nexus.boi.hp.com> writes >> >> Hello Jack, >> I'm sorry if I troubled you. >> I've been start work with Informix 3 years ago just when I've been start >> work with Oracle. I'm a computer programmer in a team that develops >> software about office automation and when the project started, both RDBMS >> was choiced to work with our software. >> So we have been used ODBC to access our data and we have tried to use >> only SQL/ANSI statement to work fine with both. Every problem that >> we have solved, has taken x time in Oracle and 2x in Informix when it was >> possible. In fact, in some cases, we had to keep some code customized for >> Informix. What instances. >> What do you think about a software that grows with a great quantity of >> "if Informix then ..." when discover that standard SQL/ANSI statement has >> a different behaviour (for example LIKE '% ')? What is the different behaviour? > >It sounds like Oracle is doing a better job for you then Informix. My >apologies - your note sounded like you were just starting in an Informix >environment and having what I would consider normal growing pains. > I would need more info. >When working for a long period of time in one environment we tend to >develop algorithms that work well in that environment but which don't >translate well to another. Hence my question about why you care about >trailing spaces. Maybe it is the algorithm itself you should be looking >at and not the LIKE statement. > >I assume that you have already received Doug Wilson's post with it's >suggestion - which I have not tried so I can't vouch for it. > >'civediamo >j. >________________________________________________________________________ >Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA >jparker@boi.hp.com Currently on loan to PLD/PE >________________________________________________________________________ > Outside of a dog a book is a man's best friend. > Inside of a dog it's too dark to read. (Groucho Marx) >________________________________________________________________________ >Any opinions expressed herein are my own and not those of my employers. >________________________________________________________________________ -- David Williams