If set to 1, this setting makes it so QuadWord data types are imported as Double data types for Oracle Rdb.

Default - QUADWORDDOUBLE = 0 (the QuadWordDouble data type is disabled)

This setting determines the value for the DB2 TCP/IP timeout in milliseconds .

Default - READTIMEOUT = 60000 (60 seconds)

The Adabas "OP" command will be re-issued in the event that during query operations it receives an Adabas response response 9 with a subcode of 2 or 3 (on mainframe) or subcode of (OR, or TN) on open systems. When this setting is set to 1, when a timeout is received, ACE will issue a new OP command and then retry the last operation.

Default - REISSUEOP = 0

This setting removes the leading zeroes from field names when importing files into a CDD using file descriptions that have "OCCURS" clauses, like COBOL copybooks, VMS DDL files, and etc.

Default - REMOVELEADINGZEROS = 0

Use this setting to replace prefixes that are attached to COBOL FD imported fields. Usage:

Use REPLACEPREFIX in conjunction with IMPORTPREFIX to exchange the IMPORTPREFIX string with the REPLACEPREFIX string. If IMPORTPREFIX does not exist (or is ""), REPLACEPREFIX replaces the field name. For example:

If the field is "BBB_Customer" and:

the field in the CDD would be "AAA_Customer".

Optional. Sets the default Windows domain for the Online CONNX Suite. If you do not specify a value for this property, you must set the domain of your Windows user when you log on to the Online CONNX Suite, using the format domain\username.

By default the value is empty.

The 32 bit value is used for both the 32 and 64 bit versions of the REST Server. The 64 bit value is ignored.

This setting controls whether CONNX treats a field filled with binary zeros as NULL or as an empty string when converted to SQL. The default behavior is to read a field with all binary zeros as SQL NULL. Set this setting to 1 to read the field as an empty string.

Default - RMSPADDEDNONULLS = 0 (binary zeros are treated as a SQL NULL)

Use this setting to set a single-byte codepage. Usage:

Defaults:

Windows = Native Locale

Mainframe = 37 (EBCDIC)

Unix = 1252

This settings defines the RMS file name path when importing files via the SCT COBOL FD files option. Usage:

Example:

There is only one entry for this setting.

This setting specifies whether or not a file will be set to enabled if it is in a disabled state under CICS. This setting applies only to CICS.

Default - SETENABLED = 1

This setting specifies whether or not a file will be set to open if it is in a closed state under CICS. This setting applies only to CICS.

Default - SETOPEN = 1

This setting controls the number of logical connections mapped to a physical connection. Usage:

This setting is ignored if SHARECONNECTIONS = 0

Default - SHARECONNECTIONCOUNT = 5

This setting enables or disables connection sharing. This setting is affected by SHARECONNECTIONCOUNT.

If more than one connection is made on the same computer, using the same user ID and password, CONNX makes a single physical connection to the server instead of creating multiple connections.

Default - SHARECONNECTIONS = 2

The maximum expression length to send to the SIS expression optimizer.

Default - SISWORDCOUNT = 1000.

Under the main CONNX key.

This setting is for the client only.

This setting determines the length of time in milliseconds that CONNX waits for the TCP/IP stack to initialize. This setting only applies to non-Microsoft TCP/IP stacks on the client computer.

Default - SOCKETPAUSE = 0

Whenever possible, CONNX does an implicit data conversion when it encounters data that is not represented as the type required. For example, if a character field is being returned as a number, the value 'ABC123' will be automatically converted to 123. The value 'ABC' as a number however, has no meaning and a 0 will be returned.

In some situations, the preferred behavior would be to return an error rather than a 0. When set to 1, STRICTCONVERSIONRULES makes it so an error is returned when a conversion is not valid.

Default - STRICTCONVERSIONRULES = 0

If set to a value of 1, the Text -> Integer and Signed Overpunch datatypes will return NULL if the data is not strictly numeric.

Default - STRICTNUMERICDATA = 0

If STRICTNUMERICDATA = 1, the value 1a34 returns NULL.

If STRICTNUMERICDATA = 0, the value 1a34 returns 0.

Use this setting to give CONNX a hint on how to report the query plan when {statistics} is used.

Some queries that have a sub query may use a less optimized query plan if the sub query returns more than one row. In this case, CONNX will automatically switch to the correct query plan at runtime, but the query plan reported by the {statistics} function may not be the same as the plan which was ultimately used. If you find that the query plan reported by {statistics} is different than what is being used at runtime due to multiple rows being returned in a sub query, set SUBQUERYROWESTIMATE to a value greater than 1.

The query plan will only change at run time if returning multiple rows in a sub query will return duplicate rows. For example, if an Adabas sub query uses a PE index and the sub query only returns 1 row, the PE index can be used. If the sub query returns multiple rows however, duplicates would be returned, so CONNX must switch to a different query plan at runtime. Since the {statistics} function does not know the number of rows that will be returned, it is possible that it will return a query plan that is different than the one that will ultimately be used.

Default - SUBQUERYROWESTIMATE = 0

For non-MU fields, this setting enables the import feature to include a superdescriptor, so that it appears as a field in the CONNX Data Dictionary. The superdescriptor field is read-only.

Default - SUPERDESCRIPTORASFIELD = 1