I have one query...........can qptool be used for doing updation or insertation in the baan tables..............

No, unfortunately not. It's only a retrieval tool.

thank you..........Actually I am using a perl programing to fetch the data from the database using qptool and displaying them on a HTML page. Can you suggest me some tool or utility that can be used to update/insert data in the baan tables........

If Oracle is the DBMS, try using sqlplus.

Thanks once again...........Yes my DBMS is oracle...Will I be able to use sqlplus as qptool from the perl script.......do I require any specific driver or any other softwere to perform the DB operations.

If you can call qptool6.1 from perl, then you can also call sqlplus.
Check with your DBA for usage on sqlplus, he may need to setup a user identified externally as well for this purpose, for ease of operation.

Hi sanjay,

using sqlplus from perl should be very cumbersome.
Perl has proper modules to access oracle, check on CPAN for this.

But you should be very carefull, when writing to Baan tables:

a) If you use level 1 driver, then forget it. Baan writes hashes, which you would need to update.

b) You have to be carefull to fullfill the Baan constraints. You will be able to write a lot of values, which are ok in Oracle, but not in Baan. If the Baan driver sees such a data record, then it will crash, without telling you the record causing the problem.
Example are ennum values, positive integers, date values and so on.


Actually my company will develop a driver to solve all these issues, but this will take some month. Drop me an email, if you are interested,

Regards

Markus

Hi Markus,

Thanks for your help and guidance. Actually I want to update the static data of BaaN for example say I want to update the description feild of area table. For this we are fetching data from baan tables using qptool. Now we want to update the table with some other description. We are using perl scripting to do so. Since the perl connectivity to oracle is not working at my end, I am not able to use the perl module option. And I got stuck here. I tried connecting through java (oracle thin client drivers), but this option does work only on command prompt and does not work through internet browser.

If you can't get DBD::Oracle to work in Perl, then DBD::ODBC should also work if you're using Win32.