Case structure et.al.
[email protected] Fri, 23 Feb 2007 23:20:44 GMT
| Newsgroups | gmane.comp.lang.4gl.fourjs.user |
|---|---|
| Message-ID | <[email protected]> |
I have been having to jump between sql server and informix databases
and have gotten used to Case and Join syntax on the sql server side. I
see the commands are valid under Informix 9.x that we have, but I can't
get any program to compile with Join or Case.
e.g.
select i.*, d.unitprice, d.prodname
from invoice i join detail d on d.invoicenum = i.invoicenum
Left and right outer joins don't work either.
In the case of case:
select 'N' as TransCode,
case shiploc.state
when ('AB' ) then 'CAN'
else 'USA'
end as country,
shiploc.store
from shiploc
into temp orders
This doesn't work either.
I tried enclosing that all in SQL ENDSQL and it didn't compile either.
Fri 02/23/2007-15:18:57.48 O:\GWN\Source>fglwrt -a info
Development license 'FABXXXXXX' with 1 runtime user(s).
License server usage enabled.
Extension(s):
- Open Database Interface
Warning! This is a temporary license, installation number is 'YYYYYYY'.
This temporary installation will expire in 12 day(s).
Got any ideas?