Problem:

Batch options can be used to change xdb.ini information

Resolution:

If you type bopt40n /h from the mfe\\mfsql\\bin directory you get the following information:

C:\\mfe30\\mfsql\\BIN>bopt40n /h

XDB Batch Options 1.0.1  Copyright 1997 XDB Systems, Inc. All rights reserved.

Batch Options Usage Information

===============================

  /p <parameter>- where parameter is in the format

                  /p<group>.<variable>=<value>

                  There may be multiple instances of /p options.

  /f <filename> - path and filename of the batch parameter

                  file.  The filename may have any disk, directory,

                  name and extension.  If no directory is

                  specified the default is the current directory.

  /t            - terse.  Restricts all messages except error

                  messages.

  /i<inifile>   - the XDB initialization file to modify.

  /g <filename> - generates a file consisting of all settings

  /u <filename> - specifies the setting file to use

  /h            - displays this file.

  1.  Messages can be redirected to a file by piping the program

      output in to a file.  Ex:  bopt40n /fremote.xdb > xdbset.out

  2.  Parameters are executed in the order that they appear on the

      command line.  This means that in order for terse to be in

      effect for all parameters it must appear first in the list.

  3.  CONFIG.XDB is also updated.  The CONFIG.XDB file modified is

      in the same directory as the XDB initialization file.

  4.  If there are spaces in the parameter put that part in quotes.

[BOPTMAIN.CPP.576] BOPT Done.

If you want to generate a file to show you everything type the following:

C:\\mfe30\\mfsql\\BIN>bopt40n /g c:\\bopt.out

[BOPTMAIN.CPP.576] BOPT Done.

This will place all the current settings in a file called bopt.out and you can then run commands like below to make changes.

bopt40n "/pSecurity.ClientSecurity=On"

bopt40n "/pConnection ROBIN.PrimaryAuthorizationID=INSTALL"