Deleted condition considered still in use

Document ID : KB000076083
Last Modified Date : 17/04/2018
Show Technical Document Details
Introduction:
a problem with a condition on a field he deleted, but the 2E program still says that the condition is in use.
Question:
A customer has a problem with a condition on a field he deleted, but the 2E program still says that the condition is in use.. He has to change the type from TXT to STS but that is now not posssible. He does not want to create another field because this field is already part of a file. He also ran the following commands: YCHKMDL *UPDATE YCHKDTAMDL YCHKMDL *ANALYZE but there where no related errors.
 
Environment:
IBM ISERIES
Answer:
It seems surrogates are hanging in the file “YCNDDTA99L” for the WCX Spare xxxxx fields within the function “WHC EDT Details”.
Follow the below steps to remove these unwanted surrogates, which caused the issue.
Step1: Firstly, take the backup of the Model.
Step2: Open the file YCNDDTA99L in the Model.
Step3: we have Identified the below surrogates of the hanging conditions for the given WCX Spare xxxxxx fields. WCX Spare field nbr 1 => USROBJ.@@OBJ = 1105292 WCX Spare field nbr 2 => USROBJ.@@OBJ = 1105293 WCX Spare field nbr 3 => USROBJ.@@OBJ = 1105294 WCX Spare field sts 3 => USROBJ.@@OBJ = 1105300 WCX Spare field txt 3 => USROBJ.@@OBJ = 1105291
Step4: Remove these “source field surrogates” from the format @PARAM of the file YCNDDTA99L in the Model (Note: Record format should be @PARAM from the file YCNDDTA99L) .
Step5: Zoom into the function “WHC EDT Details” and save the function while exit it.
After this you can able to delete the conditions of these WCX fields and can able to change the field type.