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 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of jjuser ud2 > Sent: Monday, September 25, 2006 12:22 PM > To: [email protected] > Subject: [U2][UD] UniQuery SELECT WITH Limits > > Hi hello how are ya :) > > Limits. The documentation I have for "Using UniQuery" says > that you can only have 120 different "with" fields in a > SELECT statement. I'm trying to select a series of > non-contiguous numbers at random intervals to generate a > select list. There are 251 of these numbers. > Do I have to split the list into three different groups in > order to generate three different lists that I can do a > SAVE.LIST on? What's the best way to go about getting these > select lists? > > When I execute the LIMIT command in UniData, it tells me: > > U_MAXFNAME: File name limit = 198. > U_NAMESZ: Record id(key) size = 126. > U_SELEMAX: Number of select list = 10. > U_MAXDATA: Number of DATA statement = 500. > U_HEADSZ: HEADER/FOOTER length = 2120. > U_MAXHASHTYPES: Number of hash functions = 3. > U_MAXSORT: Number of sort fields(BY...) in LIST = 20. > U_MAXWITH: WITH stack size = 256. > U_MAXWHEN: WHEN stack size = 60. > U_MAXCAL: Number of SUM+AVG+PCT+CAL in LIST = 54. > U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. > U_MAXLIST: Number of attribute names in LIST = 999. > U_LINESZ: Page width in printing = 272. > U_PARASIZE: Paragraph name and its parameter size = 256. > U_LPCMD: System spooler name = NT Spooler. > U_MAXPROMPT: Number of prompts allowed in paragraph = 60. > U_FSIZE: Dictionary field name size = 31. > U_MAXVALUE: Number of values WHEN can handle = 10240. > U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. > U_SENTLEN: Maximum sentence length = 9247. > U_PROCBUFSZ: Proc buffer size = 4095. > U_NIDES: Maximum number of virtual fields in query= 256. > > Thanks! :) > ------- > 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/
