My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.