There is any way for read an sql table apart of Baan in a program session?

We work with DB2 and we have another application for payroll and we need to obtein data from this application and use it in Baan.

Thank you in advance,

And really, that is best practice. If you want to share data between applications you will have to create an interface.

But, how can I access to this sql tables? There is any command to read an external table or I need to copy this table to in a Baan table?

There is however nothing to prevent other applications from writing to the Baan domain.
So yes, replicating your table (or view) to the Baan domain will make its data accessible for Baan code.

You can transfer your another database's data to your customized baan table.
Or you can try opposite way of this.

Good LUck !

Thank you very much

I did it , I think that you can easly do it .
TAKE IT EASY !!!!!

mr_suleyman can you explain me how to do it?
Can you write me an example or something?

It depends on your structure. We created sql scripts on other DB that gives data in XLS format.It transfers data to windows server. I read this file on Baan and insert records to customized table. To provide automatic working , I add it to Job Scheduler on both other DB and BAAN. That's works well for our structure.

Good Luck !

Another way to do it is to fire a shell script from within the Baan session.

The shell script will use a stand alone command line program to access the DB2 database and get the data - then will save it in a file that will be read by the Baan session.

This is the way I have seen this done.