Larry: You have hit the nail on the head. I did some additional testing based on what you suggested and found that this is exactly what is going on. My (incorrect) assumption about the LISTOF command was that it would create a UNIQUE or DISTINCT list of column values. What is actually the case is that *by default* it creates a list of ALL values in the selected column.
For those interested, here is what I discovered: I found that you can actually (and maybe I overlooked this feature at RSYNTAX.COM) use this format of the command to create a DISTINCT list of values: SELECT (LISTOF(DISTINCT heatnum)) INTO vheats IND vind FROM rej_join + WHERE (rejdate BETWEEN 01/01/2002 AND 01/02/2002) Note the addition of the DISTINCT operator. Using this format of the LISTOF command will now give me what I need and will indeed be the format most frequently used, I would venture to say. In this particular example *without* the DISTINCT operator the result was 152 items. By adding the DISTINCT operator the result was 46 items. Larry, thanks for your excellent suggestion. I have now discovered the solution to my problem. Thanks -- Mike > -----Original Message----- > From: Lawrence Lustig [SMTP:[EMAIL PROTECTED]] > Sent: Friday, February 01, 2002 5:43 PM > To: [EMAIL PROTECTED] > Subject: Re: LISTOF problem > > > > > > > Yes. Although the example I enclosed did not have the indicator > variable > I > > have tried it with the variable and got the same results. > > Mike: is it possible that some of the LISTOFs are overrunning a note > variable size (4092 chars)? > -- > Larry > > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
