RE: Data mapper

[Buck Calabro <Buck.Calabro@xxxxxxxxxxxx>]

Aaron wrote:

>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.

Build a data dictionary of elements (fields), items (ship to address) and
documents (invoice)  This will determine your output format.  For instance,
an invoice is made up of:
PO
  Customer ID
    Customer account (10)
    Customer buyer name (50)
    Customer buyer phone number...
  Ship to
    Ship to company (50)
    Ship to address...

Knowing the order and the sizes of each output field will allow you to
position data properly (you can use program described data and judicious
string manipulation.)

Do something similar for your input data.  Build a file that maps the
input/length/data type to your output elements/items/documents.

Best of luck!
Buck Calabro
Commsoft; Albany, NY
"Nothing is so firmly believed as
 that which we least know" -- Michel Montaigne
Visit the Midrange archives at http://www.midrange.com
+---
| 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
+---