(no subject)

["Phil" <sublime78ska@xxxxxxxxx>]

I created a stored procedure called sp_pgm on as400a using ops_nav.

On as400b I am calling it with this rpg pgm, called test_sp:

     D error           s              1
     D
     C/exec sql
     C+ set connection as400b user :user using :pwd
     C/end-exec
     C
     C/exec sql
     C+ declare p1 procedure(:error inout char(1))
     C+   (external name testlib/sp_pgm
     C+     language RPG
     C+     simple call)
     C/end-exec
     C
     C/exec sql
     C+ call p1(:error)
     C/end-exec
     C
     C                   eval      *inlr = *on

I get an error that says SQLPKG TEST_SP doesn't exist in testlib on as400b.
For stored procedures to work, must the same library exist on both as/400's?

Am I missing something obvious?

TIA,

Phil