I'm not sure I fully understand what you are trying to do. If you are trying to read data and output to a file, then why not just hit the database tables and out put the data you need?

Can you explain a little more please?

i have some files contains data about related record data.that means data constructs parent-child relation ship.we want to import that data to tables in one database hit.i saw related topic on peoplebooks.but i can't understand.path is peoplebooks->peoplecode reference ->file class ->multiple filelayout concepts
related concept is sending one component data(with levels) to different files using multiple filelayouts .
could you explain these two concepts?

"i have some files contains data about related record data."
"sending one component data(with levels) to different files using multiple filelayouts"

I'm confused now, you started saying you want to import data into the database and finished by saying you want to export data from a component to files?

Are we trying to write to files or read from files?

i am also trying to retrive the data from the data base using multiple file layout's.but i am not sucessed...could u plz help me in this..

just think i 2 levels like level 0 ,level1 and level 2

i want to know how to retrive the all level's data by using one multiplt file layout

"i am also trying to retrive the data from the data base using multiple file layout's.but i am not sucessed...could u plz help me in this.."

PeopleBooks have an example that is exactly what you are looking for! The example is located at PeopleBooks > Enterprise PeopleTools 8.49 PeopleBook: PeopleCode API Reference > File Class > File Layout Examples (scroll until you see WriteRowset Example). This is almost all what you need, just modify the records and file layouts to fit your needs and you are set! They even have screen prints of the component with level 0, 1 and 2.

Hi,

I am trying to write a file (using Application Engine) with header, details and trailer. The individual records and file layout are defined and I am able to write the header and detail records. However, I could not write the trailer record. The trailer record consists of one constant field and another field where the total counts of the detail records written are saved. I have tried saving this info in state records and do not know how to pass this while writing the trailer record. Your input is greatly appreciated. Thanks!!
green

Green, welcome to the site! Can you please start a new forum post for your problem? You will be able to get more help that way. Your issue is not related to "multiple file layouts" that this post is for. Thank you!