Re: Concatenation operator in embedded SQL statements in 4GL

>From: Jacob Salomon <jake@apparel.net> >Date: Mon, 9 Jun 1997 16:59:42 GMT >X-Informix-List-Id: <news.38946> > >I just tried the following in a 4GL program: > > select col1 || col2 > into myvariable > from some_table > >The 4GL compiler actually generated a syntax error for this! >;-( I had >to go through the PREPARE/DECLARE/OPEN/FETCH rigmarole. What's incredible? The I4GL system recognises strictly the 4.10 syntax. You can get away with calling SPs in SELECT statements because it recognises them as functions and doesn't (mercifully) have a list of built-in function. Anything else that was not a part of 4.10 is not recognised by I4GL. Version 6 I4GL is only Version 4 I4GL with 6.00 connectivity; at one point, we considered selling it as "Version 4.12 I4GL for 6.00 Servers". It has no different understanding of the SQL statements, and has never been sold as having a different understanding of the SQL statements. >Considering that the || concatenation operator has been available in the >engine since 4.1 or so, I find it incredible that the 4GL 6.05 syntax >checker can't handle it. Concatenation was introduced in 5.00, and therefore was not part of 4.10 SQL. >Anyone know if this is a known bug? Or some outstanding feature request? It is not a bug. It is a well known feature request. >It certainly was not expected behavior! Please align your expectations with reality! Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>