Data Mapping and SQL

[FKolmann@xxxxxxxxxxxx]

>Marcin Sagan  wrote:
>   
>I need to do some sort of data mapping i.e.
>
>How to write data to files/fields given as a parameter?
>Is there any way except SQL?
>Any API?
>message file - this is flat text file, plus sign is data separator
>
>HDR+SomeData1+SomeData2
>SND+SenderInfo1+SenderInfo2+SenderInfo3+..+SenderInfoN
>ADD+AdditionalInfo1+AdditionalInfo2+..+AdditionalInfoN
>.
>EOM+ControlNumber
>
>Format of message file
>Tag      Element     Type    ..   Destination File   Destination Field
>HDR         1        Num     ..     LOGFILE             FLD1
>HDR         2        Char    ..     LOGFILE             FLD2

I apologise for any offence, none is intended.
I saw the replies to Macins question but AFAIS most are irrelevant.
This looks like a standard  UN EDIFACT document.
The reply to buy a EDI PACKAGE is probably the most
practical; we use Intercept/400.
BUT I am very interested in the Mapping question.
I  often ponder just how to write a program to map these 
EDI transactions to a relational DB. (maybe I should get a life)
I am very interested in Rob Brents supposed SQL (I love SQL)
solution, can you please show me examples. (TIA)

Frank Kolma

__________________________________________________________________
Get your own FREE, personal Netscape Webmail account today at 
http://webmail.netscape.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
+---