{"id":1695,"date":"2014-11-06T18:22:17","date_gmt":"2014-11-06T18:22:17","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=1695"},"modified":"2020-06-11T12:12:42","modified_gmt":"2020-06-11T19:12:42","slug":"client-parameters","status":"publish","type":"post","link":"https:\/\/www.minisoft.com\/support\/client-parameters\/","title":{"rendered":"Client Parameters"},"content":{"rendered":"

Common Client Settings for ODBC, JDBC, and OLEDB<\/h3>\n

(for server settings Server Parameters<\/a>)<\/p>\n

2DriverTable=[FILENAME]<\/h4>\n

FILENAME = Translation table file stored on the client for 8bit codes from the host to client.<\/p>\n

2DriverTable=\/opt\/minisoft\/rom8ansi.tbl<\/p>\n

2HostTable=[FILENAME]<\/h4>\n

FILENAME = Translation table file stored on the client for 8bit codes from the client to host.<\/p>\n

2HostTable=\/opt\/minisoft\/ansirom8.tbl<\/p>\n

Account=[ACCT]<\/h4>\n

ACCT = MPE Logon account (Only used with Server Type=0)<\/p>\n

Account=MINISOFT<\/p>\n

Account Password=[PASSWORD] AccountPassword<\/h4>\n

PASSWORD = MPE Account password (Only used with Server Type=0)<\/p>\n

AccountPassword=SAMPLE<\/p>\n

AutoCommitDefault<\/h4>\n

Value is either ON or OFF. Default is ON.<\/p>\n

AutoCommitDefault=ON<\/p>\n

BigIntAsChar<\/h4>\n

Value is either NO or YES. Default is NO<\/p>\n

BigIntAsChar=NO<\/p>\n

Catalog User<\/h4>\n

Character string. Name of the user.<\/p>\n

Catalog Password<\/h4>\n

Character string. CatalogPassword<\/p>\n

CenturySplit<\/h4>\n

Numeric value in years. Used when dates only have the year and not the century.<\/p>\n

CenturySplit=20<\/p>\n

Database<\/h4>\n

Deprecated (obsolete). Use ImageDatabase.<\/p>\n

DecimalPoint<\/h4>\n

Special character to be used as the decimal point. The default is “.”<\/p>\n

DecimalPoint=.<\/p>\n

Description<\/h4>\n

DisableTxns<\/h4>\n

Value is either NO or YES. Default value is NO<\/p>\n

DisableTxns=NO<\/p>\n

Domain<\/h4>\n

Driver<\/h4>\n

DSN<\/h4>\n

Group<\/h4>\n

Group Password<\/h4>\n

GroupPassword<\/p>\n

IgnoreUIDPWD<\/h4>\n

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)<\/p>\n

ImageDatabase=,,,,<\/h4>\n

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.<\/p>\n

DBNAME = database name to access on the host.<\/p>\n

DBPASS = database password<\/p>\n

AMFLAG = load auto master flag 0\/1<\/p>\n

MODE = database open mode (actual)<\/p>\n

TPIFLAG = append TPI suffix 0=No 1=Yes<\/p>\n

ImageDatabase0=MSCARD.MM.MINISOFT,DO-ALL,0,5,0<\/p>\n

ImageDatabase1=OTHERM.MM.MINISOFT,READ1,0,5,0<\/p>\n

ItemLocking<\/h4>\n

Jobname<\/h4>\n

Language<\/h4>\n

LockRetries<\/h4>\n

MPE<\/h5>\n

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.<\/p>\n

non-MPE<\/h5>\n

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.<\/p>\n

MaxCacheSize (1024-10240)<\/h4>\n

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.<\/p>\n

MaxWriteSize (512-16384)<\/h4>\n

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.<\/p>\n

password<\/h4>\n

PWD<\/h4>\n

Schema<\/h4>\n

SDFile<\/h4>\n

Security Password<\/h4>\n

SecurityPassword<\/p>\n

Server<\/h4>\n

Server Port<\/h4>\n

ServerPort<\/p>\n

Server Type<\/h4>\n

ServerType<\/p>\n

StandardJoins<\/h4>\n

TraceSysLevel<\/h4>\n

(see Tracing Facilities)<\/p>\n

TraceFileName<\/h4>\n

(see Tracing Facilities)<\/p>\n

TraceLogLevel<\/h4>\n

(see Tracing Facilities)<\/p>\n

TraceLogFlush<\/h4>\n

(see Tracing Facilities)<\/p>\n

UID<\/h4>\n

User<\/h4>\n

User Password<\/h4>\n

UserPassword<\/p>\n

WarningsAreErrors<\/h4>\n

These parameters are used for ODBC, JDBC and OLEDB connections to MPE, UNIX, and Windows servers.<\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Driver<\/strong><\/td>\nString Value to identify the driver in use. Used for ODBC connections.
\nDriver=”HP3000 Data Access Driver”
\ndriver=3kodbc<\/td>\n<\/tr>\n
2DriverTable<\/strong><\/td>\nTranslation table for 8bit codes from the host (HP3000) to client(Windows, etc.).
\n2DriverTable=\/opt\/minisoft\/rom8ansi.tbl<\/td>\n<\/tr>\n
2HostTable<\/strong><\/td>\nTranslation table for 8bit codes from the client (Windows, etc.) to host (HP3000).
\n2HostTable=\/opt\/minisoft\/ansirom8.tbl<\/td>\n<\/tr>\n
Account<\/strong><\/td>\nLogon account
\n(Only used with Server Type=0)<\/td>\n<\/tr>\n
Account Password<\/strong>
\nAccountPassword<\/strong><\/td>\n		Account password
\n(Only used with Server Type=0)<\/td>\n<\/tr>\n
Database<n><\/strong><\/td>\nThis form is deprecated (obsolete). Use ImageDatabase<n>
\n<database name to access on the HP3000>,<database password>,<load auto master flag 0\/1>6,<database open mode (zero based)>3<\/td>\n<\/tr>\n
ImageDatabase<n><\/strong><\/td>\n<database name to access on the HP3000>,<database password>,<load auto master flag 0\/1>6,<database open mode (actual)>3<\/td>\n<\/tr>\n
DecimalPoint<\/strong><\/td>\nFor use with foreign character sets.<\/td>\n<\/tr>\n
Description<\/strong><\/td>\nDescription string<\/td>\n<\/tr>\n
Group<\/strong><\/td>\nLogon group
\n(Only used with Server Type=0)<\/td>\n<\/tr>\n
Group Password<\/strong>
\nGroupPassword<\/strong><\/td>\n		Group password
\n(Only used with Server Type=0)<\/td>\n<\/tr>\n
Jobname<\/strong><\/td>\nSession or Job name (Server Type=0)<\/td>\n<\/tr>\n
Language<\/strong><\/td>\nFor use with foreign character sets<\/td>\n<\/tr>\n
Schema<n><\/strong><\/td>\n<name of the schema file>,<lockword><\/td>\n<\/tr>\n
Server<\/strong><\/td>\nServer IP Address or Hostname<\/td>\n<\/tr>\n
Server Port<\/strong>
\nServerPort<\/strong><\/td>\n		Server Port – usually 30006<\/td>\n<\/tr>\n
Server Type<\/strong>
\nServerType<\/strong><\/td>\n		Type of host for the ODBCSRVR (0=MPE, 1=Unix, 2=Windows)<\/td>\n<\/tr>\n
User<\/strong><\/td>\nUser logon name<\/td>\n<\/tr>\n
User Password<\/strong>
\nUserPassword<\/strong><\/td>\n		User password<\/td>\n<\/tr>\n
AutoCommitDefault<\/strong><\/td>\nUse transaction manager for writes. (ON,OFF)<\/td>\n<\/tr>\n
Catalog User<\/strong>
\nCatalogUser<\/strong><\/td>\n		ODBCCAT user name<\/td>\n<\/tr>\n
Security Password<\/strong>
\nSecurityPassword<\/strong><\/td>\n		Security\/30000 password (Server Type=0)<\/td>\n<\/tr>\n
WarningsAreErrors<\/strong><\/td>\nEffect of selecting less than the total number of columns. (YES,NO)<\/td>\n<\/tr>\n
SDFile<n><\/strong><\/td>\nfilename, lockword, type (Image SD, Quiz Subfile, Robelle SD), fopt, aopt<\/td>\n<\/tr>\n
Domain<\/strong><\/td>\nWindows Domain (Server Type=2)<\/td>\n<\/tr>\n
ItemLocking<\/strong><\/td>\nENABLED or DISABLED<\/td>\n<\/tr>\n
LockRetries<\/strong><\/td>\nAn integer value referencing the number of times to retry a lock.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

NOTES:<\/h4>\n
    \n
  • All names are case sensitive.<\/li>\n
  • As of 2.2.6.2, spaces in some parameter names are optional.<\/li>\n
  • 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.<\/li>\n
  • When specifying Databases, SDFiles or Schemas the value of should be replaced with a digit starting from zero for each of these parameters.<\/li>\n
  • Comas must be included whether or not a value is entered.<\/li>\n
  • Where 1 is load automatic masters and 0 is do not load automatic masters.<\/li>\n
  • Where two names appear for a parameter, they are synonyms. You may use either form.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

    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 […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[64,54,63,65],"tags":[104],"_links":{"self":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1695"}],"collection":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=1695"}],"version-history":[{"count":26,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1695\/revisions"}],"predecessor-version":[{"id":8018,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1695\/revisions\/8018"}],"wp:attachment":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=1695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=1695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=1695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}