Many thanks. Cheers,
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" ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ********************************************************************** ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
