Data mapper

I have a project staring me down that requires me to send and receive
documents (PO's, Shipping Acknowledgements, Order Status) from multiple
companies.  My company currently reserves the right to have a standard for
sending as receiving documents but I don't think that will fly.

We are using our own proprietary format to transfer the data which all of
the companies playing adhere to, but everybody has their own idea of how and
where the data should be put within this format.

So I need to create a data mapper of sorts that would be similar to
Harbinger or any other EDI X.12 data mapper.  I need to do it in RPG because
that is what I know.  Java is also another possible solution but I have only
dabbled in java.  I am guessing that I will also need to do it in SQL so I
don't have to hard code file and field names into my programs.

Does anyone have ideas or examples of how I could accomplish this?

Aaron Bartell
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---