Re: (no subject)

["Ren Fu Ping" <fupingren@xxxxxxxx>]

Guys,
       please provide me some RPG/400 web site to study. especially RPG400 
sample. thanks!

Ping

----- Original Message -----
From: "Phil" <sublime78ska@attbi.com>
To: "RPG400-L" <RPG400-L@midrange.com>
Sent: Thursday, April 04, 2002 9:54 AM
Subject: (no subject)


> 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
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>