RE: Compile problems with SQL Stored Procedures

<snip>
Alan, I could be wrong but I don't think you can have executable
statements
preceding declares in the routine body, on System i at least.
</snip>

Right you are Elvis.

You cannot have anything in front of the Declares. I just moved the Call
statement after the declares and it compiles fine.

Getting myself confused with RPG where you can put the declare cursor
anywhere before you do the open. With SQL Language, declares have to be
first. Stumbled across in a manual.

Thanks.

Also, as an aside, I implemented the same stored procedure as an RPG/ILE
service program. Man, take about fast. First time I have done this. I
had used service programs to implement user defined functions but didn't
realize until the other day that I could implement stored procedures as
service programs, also.

Nice thing about doing this is you can have multiple procedures in a
single service program to implement multiple stored procedures.

Create Procedure MAPDBA/MRPGETSTATUS
(In InMapicsEnvironment Char(2),
In InItemNumber VarChar(15))
Result Sets 1
Language RPGLE
Not Deterministic
Reads Sql Data
External Name 'MAPDBA/MRP001(MRP_GETSTATUS)'
Parameter Style General;

Create Procedure MAPDBA/MRPEXPLODEBILL
(In InMapicsEnvironment Char(2),
In InItemNumber VarChar(15))
Result Sets 1
Language RPGLE
Not Deterministic
Reads Sql Data
External Name 'MAPDBA/MRP001(MRP_EXPLODEBILL)'
Parameter Style General;