hi
Umesh (very new BAAN IV user) here

is there any session available to find

all the tables related to a session or any other method to find it.

What do you mean related to a session? All the MAIN tables, or all accessed tables, or all updated tables...?

If you have access to the program scripts, it would probably be easiest to look directly in there. There is a print-session which could help you: ttadv4430m000 in BaanV, I hope it's the same for Baan IV, it's "Print Where Used Tables". If you choose all tables for one session you could get result, although I have not tried this.

If you can be more specific, we might be able to advice better...


Regards,

En.

there used to be something in the past called 'luminux' that you could install and this would do that kind of stuff for you if i remember correctly. I believe later on baan integrated this in another one of their environment scan products/add ons. Anyone remenber this??

I remember seeing support eye giving this information.
Please try it.

Try the session ttstpsessinfo in BaaN IV c4. I think it will solve your problem.

KDM

Hi all

Though I am now sure about the requirement. But I though you want to know the all table name which is used in a particular session. You can try this option and u will get a details log file in server. so that u will get all table name .

Regards


Debdas





Use the below command in the BECS. You can use as given in the below example.

actual code: -- -set TT_SQL_TRACE=<value> -logifile <give file name> -keeplog<sessioncode>

Example:

-- -set TT_SQL_TRACE=0240 -keeplog -logfile log.trace tdind0432m000

In the above example 0240 is the value. log.trace is the file name, tdind0432m000 is the session code.

You can even try this script technical data ttadv2450m000. This will give the table usage by scripts . If you have the sources it can even parse in includes and give the report.