Common client settings for ODBC, JDBC, and OLEDB

(for server settings Server Parameters)

• 2DriverTable=[FILENAME]

  FILENAME = Translation table file stored on the client for 8bit codes from the host to client.

  2DriverTable=/opt/minisoft/rom8ansi.tbl

• 2HostTable=[FILENAME]

  FILENAME = Translation table file stored on the client for 8bit codes from the client to host.

  2HostTable=/opt/minisoft/ansirom8.tbl

• Account=[ACCT]

  ACCT = MPE Logon account
  (Only used with Server Type=0)

  Account=MINISOFT

• Account Password=[PASSWORD]
  AccountPassword

  PASSWORD = MPE Account password
  (Only used with Server Type=0)

  AccountPassword=SAMPLE

• AutoCommitDefault

  Value is either ON or OFF.  Default is ON.

  AutoCommitDefault=ON

• BigIntAsChar

  Value is either NO or YES.  Default is NO

  BigIntAsChar=NO

• Catalog User

  Character string.  Name of the user.

• Catalog Password

  Character string.  CatalogPassword

• CenturySplit

  Numeric value in years.  Used when dates only have the year and not the century.

     CenturySplit=20

• Database<n>

  Deprecated (obsolete). Use ImageDatabase<n>.

• DecimalPoint

  Special character to be used as the decimal point. The default is "."

     DecimalPoint=.

• Description

• DisableTxns

  Value is either NO or YES.   Default value is NO

     DisableTxns=NO

• Domain

• Driver

• DSN

• Group

• Group Password
  GroupPassword

• IgnoreUIDPWD
  
  When set (numeric value of 1), values passed in the connection string for user or password do not supersede the value provided in the DSN or connection string. Use only if your applications passes default values that are not related to your host system. i.e. passing the windows user name to an MPE system.
  (Default value is 0)

  IgnoreUIDPWD=1

• ImageDatabase<n>=<DBNAME>,<DBPASS>,<AMFLAG>,<MODE>,<TPIFLAG>

  • n = Sequential number starting with zero. Each database to be opened in the same DSN must have a unique value. All the databases in the same DSN will be opened with the same security credentials.
  • DBNAME = database name to access on the host.
  • DBPASS = database password
  • AMFLAG = load auto master flag 0/1
  • MODE = database open mode (actual)
  • TPIFLAG = append TPI suffix 0=No 1=Yes

  ImageDatabase0=MSCARD.MM.MINISOFT,DO-ALL,0,5,0
  ImageDatabase1=OTHERM.MM.MINISOFT,READ1,0,5,0

• ItemLocking

• Jobname

• Language

• LockRetries

  MPE

  If a first lock attempt does not succeed, there is a 1/4 second delay after each unsuccessful lock until the number of lock retries is reached.

  non-MPE

  If a first lock attempt does not succeed, the server application uses a progressive lock delay algorithm. The delay algorithm is: (0.05 + 0.01 * attempt + 0.001 * attempt * attempt)
  The first retry will be after a delay of 0.05 seconds the tenth 0.221 seconds and the twentieth 0.601 seconds. The total time asleep after 20 tries will be at least 1.155 seconds.

• MaxCacheSize (1024-10240)

  Largest size of a buffer that can be transmitted from the host to the client. Primarily used to resolve issues caused by packet filtering network switches that attempt to resolve entire TCP packets through fragment consolidation. If the switch does not have sufficient memory to accommodate the traffic, fragment re-assembly make take several seconds. Changing this value can seriously impact performance. Please contact Minisoft support if this value is to be used.

• MaxWriteSize (512-16384)

  Largest size of a buffer that can be transmitted from the client to the host. Primarily used to resolve issues caused by packet filtering network switches that attempt to resolve entire TCP packets through fragment consolidation. If the switch does not have sufficient memory to accommodate the traffic, fragment re-assembly make take several seconds. Changing this value can seriously impact performance. Please contact Minisoft support if this value is to be used.

• password

• PWD

• Schema<n>

• SDFile<n>

• Security Password
  SecurityPassword

• Server

• Server Port
  ServerPort

• Server Type
  ServerType

• StandardJoins

• TraceSysLevel

  (see Tracing Facilities)

• TraceFileName

  (see Tracing Facilities)

• TraceLogLevel

  (see Tracing Facilities)

• TraceLogFlush

  (see Tracing Facilities)

• UID

• User

• User Password
  UserPassword

• WarningsAreErrors

These parameters are used for ODBC, JDBC and OLEDB connections to MPE, UNIX, and Windows servers.

NOTES:

1. All names are case sensitive.
2. As of 2.2.6.2, spaces in some parameter names are optional.
3. The 0 mode value for the Database open is offset from zero. A value of 0 means mode 1, a value of 4 means mode 5.
4. When specifying Databases, SDFiles or Schemas the value of <n> should be replaced with a digit starting from zero for each of these parameters.
5. Comas must be included whether or not a value is entered.
6. Where 1 is load automatic masters and 0 is do not load automatic masters.
7. Where two names appear for a parameter, they are synonyms. You may use either form.