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.

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,

In your stored procedure you can do what you are currently doing with the &&KILL_RPC='Y', or you can

-SET &&CM__RETURN=XXX;

Where XXX is any return code you want the process to end with.