Uppercase and lowercase letters
The numbers 0 to 9
Spaces
The following special characters:
’ - ; # \ , . / ! % & * ( ) _ + { } : @ | < > ? 
The first character is an apostrophe.

library/
journal

library/
file

No
. Disables offload processing.
Yes
. Enables offload processing.
Auto
. PowerExchange determines whether to use offload processing.

APPBUFSIZE=
app_buf_size.
Specifies the initial size of the application buffer for the connection. Overrides the APPBUFSIZE statement in the DBMOVER configuration file.
CONNECTSTRINGCODEPAGE=
code_page
. Code page of the characters in the connection string. Enter this override if PowerExchange issues message PWX-07610.
LOWVALUES={Y|
N
}. Indicates whether PowerExchange preserves hexadecimal '0' values, called
low values
, in source character fields when passing these values to a PowerCenter session. Enter Y to preserve low values. When the session runs, PWXPC can write these values to a VSAM target on z/OS or to a sequential file target on Linux, UNIX, Windows, or z/OS. Overrides the LOWVALUES statement in the DBMOVER configuration file.
PWXNOQUOTES={Y|
N
}. By default, in the SQL SELECT statements that PWXPC uses to select data for session processing, PWXPC adds double-quotation marks (") around every table name and field name that includes spaces or special characters. These special characters are
/+-=~`!%^&*()[]{}';?,< >\\|
. If a table is identified by both a schema name and table name in the format
schema
.
table_name
, PWXPC places the quotation marks only around the "
table_name
" value.
If for any reason, you cannot use quoted table names or field names in your environment, set PWXNOQUOTES to Y to override the default behavior.
QAQQINILIB=
library_name
Specify the library name on the IBM i (i5/OS) system that contains the QAQQINI query options file. If the DBMOVER configuration file on the IBM i system includes the optional QAQQINILIB statement, this override takes precedence over the value specified in the DBMOVER file. This override only applies to IBM i systems.
RETLOGINFOMSG={
N
|Y}. By default, PWXPC writes PowerExchange error and warning messages but not informational messages to the session log. If you specify RETLOGINFOMSG=Y, PWXPC writes informational messages as well as error and warning messages to the session log.
The RETLOGINFOMSG connection override is equivalent to the Retrieve PWX Log Entries connection attribute.
TCPIP_OP_TIMEOUT=
network_operation_timeout
. A network operation timeout interval in seconds. For more information about this timeout override, see Asynchronous Network Communication.
TCPIP_CON_TIMEOUT=
connection_timeout
. A connection timeout interval in seconds. For more information about this timeout override, see Asynchronous Network Communication.