vibako
18th June 2003, 04:59
Hello:

I am using Baan IVc4 and Oracle. I have set up the audit environment for certain tables. Now I would like to read those tables and write them to an Ascii file. Of course Exchange would be the tool to use.....

In my directory I have the audit file: asls040900

How can I use Exchange to read this Audit table and create an Ascii file from it? If this was the table tdsls040900 - no problem, but how do I perform the same action using the Audit table?

How do I define the asls040900 table in the sessions:

1. Maintain Ascii files....
2. ....


Any help is appreciated,

Thanks!
Vibako

Djie-En
18th June 2003, 10:56
Hi,

Pls. use session:
ttaad4461m000 or
ttaad4463m000
and wirte the results to an ASCII0file

GN

vibako
18th June 2003, 14:37
Hi,

But what if I would like to seperate my fields by a comma or another seperator? Is it not possible to use Exchange for this then?

I have to create an Ascii File from the Audit table with the following format:

field1,field2,field3, etc......

How can this be solved?

Thanks,
Vibako

vibako
18th June 2003, 15:11
I also want to export the audit table on a regular basis...

That's why I was thinking of the Exchange Module...