Re: Calculating square root in ISQL
} From ilist@rmy.emory.edu Thu Jul 28 06:46:48 1994
} Received: from rmy.rmy.emory.edu by talon.ftc.scs.ag.gov with tcp (4.1/ftc-1.3)
} id AA23755; Thu, 28 Jul 94 06:46:44 MDT
} Received: by
} rmy.rmy.emory.edu (5.65/Emory_rmy.3.4.0) via MAILPROG
} id AA28370 ; Thu, 28 Jul 94 08:52:09 -0400
} Return-Path: ilist@rmy.emory.edu
} From: graeme@pyramid.com (Graeme Sargent)
} Message-Id: <1994Jul27.172927.348@pyra.co.uk>
} Subject: Re: Calculating square root in ISQL
} Date: Wed, 27 Jul 1994 17:29:27 GMT
} Reply-To: graeme@pyramid.com (Graeme Sargent)
} Organization: Pyramid Technology Ltd.
} Sender: informix-list-owner@rmy.emory.edu
} To: informix-list@rmy.emory.edu
} X-Informix-List-To: george@talon.ftc.scs.ag.gov
} X-Informix-List-Id: <news.7850>
} Status: RO
} Content-Length: 1288
}
} Bonnie Weller (weller@zorro.cecer.army.mil) wrote:
}
} : Hello
}
} : I have SE 5.01 ISQL 4.11. I do NOT have 4GL (which I understand can
} : do square roots.)
}
} : I need to compute the following into an sql statement.
}
} : _____________________
} : \\ | 2 2
} : \\| (x1-x2) + (y1-y2) < r1+r2
}
} : I am not sure how to do the square root part of the equation as isql does
} : not have this capability.
}
} I find that surprising. Square root has been in the engine since <=5.00.
}
} select sqrt(whatever) ... works on my OnLine 5.00 engine, I would expect
} it to work with SE also.
}
} If you believe isql is the problem, why not use dbaccess?
}
} graeme
} --
} Disclaimer: The author's opinions are his own, and not necessarily
} those of Pyramid Technology Ltd. or Pyramid Technology
Inc.
}
----------------------------------------------------------------
-----------
} -m------- Graeme Sargent Voice: +44 (0)252 373035
} ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135
} -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who???
} -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk
}
----------------------------------------------------------------
-----------
} We have the technology. The tricky bit is learning how to use it.
}
Graeme suggests that ISQL might be the problem. I have been following this thead for
quite some time and apparently only now just realized what the color was. I have SE 4.0,
ISQL 4.00.UH1, also SE 5.0 and ISQL 4.00.UH1 (SYS V/386 4.2 UNIX). I, of course
am able to perform SQRT (as well as the other functions the unraveling of this thread
has revealed) from SE 5 and DBACCESS. However, after Graeme's wakeup call, I tried
it with SE 5 and ISQL 4.00.UH1. It works. It does not work, of course with SE 4 and
ISQL.
Just my .02 worth.
George Teachman
george@talon.ftc.scs.ag.gov