In a message dated 4/24/2007 7:36:26 A.M. Central Daylight Time, [EMAIL PROTECTED] writes:
My understanding is TRUNC(BIN) was used by a lot of customers because they were afraid of data being truncated when working with, say, DB2 and other apps that use the whole capacity of a binary field. Problem is, it's a compile-wide option, so all work with all binary fields had to go through the same [undocumented] algorithm. >> It was hardware too! Some of the early 9672's G1-G4's didn't have a good implementation and the LSPR benchmarks were revised to reduce the exposure according to Cheryl Watson. Haven't heard from her in a while, everything OK down that way??? ************************************** See what's free at http://www.aol.com. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html

