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/
