Deleted condition considered still in use

a problem with a condition on a field he deleted, but the 2E program still says that the condition is in use.

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

Resolution:

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 => [email protected]@OBJ = 1105292 WCX Spare field nbr 2 => [email protected]@OBJ = 1105293 WCX Spare field nbr 3 => [email protected]@OBJ = 1105294 WCX Spare field sts 3 => [email protected]@OBJ = 1105300 WCX Spare field txt 3 => [email protected]@OBJ = 1105291Step4: 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.