Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Object names in configuration files

You can specify table and column names in several parameters within a High-speed Apply Engine configuration. This section describes the table-name format and wildcard usage for table and column names.

Table names

Several configuration parameters require you to specify table names. The tables that you specify must already exist.

You can specify a table name in one of the formats shown in the following table.

Format

Description

owner.tableName

To fully qualify a table name, specify the owner and table name, as follows:

  • The owner is the user ID of the table owner.

  • The period is a required separator.

  • The tableName is the DB2, DB2 LUW or Oracle table name.

tableName

If you specify a table name without an owner, High-speed Apply Engine uses the user ID that runs the apply request as the owner of the table.

Note

The TableName parameter in the [Restart] section accepts a table name, a DB2 alias, a DB2 synonym or an Oracle public synonym. For more information, see TableName.


Delimited table names

The High-speed Apply Engine accepts ordinary or delimited table names. If you include special characters in your table names, or if you require lowercase or mixed-case alphabetic characters, you must use delimiters around the table name.

Note

The TableName parameter in the [Restart] section does not accept delimited table names. You must specify the restart table by using an ordinary name, by using a DB2 alias or synonym, or by using an Oracle public synonym.

The following table shows some examples of delimited table names. The use of delimiters must conform to the following rules:

  • High-speed Apply Engine supports single ( ' ) or double ( ' ) quotation marks as delimiters.

  • The owner and tableName are distinct nodes, and they can be delimited separately. If the entire name is delimited, it will be qualified with the current user ID for the apply request.

  • The first delimiter that is encountered will be recognized for the node, and it must be matched by the same delimiter.

  • Wildcard characters must be outside of the delimiters to be recognized.

Delimited name

Resolved name

'XYZ's'.'TableA'

XYZ's.TableA

XYZ''s.TableA

(not delimited)

XYZ's.TABLEA

'A DAY.MONTH'

owner.A DAY.MONTH

'A DAY'.??'NTH'

A DAY.MONTH

or

A DAY.NINTH

Wildcards in object names

Some parameters allow you to specify a set of database objects by using wildcard characters as part of a table or column name.

The High-speed Apply Engine supports the wildcard characters shown in the following table. For more information, see Using wildcards to map object names.

Character

Description

*

The asterisk represents a string of zero or more contiguous characters.

%

The percent sign represents a string of zero or more contiguous characters.

?

The question mark represents a single character.

Long object names

In later versions of DB2, the maximum lengths of DB2 object names are increased from previous versions. The High-speed Apply Engine supports the maximum currently usable name length for all DB2 objects.

Was this page helpful? Yes No Submitting... Thank you

Comments