Search

Reference Manual

Reference Manual

10.5.6
- 10.5.5
- 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

Conditions Skipped by the Optimized Read Process

Conditions Skipped by the Optimized Read Process

PowerExchange sends messages that report skipped conditions to the PowerExchange Listener log file, unless the REPORT_UNUSED_OPT_READING_CONDITIONS statement in the DBMOVER configuration file is set to N.

Skipped Condition Types	Message Reported	Example
Conditions that are not a BASIC or LIKE condition	PWX-3071	AND COL2 NOT NULL
Conditions that do not specify one operand as a column and one operand as a constant	PWX-3072	AND COL2 <> COL3 AND 2 = 2
NOT LIKE conditions	PWX-3073	AND COL2 NOT LIKE 'ABC%'
LIKE conditions that include wildcards	PWX-3074	COLUMN1 LIKE '%' COLUMN1 LIKE '_'
Conditions with not equals operands	PWX-3075	AND COL2 <> 123 AND NOT COL2 = 123
Conditions with NUMCHAR columns	PWX-3076	-
Conditions with columns that have scale	PWX-3077	-
Conditions with LE, LT, GE, or GT operands that also have integer columns on LINUX or Windows machines	PWX-3078	On Linux and Windows, PowerExchange can perform optimized reading on DISAM files by using KSDS maps. However, the results will be incorrect for range conditions that include the column types of NUM16, NUM32, and NUM64.
Conditions that have a negative constant with an unsigned numeric type	PWX-3079	-
Conditions that have a negative constant and an unsupported database type and field type	PWX-3080	-
Conditions with a constant that has scale	PWX-3081	AND COL2 = 1.23
Conditions with an Adabas constant that has a scale that does not match the field scale	PWX-3082	-
Conditions with floating point constants or columns	PWX-3083	AND COL2 = 123E10
Conditions with long numeric constants	PWX-3084	A negative numeric constant with 31 digits.
Conditions with DATE columns	PWX-3085	DATE columns are supported for Adabas maps, but not for Datacom, IDMS, IMS, or VSAM KSDS
Conditions with columns that have unsupported data types	PWX-3086	The following data types are not supported: Variable-length types, such as VARBIN, VARCHAR, BLOB, or CLOB FLOAT and DOUBLE TIME and TIMESTAMP
LE or LT conditions that have negative constants but do not have a matching GE or GT condition	PWX-3091	LE or LT and GE or GT conditions that have negative constants are allowed only if both limit ranges are negative and explicitly set in the SQL WHERE clause. The limit conditions affect only the primary key column.
GE or GT conditions that have negative constants but do not have a matching LE or LT condition	PWX-3092	LE or LT and GE or GT conditions that have negative constants are allowed only if both limit ranges are explicitly set in the SQL WHERE clause and both are negative. The limit conditions affect only the primary key column.
LE and LT or GE and GT conditions that have both negative and positive constants but do not have a matching LE or LT condition	PWX-3093	Range conditions must have both a high and low limit. The read process discards range conditions that are missing either the high or low limit.

Optimized Read Process for Nonrelational Data Sources

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.