hi i want to create a new company in baan, but i dont know how to start.... what do i have to do??? in unix, oracle anda baan.... i need to copy the tables... but how can i create those tables in one tablespace.... please i need someone´s help!!!!!!!!!!

and if i have the table tccom001804, how can i copy this table as tccom001899 for example

Hi,

Try this,

1.You could just Export and import tables using ttaad4100
or
2.just write a simple script to insert rows like

select tiitm001.* from tiitm001
where tiitm001._compnr="804"
selectdo
db.insert(ttiitm001,db.retry)
endselect

It worked for me !!

For New Company Creation -> Search the Form , Its already been posted many times.

Regards,
Sushil Kumar Mudaliar

You need to export the tables and import them again. Within the tools/database management menu you find the right sessions for that.
After you have imported the tables in the new company you need to run tfgld9004m000 to renumber the company fields in the tables.

If you want to have this new company in a new TS than:
1. create the TS in oracle
2. update the file $BSE/lib/ora/ora_storage
3. Logout, login
before you perform the import.

Not sure about baaniv, in newer versions you have some sessions available to update the ora_storage. However manually updating it will do.

Try to get an documentation cd for BaanIV, you will find a lot of documentation on it.

After you have imported the tables in the new company you need to run tfgld9004m000 to renumber the company fields in the tables.
tccom0214m000 run in Baan IV as well and it is faster to change company number before import it.

You need to export the tables and import them again. Within the tools/database management menu you find the right sessions for that.
After you have imported the tables in the new company you need to run tfgld9004m000 to renumber the company fields in the tables.

If you want to have this new company in a new TS than:
1. create the TS in oracle
2. update the file $BSE/lib/ora/ora_storage
3. Logout, login
before you perform the import.

Not sure about baaniv, in newer versions you have some sessions available to update the ora_storage. However manually updating it will do.

Try to get an documentation cd for BaanIV, you will find a lot of documentation on it.

Hi, do you know what are the sessions in baan that update $BSE/lib/ora/ora_storage ?

Hi, do you know what are the sessions in baan that update $BSE/lib/ora/ora_storage ?

Hello,

use vi (or other editor) to modify.

Regards