I'm sorry, I spoke too quickly. The ID's are needed in the primary file. I would copy all the ID's to a work file and then TRANS-ing the NAME.LO, to ORDER and ORDER.CAN will work OK. Of course, if you do have the same ID in both files you have to decide what do to do with that.
Again, sorry for not testing out my solution before I offered it.
Regards, Bruce
From: "Allen Egerton" <[EMAIL PROTECTED]> Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Subject: Re: Memo: RE: [UD] Union Query Date: Fri, 30 Apr 2004 14:41:17 -0400
From: "Burwell, Edward" <[EMAIL PROTECTED]> To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]> Sent: Friday, April 30, 2004 2:00 PM Subject: RE: Memo: RE: [UD] Union Query
> Does that work for you? It doesn't work for me. > > ORDER.FILE NAME..................... > > 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 > > Here is the dict: > > 001: I > 002: TRANS("ORDER.FILE",@ID,3,""):TRANS("ORDER.FILE.CAN",@ID,3,"") > 003: > 004: NAME > 005: 25L > 006: S
I can't test it right now, I don't have access to a Universe machine until
tonight. Try an ID.SUP, 'cause the ids for ORDER.FILE.CAN certainly aren't
in ORDER.FILE.
-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
_________________________________________________________________
MSN Toolbar provides one-click access to Hotmail from any Web page – FREE download! http://toolbar.msn.com/go/onm00200413ave/direct/01/
-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
