That did it. Thanks Wally. On Wed, Jan 7, 2009 at 3:22 PM, Wally Terhune <[email protected]> wrote:
> UDT.OPTIONS 22 ON might help. > Read about it in the UDT.OPTIONS manual.. > > > Wally Terhune > U2 Support Architect > IBM Information Management Software > Tel: (303) 773-7969 T/L 656-7969 > Mobile: (303) 807-6222 > Email: [email protected] > http://www.ibm.com/software/data/u2/support > > > > From: "Ross Morrissey" <[email protected]> > > To: [email protected] > > Date: 01/07/2009 04:17 PM > > Subject: [U2] Odd UD SELECT Behaviour with Trailing Period > > Sent by: [email protected] > > > > > > > The UniData SELECT occasionally seems to ignore trailing periods in keys. > > The following two SELECT statements return the same two records. > > >SELECT AR WITH @ID EQ "001278310" > > 2 records selected to list 0. > > >SELECT AR WITH @ID EQ "001278310." > > 2 records selected to list 0. > > Is there a way to tighten the environment up so that the same SELECT > statements each return just one record? > > Note that I'm not looking for SELECT AR "001278310" > > More info: > > >ECLTYPE > 2 U_PSTYLEECL ON > > Top of "@ID" in "DICT AR", 7 lines, 16 characters. > 001: D > 002: 0 > 003: > 004: AR > 005: 20L > 006: S > 007: > > Thanks, Ross. > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > > [demime 1.01d removed an attachment of type image/gif which had a name of > graycol.gif] > > [demime 1.01d removed an attachment of type image/gif which had a name of > ecblank.gif] > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
