This Unix-only language setting is for Oracle access.

Please consult your Oracle documentation for information regarding specific valid values for your operating system.

If set to 1, this turns of the CONNX.AVI file.

Default - NOLOGO = 0

If set to 1, this setting disables the import of stored procedures.

Default - NOPROCEDURES = 0 (import stored procedures)

If set to 1, this setting disables the import of views.

Default - NOVIEWS = 0 (import views)

If set to 1, this setting makes CONNX add the "NO WAIT" clause to the end of the oracle SELECT … FOR UPDATE command.

Default - NOWAIT = 0

For either Oracle or PostgreSQL, add the following registry entry to store fractional numbers in a number field:

This setting is used by the CONNX Installation utility and does not need to be edited. It specifies whether the OLEDB Desktop Adapter was selected during the last installation.

This setting is used by the CONNX Installation utility and does not need to be edited. It specifies whether the OLEDB Enterprise Adapter was selected during the last installation.

This setting controls how CONNX initializes the OLE Subsystem. Based on what it finds in OLEINT, CONNX initializes the OLE Subsystem as either Apartment-Threaded or Multi-Threaded.

Apartment-threading, while allowing for multiple threads of execution, serializes all incoming calls by requiring that calls to methods of objects created by this thread always run on the same thread - the apartment/thread that created them.

Multi-threading (also called free-threading) allows calls to methods of objects created by this thread to be run on any thread. There is no serialization of calls - many calls may occur to the same method or to the same object or simultaneously. Multi-threaded object concurrency offers the highest performance and takes the best advantage of multi-processor hardware for cross-thread, cross-process, and cross-machine calling, since calls to objects are not serialized in any way.

We recommend to set OLEINIT = 0 (Multi-Threaded). This allows the most flexibility and provides the best performance for multi-threaded applications. However, some OLEDB Providers may required their OLE Subsystem to be initialized as Apartment-Threaded. If this is necessary, set OLEINIT = 2.

Default - OLEINIT = 0

Not for typical customer usage. Please only set if instructed to by CONNX Technical Support.

OPATTRIBUTES instructs Adabas SQL Gateway to pass a specific attribute string to Adabas on the OP (open) call. Usage:

For example, to set the time zone on the OP call using the TZ attribute to 'America/Vancouver', set the setting value to the following:

This will cause Adabas SQL Gateway to pass the string TZ='America/Vancouver' as an attribute on the OP call.

Default - not set.

If set to 1, this setting instructs Adabas SQL Gateway to bypass the Open User Session call when a client-server connection is established.

Default - OPDONTCALL = 0

If set to 1, this setting instructs Adabas SQL Gateway to issue the OP command with the EXF option. The EXF option makes it so files are opened under exclusive control of the user. No other user will be permitted to access the file while this user session is active. Exclusive control will be given only if no other active user has issued an OP command in which the ACC, EXF, EXU or UPD parameter was specified for the file.

Default - OPEXF = 0

If set to 1, this setting instructs Adabas SQL Gateway to issue the OP command with the EXU option. The EXU option makes it so files are updated under exclusive control of the user. No other user will be permitted to update the file while this user session is active. Exclusive control will be given only if no other active user has issued an OP command in which the ACC, EXF, EXU or UPD parameter was specified for the file.

Default - OPEXF = 0

If set to more than 0, this setting defines the maximum number of command IDs per Open User Session that can be active for a user at the same time.

This value cannot be greater than 1/240 * LQ, where LQ is the ADARUN sequential command table length parameter value, which has a default of 10000.

Default - OPMAXCMDID = 0

If set to more than 0, this setting defines the maximum number of records per Open User Session that a user can have in hold status at the same time. The default is the value set by the ADARUN NISNHQ parameter, and the maximum is 1/4 the value set by the ADARUN NH parameter minus 1, or 65535, whichever is smaller.

Default - OPMAXHOLD = 0

If set to more than 0, this setting defines the maximum number of ISNs per Open User Session that can be stored in the internal ISN element table resulting from the execution of an Sx command. Increasing the default setting decreases access to the Adabas Work dataset. The maximum allowed is 1000.

Default - OPMAXISN = 0

For Adabas, this setting determines the non activity timeout for adabas calls.

Default - OPNONACTIVITY = 65535

If set to 1, this setting instructs the Adabas SQL Gateway Open User Session logic to request an access-only user session. Read-only users can not issue hold, update, delete, add record, ET (End Trasaction), or BT (Backout Transaction) commands.

Default - OPREADONLY = 0

If set to more than 0, this setting defines the maximum amount of time in milliseconds permitted for the execution of an Sx command per Open User Session.

Default - OPSEARCHTIME = 0

For Adabas, if set to more than 0, this setting provides a user-specific transaction time limit in milliseconds for the Open User Session call. The limit must conform to the maximum specified by the ADARUN parameter MXTT. If this field contains binary zeros, the transaction time limit specified by the ADARUN TT parameter for the Adabas session is in effect.

Default - OPTIMEOUT = 0

Set this to 1 to indicate that Oracle does not use Bulk mode.

Default - ORACLEBULKMODEDISABLEDFLAG = 0

This Unix-only setting contains the location of both the Oracle client libraries and the tnsnames.ora file.

This is usually set to $CNXDIR/lib32, where CNXDIR is the location of the CONNX Client install for UNIX.

This setting defines the size of the message buffer between the CONNX32.dll file and the database servers. Acceptable values are 4096 to 32000.

Default - PACKETSIZE = 8192

CONNX supports the ability to logically combine multiple identically structured Adabas databases and allow them to look and act like a single database. This number represents the number of parallel databases in addition to the main current database.

Default - PARALLELDATABASECOUNT = 0

This is a server setting and only affects Adabas. On Windows, this setting is set in the configuration manager under the CONNX\Adabas key. In Linux/Unix, PARALLELDATABASECOUNT is an environment variable.

PARALLELDBID is used in conjunction with PARALLELDATABASECOUNT. This value assigns a number from 001 to 999 to each parallel Adabas database ID being used.

Usage: PARALLELDBIDnnn=DBID where nnn is a number from 001 to 999.

This is a server setting and only affects Adabas. On Windows, this setting is set in the configuration manager under the CONNX\Adabas key. In Linux/Unix, PARALLELDBID is an environment variable.

Example: If database IDs 134 and 135 are used as parallel databases, two environment variables are defined: PARALLELDBID001=134 PARALLELDBID002=135.

CONNX supports the ability to logically combine multiple identically structured Adabas databases and allow them to look and act like a single database. In the situation where data is physically stored in files separated by quarters (FY 22 Q1, FY 22 Q2, etc), this number represents the number of file numbers to advance for the next quarter.

Default - PARALLELQUARTEROFFSET = 0

This is a server setting and only affects Adabas. On Windows, this setting is set in the configuration manager under the CONNX\Adabas key. In Linux/Unix, PARALLELQUARTEROFFSET is an environment variable.

If set to 1, this setting causes CONNX to issue PeekMessage commands while waiting for TCP/IP commands to asynchronously complete. This setting is required only by some non-Microsoft TCP/IP stacks and is only revelant to them.

Default - PEEKMESSAGE = 0

If set to 1, range checks are performed on the data fields that are used during inserts and updates.

Use this setting to change the default CONNX JDBC server port.

Default - PORT = 7500

If set to 1, this setting enables you to override the default SQL precision in the CONNX Data Dictionary for packed fields.

Default - PRECISIONOVERRIDE = 0 (override turned off)