Common settings for ODBC, JDBC, and OLEDB

This page lists all the parameters and options used to start both the client and server portions of these products. The list is current for version 2.2.8.

• Server Settings
• Connection (Client) Settings

Server Settings

Parameters (Not case sensitive)

These values are used on the startup line for the servers. This can be in the command file or inetd configuration that launches the listener process.

Precede these values with a slash (/) for HPUX, Windows, and Linux. When using more than one parameter, use the space character to separate them (including MPE). The parameters are not order dependant.

• S - Require valid host logon information. (highly recommended)
• W - Allow update access.
• N - Use Eloquence Native libraries in place of Image emulation.
• V - Print version information to the terminal and exit.
• R - Return record numbers as ROWID column.
• H - Allow host command processing.
• C - Use Catalog Editor file for additional access control.
• F - Force Full Read mode.
• P - Port to use.
• T - Trace mode. (Do not use this option in production.)
• E - Environment File.

Parameters Samples

HPUX

The following line from inetd.conf on an HPUX system shows the parameters that permit write access, require a valid logon, and returns the record number as ROWID.

MPE

The following line from the MSJOB file on an MPE system shows the same settings.

Environment Variables

Integer

• MSTRACELOGON (not MPE)
  
  Set to 1.
  Logs startup  (valid or error message).
  Logs Usage (record count and CPU) on exit.
• AIFCHANGELOGON (MPE only)
• MSTEMPFM (MPE only)
• MSFILEEQ (MPE only)
• TraceSysLevel
• TraceLogLevel
• TraceLogFlush
• ROBELLE_SD_TYPE
• NATIVE_ELOQ
• MSQUERYRECLIMIT
• MSQUERYCPULIMIT
• MSQUERYCHECKINTERVAL
• MSTRACESTATEMENT
• TRACEDBSTATS

String

• TraceFileName
• MSDECADEDIGITS
• TMPDIR (HPUX)

Connection (Client) Settings

(More details on pre 2.2.8 Connection Settings)

• 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

  define

  sample

• BigIntAsChar

  define

  sample

• Catalog User
  CatalogUser

• Catalog Password
  CatalogPassword

• CenturySplit

• Database<n>

  Deprecated (obsolete). Use ImageDatabase<n>.

• DecimalPoint

• Description

• DisableTxns

• 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

  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

  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

  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

• TraceFileName

• TraceLogLevel

• TraceLogFlush

• UID

• User

• User Password
  UserPassword

• WarningsAreErrors