I need some data from baan to a text file seperated by some char.
That data is not from single table,its from multiple tables with some constraints.
What is the best way to get the data from baan???
1) Can we get that data from Exchange scheme(If its from more than one table how to get)??
2) or else can I create a text file manually shalll I write into that??

or else is there any other way
pls help me.

rgds,
JAck

Baan exchange can help u get data written to txt file from any tables. if u use conditions , u can bring data from other tables too. For single table with static conditions and for use by IT people this can be better.

U can also use dynamic query to fetch data from multiple tables and then write to txt file. It can be most general way for non-IT users.

U can also get aSCII output of the report and do not print the header/footer etc if the spool.device = ASCIF . Good for ready multi-table reports for non-IT users . Output can have extra lines in the output .