As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
I have a process flow that goes through a set of input files to verify that the files seem correct. It verifies the formats of files, whether or not the files are expected, whether or not the data in the file is appropriate, and also some other checks. During the various processes that verify the files, a file is created that lists each file and whether or not there is an issue with it.
The last step of the process flow is a call to a iDM stored procedure. The stored procedure looks at the verification file to see if there were any errors. If none of the files had any verification errors, this process flow should end successfully. However, if there are any errors at all, the procedure moves the files from the current location and puts them into an error location. It then creates a CSV file in that same location that has each file listed and what error, if any, occurred. The last thing I want to happen is for the flow to finish with an error.
This is where I am having issues. I tried to set &RET_CODE to a value other than zero, but it doesn't appear to cause the flow to think the process erred out. I can set the &KILL_RPC to a Y. That seems to do the trick, but I an not sure if this is the best way to go about it.
I am pretty new to IBI tools. Eventually, this process flow is going to be called from iSM. If this verification flow finishes successfully, then the iSM process is going to call the next flow to actually load the data. So, I need to make sure that the iSM process knows whether or not an error occurred in the verification step.
Any and all help would be greatly appreciated.
ThanksThis message has been edited. Last edited by: <Kathryn Henning>,