Hi everybody,

I am trying to insert in a .bat script in Windows, the command that will run a Baan session, ttdba0915m000, with some specific settings.

This session is not available to run into a job (the Make Job...) button is not there.

This session asks for the DBA user name and PW also.

Does anybody know a way to do this? :confused:

Is ntbshell -server odba0915... work?

You can make a 3-GL program with a AFS wrapper to that session. You would have to hardcode the DBA login/password or take command line parameters.

Alternatively, you can use the $BSE/bin/ora* binaries.

Basic Q - Why do you want to do it ?

I have set up a SQL Script to update our DEV environment using a SQL backup, instead of going throught the Baan application. I need to recreate all the DB users and I would prefer doing it using the application.

I am not familiar with an AFS wrapper.

How about the binaries? I am not sure to fully understand...

The binaries are from the Porting Set in $BSE/bin
[DEV:bsp]/app/lms/lmss/opt/bse/bin
>ll ora*
-rwxr-xr-x 1 bsp bsp 823296 Sep 20 2004 ora8_adm6.2
-rwxr-xr-x 1 bsp bsp 614400 Sep 20 2004 ora8_maint6.2
-rwxr-xr-x 1 bsp bsp 2039808 Sep 20 2004 ora8_srv6.2
-rwxr-xr-x 1 bsp bsp 61 Mar 3 2004 ora8_srv6.2.sh
-rwxr-xr-x 1 bsp bsp 119 Sep 20 2004 ora_update

>ora8_maint6.2 -U
Usage:
Add an user.
[ -n ] -a Baan User -m DBMS User -p User Password -G group { -F -c DBMS Admin -i DBMS
Admin Password | -P Group Password }

Change user password.
[ -n ] -r Baan User -m DBMS User -p New Password -G group { -o Current Password | -F -
c DBMS Admin -i DBMS Admin Password }

Drop an user.
[ -n ] -d Baan/DBMS User -G Group { -F -c DBMS Admin -i DBMS Admin Password | -P Group
Password }

Add a group.
[ -n ] -A group -P Group Password { -F -c DBMS Admin -i DBMS Admin Password }

Change group password.
[ -n ] -R group -P Group Password { -F -c DBMS Admin -i DBMS Admin Password | -o Curre
nt Group Password }

Drop a group.
[ -n ] -D group { -P Group password | -F -c DBMS Admin -i DBMS Admin Password }

Check password: -h -m DBMS user -p password -G group

Batch mode: -b batchFile

Redirect errors to errorFile:
-q errorFile

Set environment variables: -O environmentList

Print Usage. -U

Print Version Information. -v or -V
Back to my Q - Why does it need to run as a batch job ?

For AFS info refer to the section - AFS/DDC/OLE: Function servers (http://www.baanboard.com/baanboard/forumdisplay.php?f=59)

It looks like I could do something with that. Thanks for the info.

Answer to your Q: I want to automate the full process and be able to schedule it. I might have another way of doing it but I will try it with what you gave me. It is possible that might be able to restore the links between the logins and the users without recreating them. (SQL 2000)

Thank you very much for the info. :)