In that case, I'm sorry to say, there is no way to logically do what you're asking with UD. You could physically do it by creating a temp file and copy all records from both files to it. But that would be a great deal of overhead for a query.
Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward > Sent: Friday, April 30, 2004 11:24 AM > To: 'U2 Users Discussion List' > Subject: RE: [UD] Union Query > > > No, a record ID in one file will not exist in the other file. > > -----Original Message----- > From: Jeff Schasny [mailto:[EMAIL PROTECTED] > Sent: Friday, April 30, 2004 11:14 AM > To: U2 Users Discussion List > Subject: RE: [UD] Union Query > > > TCL (or whatever your flavor calls the queery language) is a > single file oriented language. No joins. You would need to > create TRANS items in the dictionary of one of the files > pointing to the other. Are the record ID's in both files the > same for a given record that you would want to relate? > > -----Original Message----- > From: Burwell, Edward [mailto:[EMAIL PROTECTED] > Sent: Friday, April 30, 2004 8:05 AM > To: 'U2 Users Discussion List' > Subject: RE: [UD] Union Query > > > I understand how Unibasic could handle a list that has been > merged, but how would you do a Uniquery statement? > > for example: > > SELECT ORDER.FILE WITH DATE > "1/1/2004" > SAVE-LIST LIST1 > > SELECT ORDER.FILE.OTHER WITH DATE > "1/1/2004" > SAVE-LIST LIST2 > > GET-LIST LIST1 TO 1 > GET-LIST LIST2 TO 2 > MERGE.LIST 1 UNION 2 > SAVE-LIST LIST.ALL > > GET-LIST LIST.ALL > > What do you enter here? > > LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP > > or > > LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP > > How would a virtual dictionary know which file to get the > NAME ADDRESS CITY and STATE from? > > Thanks. > > Ed Burwell > [EMAIL PROTECTED] > 973.361.5400 x1512 > > > > > -----Original Message----- > From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED] > Sent: Friday, April 30, 2004 10:27 AM > To: 'U2 Users Discussion List' > Subject: RE: [UD] Union Query > > > You could use MERGER.LIST to get one list which is a UNION of > two separate selects of each file. But you would not know > which file the key was from when you were done. But Unibasic > or Virtual dictionary items could take the merged list and > produce what you are looking for. > > -----Original Message----- > From: Burwell, Edward [mailto:[EMAIL PROTECTED] > Sent: Friday, April 30, 2004 9:13 AM > To: 'U2 Users Discussion List' > Subject: [UD] Union Query > > > Hello, > > Does anyone know of a way to do the equivalent of a UNION > "query" (really a LIST or SORT) on 2 or more different UniData files? > > I have 2 files in separate accounts that are structured the > same. I want to do something like: > > SORT ORDER.FILE AND ORDER.FILE.OTHER WITH DATE > "01/01/2004" > NAME ADDRESS CITY STATE ZIP > > Thanks in advance. > > Ed Burwell > [EMAIL PROTECTED] > 973.361.5400 x1512 > -- > u2-users mailing list > [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > > -- > u2-users mailing list > [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > -- > u2-users mailing list > [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > -- > u2-users mailing list > [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > -- > u2-users mailing list > [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
