Please help with SQL

Posted in 1996

Vitaly E. Kursitis — Thu, 21 Nov 1996 17:01:05 +0300 — source: Informix-list mailing list archive (1991-1998)

Hi all. I'm new in informix and I've got some silly questions that I can't seem to find the answers to. I'm working on Informix SE v5.01. 1. There is a table "tab1" that has astrucure like this: ! koef ! value1 ! value2 ! ! float ! float ! float ! Using ESQL/c I calculated koef and I need to find the nearest koef in this table in order to get the corresponding value1 and value2 from there. How can I do it using SQL? 2. Is there a system function like abs() that works with float numbers? 3. How can I set the precision for output values? (value1 and value2 fields stores numbers with 3 floating point (1.234) but after "select * from tab1" I got 1.23 only). Thanks in advance. Vitaly