Re: Really old version of Informix on Xenix

Barrie Smith wrote: > > I'm using a really old version of Informix (I think it's 3.3) on an old > Xenix box. It comes with some kind of old tool called Informix Reporter. It > uses bizarre ancient 4GL. I'm looking for a manual for this language. The > interactive query language is pre-SQL, using "print" instead of "select" > and such. > > I'd appreciate any help I could get. > > Please reply to my e-mail.... > > --Christopher > cbsmith@envise.com I certainly remember 3.3 (and earlier) but I don't recognise Informix Reporter. I suspect you mean the Informix report writer ACE. The language is much like the current ACE so if you can get the manual for that you will have most of it. The syntax which replaces SELECT is READ. READ [INTO X] fieldlist {WHERE clause }{JOINING clause } END fieldlist is a comma separate list of fields (columns in SQL parlance). The WHERE clause includes selection terms only and the JOINING clause takes the terms which join files (tables in SQL). No sub-selects and, if I remember correctly, no MATCHES. There's no ORDER BY in the READ but you can have a separate SORT BY fieldlist END statement. Hope this helps - but I won't part with may manual! Ian