Flat File Creation

, ,
1

I am fetching database records and created a record structure. Now, I want this record to be converted into flat file. Please, let me know the steps used to create a flat file from that record structure.

Thanks

2

I think what your solution lies in the template features of WM. Depending on your platform - you will need to implement some sort of template that converts a record to a string.

I am most familiar with WM 4.6. With a flat record structure like sql results - you should be able to write a template that creates the flat file (assuming there is a one to one relationship of the row in your record structure to the row in your flat file). If the record structure is not closely matching your flat file structure, you will need to construct your looping logic to fit your needs, but it will still be a template that converts the record to a string.

You can find more about the template features within the “templates and dsps” document.

Another technique that I use a lot when its a simple situation, is to declare a string variable in the pipeline, and use pipeline substitution to extract the values from the record, hard-coded directly into the string variable.

HTH

3

Hi,
I have the record structure. I just want to create a flat file schema from this using dictionary. Just want to know the steps how to create a data dictionary and flat file schema so that I can supply schema name in convertToString service. I read the documentation but cant get it through.

Thanks