E-AD: Drop Zones - Getting Error while doing Search on configure Drop Page in DB2 on Z/OS
(Doc ID 2556071.1)
Last updated on OCTOBER 01, 2019
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.
On : 8.57.04 version, Portal Technology
Configure Drop Zones issues in DB2 on Z/OS.
Drop Zone Does not work at all for DB2 on Z/OS. Getting PeopleCode error while doing search on Configure Drop Zone page. PeopleCode error is only happening in MSS and DB2ZOS. Its working as expected in Oracle.
SQL error. Function: CreateSQL Error Position: 0
Return: 0-[IBM][CLI Driver][DB2] SQL0199n The use of the reserved word "WITH" following "WITH" is not valid. Expected tokens may include: "FETCH, ) OFFSET LIMIT INTERSECT ORDER GROUP WHERE HAVING JOIN". SQLSTATE=42601 (SQLSTSTE 42601) - 199
The issue can be reproduced at will with the following steps:
1. Sign onto a system running DB2 on Z/OS
2. Navigate to Root > PeopleTools > Portal > Configure Drop Zones
3. Search for a component - HR_ETHNIC_GRP_% and pop up the Error
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document