You can definitely have logicals on the files you're mapping into. It might be a problem if you weren't mapping correctly one of the key fields; thus it would assume that multiple detail lines of zero were not unique. Not sure you would want to have join logicals over multiple files, though Harbinger definitely requires this technique on outbound files. Bob Entwistle Famous Footwear "Stone, Brad V (TC OASIS)" <firstname.lastname@example.org> on 10/11/99 02:03:05 PM Please respond to MIDRANGE-L@midrange.com To: "'MIDRANGE-L@midrange.com'" <MIDRANGE-L@midrange.com> cc: (bcc: Bob Entwistle/HQ/Corporate) Subject: Harbinger EDI Question Hello. We just started setting up Trusted Link to receive an 850. We built logicals over the files that the data is mapped to. They were uniquely keyed (transaction number for header, transaction number, detail line number for detail). When trying to map, the mapping program (Harbinger's) bombed (hard crash, amazing for a purchased product) with a duplicate key error on one of their files (not our files). We remove our logicals, and the program does not bomb when mapping. After looking at the data, there is no data that would have caused a duplicate key error from our logicals. Then again, it is their file that it is getting the duplicate key error on. Can you not have ANY logicals on the files that are used to map data from EDI? Their tech support seemed to have think so, but I think it was just to get off us the phone. Not to mention we told them what we did to make it work. We're still waiting for a call from a developer to see why we can't have logicals on our files for mapping. Anyone? Bradley V. Stone BVS/Tools http://www.bvstools.com +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: email@example.com +--- +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.