Stored procedure called from RPG

[schmittyse]

I am writing a stored procedure in RPG that contains a query that contains other stored procedures defined in QGPL. The program doesn't find the stored procedures even though they are in qgpl. Qualifying the stored procedure causes a compile error. Can stored procedures be called from RPG embedded SQL?

[B.Hauser]

Re:Stored procedure called from RPG

Hi, what naming are you using? SQL or System-Naming. I assume you are working with SQL naming. If so, the library list is not automatically scanned. You have to set the libraries (schemas) with an SET PATH statement. SET PATH *LIBL or SET PATH LIB1, LIB2, ... LIBN Birgitta