Reference Manual

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

AS/400 Properties Tab

On the

AS/400 Properties

tab in the

PowerExchange Data Source

wizard, enter properties to define a PowerExchange DB2 for i5/OS data source.

Isolation Level: The commit scope of the transaction.

The options are:

ALL

CHG

CS

NONE

RR

This option is typically set to
CS
.

Default is
NONE
.

Corresponding ODBC Parameter: ISOLATION
Library List (Unqualified Table): Space-delimited list of libraries that PowerExchange searches to qualify the first table name, if the table name is unqualified, on a select, insert, delete, or update statement. You can specify a maximum of 34 libraries. Each library name is a maximum length of ten characters.

If you specify a library list in both the
Library List (Unqualified Table)
and
Table/File Override
boxes, and a table is found in both lists, the table found in the
Table/File Override
list takes precedence.

Corresponding ODBC Parameter: LIBRARYLIST
Table/File Override: Space-delimited list of file overrides in the following format:

filename/newlibrary/newfilename/newmembername

Alternatively, you can use the following format:

filename/newlibrary/newfilename/

In this format, the member defaults to *FIRST.

You can specify a maximum of eight files. Each file specification is a maximum length of 43 characters, as follows:

Ten characters for the filename value
Ten characters for the newlibrary value
Ten characters for the newfilename value
Ten characters for the newmember value, if specified
Three characters for the slash (/) separators

When you use this override, any occurrence of the specified file name in a SQL statement is overridden with the newlibrary/newfilename/newmembername combination, regardless of whether the file is qualified or not. This includes any files that are specified in the
Library List (Unqualified Table)
override.

If you specify a library list in both the
Library List (Unqualified Table)
and
Table/File Override
boxes, and a table is found in both lists, the table found in the
Table/File Override
list takes precedence.

Corresponding ODBC Parameter: OVRDBF