I have another thought on this many WITH's. As a filter (I'm sure it's pretty much all AND's as mixing AND's and OR's tends to be misleading), and you're wanting a single list, perhaps just write a program to go through the file and challenge everything sequentially. If it passes all of the 200 or so tests, retain the item-id either in a local variable or writing to a temp file. As soon as it fails on any test go to the next item-id.
Then either WRITELIST the local variable or SELECT the temp file to get your list of quailfied records. My 2 cents Mark Johnson P.S. Something tells me that your current TCL SELECT statement isn't generated by hand or run in a PROC and that it's being created by a data/basic program. Thus, by the time you assemble the TCL statement, you could be testing the records. ----- Original Message ----- From: "Richard Brown" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, September 25, 2006 7:04 PM Subject: Re: [U2][UD] UniQuery SELECT WITH Limits > A couple of thoughts. If you do > > SELECT FILENAME WITH FIELD = "123""456""479" > > does that count as multiple WITHs? > > You could setup a dict item that looks at a certain position in the field > then select on that. > D3 UD/U2 > FIELD.NAME FIELD.NAME > 1 A 1 I > 2 0 2 @ID[3,1] > 3 3 > 4 4 > 5 5 1L > 6 6 S > 7 > 8 T3,1 > R > 1 > > SELECT FILENAME WITH FIELD.NAME = "1" > > Will get all the items that have a 1 in the 3rd position of the ID > > > ----- Original Message ----- > From: "jjuser ud2" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Monday, September 25, 2006 3:21 PM > 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
