MERGE.LIST has a UNION option. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Burwell, Ed Sent: Wednesday, May 16, 2007 9:09 AM To: [email protected] Subject: [U2] [UD] Union Query
Has anyone developed or know of a way to do the equivalent of a UNION query in UniData? I have 2 files, one is a daily file and the other is a monthly file. At night the daily records get moved into the monthly file and the daily file gets cleared. At month-end, the monthly data gets moved into a history file and the monthly file gets cleared. You know the drill. Both files are structured identically and share the same dictionary. I would love to do something like: SORT DAILY.FILE AND MONTHLY.FILE WITH DATE >= "5/1" BY DATE DATE PART.NUMBER DESCRIPTION BIN TOTAL QTY I stared writing a program called UNION.SORT that I would use instead of SORT. Parsing the Uniquery statement started to get hairy (and I don't have that much time to devote to this) so I put it down. If REFORMAT or SREFORMAT had a way to move the entire record into the new file instead of just the dicts listed, I'd be home free. I also don't want to re-write our application to populate the monthly file at the same time we populate our daily file (then just clear the daily file at night). Any ideas, suggestions? Thanks in advance. Ed Burwell 973-361-5400 ext. 1512 973-615-9880 cell [EMAIL PROTECTED] ______________________________________________________________________ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. ______________________________________________________________________ ------- 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/
