Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

AS/400 Properties Tab

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