@ID in this case points to the filename mentioned in my statement: LIST ORDER.FILE
the @ID's from ORDER.FILE.OTHER are showing up as non-existent: (My merged list contains 10 items from ORDER.FILE and 10 items from ORDER.FILE.OTHER) ORDER.FILE NAME......................... Name.OTHER.................. 114061 C.M.O.S. INC. *ASC* 114062 AMERICAN PERFIT XSTAL 122228 TIMELAND COMPANY 122229 MCCANN ELECTRONICS *STR* 130395 TERMINAL TECH SERVICE 138562 TOWN VISION ELECTRONICS 154897 CASIO SERV CENTER *ASC* 163063 CASIO SERV CENTER *ASC* 171230 AMERICAN PERFIT XSTAL 195731 ELECT MUSIC INSTR *FAS* 10 records listed Enter <CR> to print non exist record ids 007890 007891 007892 007893 007894 016057 016058 016059 016060 016061 Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 11:18 AM To: [EMAIL PROTECTED] Subject: RE: [UD] Union Query My suggestion is to create a "V" type dictionary item(s) that with point to your other file. For example, if you want to look at the city name in your file, ORDER.FILE.OTHER, create the following: 001: V 002: TRANS('ORDER.FILE.OTHER', @ID, <location of city in ORDER.FILE.OTHER'>, 'X') 003: 004: City (ORDER.FILE.OTHER) 005: 30L 006: S Also, I recommend that you check out the capabilities of TRANS. There are other return codes. Hope this helps. Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110 Phone: (703) 334-0156 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web: www.bench.com <http://www.bench.com> -----Original Message----- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 11: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
