Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] Setting a user defined error code in procedure
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Setting a user defined error code in procedure
 Login/Join
 
Member
posted
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>,


iDM 7.7.05
WebFOCUS 7.7.05
Windows, All Outputs
 
Posts: 11 | Registered: May 25, 2012Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1100 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] Setting a user defined error code in procedure

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.