Reference Manual

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

Back Next

IBMI_USE_DB2_SYSTEM_OBJECT_NAMES

The IBM_USE_DB2_SYSTEM_OBJECT_NAMES statement controls whether PowerExchange searches both IBM i system object names and SQL object names or only SQL object names for Db2 for i source objects when you create PowerExchange capture registrations in the PowerExchange Navigator or the DTLUCBRG utility or perform database row tests in the PowerExchange Navigator.

Use this statement if you are more familiar with system object names than with SQL object names or if some source tables were renamed causing the system_table_name and table_name column identifiers in the SYSTABLES table to be different.

Object names
include names of schemas and tables.

IBM i

IBMI_USE_DB2_SYSTEM_OBJECT_NAMES={Y|N}

. Search both Db2 system object names and SQL object names when creating capture registrations.

. Search only SQL object names.

Default is

Do not change this setting after you have created active Db2 for i capture registrations.

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

IBMI_USE_DB2_SYSTEM_OBJECT_NAMES

IBMI_USE_DB2_SYSTEM_OBJECT_NAMES