Charles: And some complain about the obtuse nature of "F" correlatives. :-)
Bill -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Monday, September 25, 2006 4:22 PM To: [email protected] Subject: RE: [U2][UD] UniQuery SELECT WITH Limits Don't know about UD limits. Here's a workaround: Write a control record with the 251 different numbers that you are searching for. Then SELECT file WITH EVAL "SUBR( '!EQS', TRANS( controlfile, controlid, -1, 'X' ), REUSE( field.in.question ))" = "1" Something close to that, anyway. It loops through the entire file once (the expensive part), and does 251 comparisons for each record (not so sepenseive). cds ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
