|Shruthi Y S
Joined: 25 Mar 2015
I am new to IMS DB. My requirement is to write a program that deletes specific data from IMS DB. For example, Assume a DB2 table called Worktable. This table has list of employeeIDs, employee names, salaries and so on. My requirement is I have to read the worktable, take every employeeID and delete it from IMS DB. In IMS DB, employeeID is not primary key, but it is secondary index.
To first make sure if my keys are right, I am trying to read these values from IMS DB and write them into a file. If everything is correct then I want to proceed with get hold and deletion.
So I am trying to make a DL/I call with function GU by populating the key values for secondary index employeeID.
It is in the below format :
but I am getting PCB Status AK for this call with segment number 01. I am not understanding what is wrong here. Can anyone please help me?