Direct link to fix
APAR status
Closed as program error.
Error description
When IBM Process Federation Server is configured to federate a system that uses a DB2 Z/OS database, the following SQL syntax error is reported by the indexer at runtime: SQLCODE=-126, SQLSTATE=42829 (com.ibm.db2.jcc.am. : THE SELECT STATEMENT CONTAINS BOTH AN UPDATE CLAUSE AND AN ORDER BY CLAUSE) PRODUCTS AFFECTED IBM Business Automation Workflow IBM Business Process Manager
Local fix
Problem summary
No additional information is available.
Problem conclusion
A fix is available or will be available that fixes the SQL syntax error when indexing federated data from a DB2 Z/OS database.
Temporary fix
Not applicable.
Comments
APAR Information
APAR number
JR64800
Reported component name
BUS AUTO WORKFL
Reported component ID
5737H4100
Reported release
K00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-04-05
Closed date
2022-04-15
Last modified date
2022-04-15
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
BUS AUTO WORKFL
Fixed component ID
5737H4100
Applicable component levels
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"20.0.0.1"}]
Document Information
Modified date:
16 April 2022