Client Parameters
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
Deprecated (obsolete). Use ImageDatabase.
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)
ImageDatabase=,,,,
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
SDFile
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.
Driver | String Value to identify the driver in use. Used for ODBC connections. Driver=”HP3000 Data Access Driver” driver=3kodbc |
2DriverTable | Translation table for 8bit codes from the host (HP3000) to client(Windows, etc.). 2DriverTable=/opt/minisoft/rom8ansi.tbl |
2HostTable | Translation table for 8bit codes from the client (Windows, etc.) to host (HP3000). 2HostTable=/opt/minisoft/ansirom8.tbl |
Account | Logon account (Only used with Server Type=0) |
Account Password AccountPassword |
Account password (Only used with Server Type=0) |
Database<n> | This form is deprecated (obsolete). Use ImageDatabase<n> <database name to access on the HP3000>,<database password>,<load auto master flag 0/1>6,<database open mode (zero based)>3 |
ImageDatabase<n> | <database name to access on the HP3000>,<database password>,<load auto master flag 0/1>6,<database open mode (actual)>3 |
DecimalPoint | For use with foreign character sets. |
Description | Description string |
Group | Logon group (Only used with Server Type=0) |
Group Password GroupPassword |
Group password (Only used with Server Type=0) |
Jobname | Session or Job name (Server Type=0) |
Language | For use with foreign character sets |
Schema<n> | <name of the schema file>,<lockword> |
Server | Server IP Address or Hostname |
Server Port ServerPort |
Server Port – usually 30006 |
Server Type ServerType |
Type of host for the ODBCSRVR (0=MPE, 1=Unix, 2=Windows) |
User | User logon name |
User Password UserPassword |
User password |
AutoCommitDefault | Use transaction manager for writes. (ON,OFF) |
Catalog User CatalogUser |
ODBCCAT user name |
Security Password SecurityPassword |
Security/30000 password (Server Type=0) |
WarningsAreErrors | Effect of selecting less than the total number of columns. (YES,NO) |
SDFile<n> | filename, lockword, type (Image SD, Quiz Subfile, Robelle SD), fopt, aopt |
Domain | Windows Domain (Server Type=2) |
ItemLocking | ENABLED or DISABLED |
LockRetries | An integer value referencing the number of times to retry a lock. |
NOTES:
- All names are case sensitive.
- As of 2.2.6.2, spaces in some parameter names are optional.
- 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.
- When specifying Databases, SDFiles or Schemas the value of should be replaced with a digit starting from zero for each of these parameters.
- Comas must be included whether or not a value is entered.
- Where 1 is load automatic masters and 0 is do not load automatic masters.
- Where two names appear for a parameter, they are synonyms. You may use either form.