This page lists all the environment variables that Mainframe Connector supports. Depending on the version of the Mainframe Connector, some variables might not be supported. For more details, see the Available from version column in the following table.
Name | Default value | Available from version | Description |
---|---|---|---|
|
True |
5.8.0 | Trims the whitespace at the end of strings. Note that strings that consist only of whitespaces are treated as empty strings. |
|
False |
5.11.0 | Enables support for variable-length character strings when set to True. |
|
-LEN |
5.11.0 | Relevant if BQSH_FEATURE_VARIABLE_LENGTH_ENABLED is set.
Represents the suffix of the first parameter in the variable-length
character struct. By default, the suffix is -LEN . If you want
to use a different suffix, set this environment variable to the suffix of
your choice.
|
|
-TEXT |
5.11.0 | Relevant if BQSH_FEATURE_VARIABLE_LENGTH_ENABLED is set.
Represents the suffix of the second parameter in the variable-length
character struct. By default, the suffix is -TEXT . If you want
to use a different suffix, set this environment variable to the suffix of
your choice.
|
|
- | 5.11.0/5.13.0 |
(5.13.0 and onwards) Sets the values for the date, timestamp, and null
indicator data types.
Use the following format to set the null indicator: SUFFIX_NULL_INDICATOR_NAME="command --null-value NULL_VALUE --not-null-value NOT_NULL_VALUE"
Use the following format to set the date and timestamp: SUFFIX_SUFFIX_NAME="command --format FORMAT --timezone TIMEZONE"
For more information, see Support for date and timestamp fields and Support for null indicator fields. (5.11.0 and onwards) Sets the values for the date and timestamp data types. You can set this environment variable to any value in the following format: SUFFIX_SUFFIX_STRING="--bqtype TYPE --format FORMAT --timezone TIMEZONE"
|
|
True | 5.12.0 | Replaces hyphens in the field names in the COPYBOOK to underscores in the corresponding field names in BigQuery. |
|
True | 5.12.0 | Exports strings with a length of 0 as null to BigQuery.
If you set BQSH_FEATURE_EMPTY_STRING_AS_NULL to false,
then an empty string remains as an empty string when it is exported to
BigQuery (an empty string won't be set to null). |
|
False | 5.12.1/5.13.0 | (5.13.0 and onwards) Lets you enforce stricter error handling, as follows:
(5.12.1 and onwards) Lets you enforce stricter error handling, as follows:
|
|
True | 5.13.0 | Specifies that values containing only nulls (0x00), spaces (0x40), or
high bytes (0xFF) should be decoded as null, and not throw an error for
packed decimal and zoned decimal types. This flag only has an effect if
BQSH_FEATURE_FAIL_ON_INVALID_DATA is set to true. Otherwise, it
does not impact the behavior of the decoders or encoders. |
|
False | 5.13.0 | Increases or decreases the window size of the HTTP/2 flow control. |