Stuart, UniVerse SQL "SELECT DISTINCT" and RetrieVe "SELECT ... SAVING UNIQUE ..." (which are semantically identical queries) need the UniVerse parameter "ALLOWMARKS"=1 to work with medium-large queries. This parameter is set by default = 0. There is an enhancement request at IBM for documenting this behaviour (ECase 7837), as it has been stated to be permanent in UniVerse.
The "DISTINCT" or "SAVING UNIQUE" clauses make the query engine internally building a B-tree in memory, but when a certain amount of data is to be treated, this memory is flushed into a temporary B-Tree file growing with the rest of the selected field concerned. By design, the Record IDs written into this particularType 25 temporary file are containing marks, thus the problem with the "ALLOWMARKS" parameter = 0. Hope this will help. Regards, Hervi BALESTRIERI Support Technique Avanci - Produits "U2" ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
