Re: Data mapping

Hi back!

Marcin Sagan wrote:

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

Let's make sure that I understand your question.  File 1 has a variable format 
string of data.  Sort of like a data queue.  It's just a character string of 
varying length.  Within the string (like the first few positions) is there a 
code that let's you know what the string identifier or format is?  Is this a 
CGI application where each an every variable can have different lengths or is 
it a fixed format?

Now when you talk about file 2, is it a list of from-to positions so you can 
walk down the character string of file 1 and parse out the data or is file 2 an 
externally defined file that you can use in your program as a data structure 
and parse by a simple MOVE command or is it a list of keyword/value pairs to 
assist you in parsing?

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