Re: Informix and Oracle
> > 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 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 '% ')? 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. 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. ________________________________________________________________________