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)" <bvstone@taylorcorp.com> 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: david@midrange.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: david@midrange.com
+---

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].