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.