Hi,
I would like to know how can i generate a ascii file which will contain all the data from a particular table.
For eg if table is lttst001 then the file which i should be able to generate must be having say for eg values in format
abc~pqr~xyz
123~456~326
~ is a seperator
These are the records in my table for eg.
If different table is selectted then the fields pertaining to that table must be brought in the table.
Thanx

Shivanand,

Look up to the tools technical manual for the database tools/utility - bdbpre6.2

or you can also use the BaaN Exchange.

You can search with those keywords on the Board to find many discussions.

Hi Shivanand,

maybe the session ttaad4226m000 "Create Sequential Dump of Table" is what you are looking for.

Juergen

bdbpre6.1 -t"~" -o. -Nlttst001 -C100

Will extract your table from company 100 and put a file tlttst001100.S in your current directory.

oh... assuming UNIX

Cheers.

While we're on the subject, you can accomplish the same from inside Baan General Table Maintenance:

1. Look up your table
2. Hit 'space bar' to bring pull down menus
3. Choose Application / Export Data

This does the same as bdbpre - creates the tablename.S file, but allows you to put in a range based on the current index.