Odp: Re: Data mapping

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
SND         1        Num     ..     ORDERS              FLD1
SND         2        Num     ..     ORDERS              FLD2
.
.
SND         N        Date    ..     ORDERS              FLDN
ADD         1        Num     ..     DETAILS             FLD1
.
.
ADD         N        Char    ..     DETAILS             FLDN
EOD         1        Num     ..     LOGFILE             FLD3

I want to read the message file search for tag in format file and write data to 
apropiate fields in files LOGFILE, ORDES, DETAILS


Regards
Marcin



>>> <rob@dekko.com> 03/20 2:51  >>>

Could you paste some sample records?  And a sample usage?

Rob Berendt

==================
Remember the Cole!


                                                                                
                                       
                    Marcin Sagan                                                
                                       
                    <itbamsag@bh.com.        To:     RPG400-L@midrange.com      
                                       
                    pl>                      cc:                                
                                       
                    Sent by:                 Subject:     Data mapping          
                                       
                    owner-rpg400-l@mi                                           
                                       
                    drange.com                                                  
                                       
                                                                                
                                       
                                                                                
                                       
                    03/20/01 04:29 AM                                           
                                       
                    Please respond to                                           
                                       
                    RPG400-L                                                    
                                       
                                                                                
                                       
                                                                                
                                       




Hi all

I need to do some sort of data mapping
i.e.
in file 1 I have message from other system
in file 2 I have format of this message and names of files and fields where
this information should be stored in my shop (Because format of message can
be changed I would like to separate code from this format)

How to write data to files/fields given as a parameter?
Is there any way except SQL?
Any API?
Any ideas?

Thanks in advice
Marcin
!
   !

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



+---
| 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 
+---
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                               !
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                               !
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                               !
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                               !
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                               !
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                          
+---
| 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
+---