Creating Stored Procedure in iSeries Navigator

[Guest.Visitor]

I am creating a stored procedure with 5 input parameters and returning one recordset. I have checked the SQL statement in iSeries Naviagtor and it works fine but when placing those statement in Create SQL Procedure, it fail. Error is shown below. Using V5R2 and have 5722-ST1 installed. Thanks Shafiq

---

Code