Re: CRTSQLPKG

I'd like to add to this question:

Must the SQLPKG on the remote system exist in the same
library as the SRVPGM on the local system?

Phil
> This is a multipart message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> I have a SQLRPGLE program.  It connects to a remote system and then does
> some work.  However I get the SQL0805 message about the CRTSQLPKG.  Was I
> correct in thinking that I have to:
>  copy my service program to the remote machine,
>  run CRTSQLPKG PGM(ROUTINES/SRVPGM) OBJTYPE(*SRVPGM)
> ?
> This worked.  However, what happens if I see no need to have this service
> program on the remote machine?
>
> Also, if I make a minor change, one that doesn't even generate a new
> signature, I still have to copy the new program over to the remote and
> rerun the CRTSQLPKG or I get another SQL message, SQL0818.
>
>       * CRTSQLRPGI OBJ(ROUTINES/SRVPGM) OBJTYPE(*MODULE) COMMIT(*NONE)
>       *            TGTRLS(V5R1M0) SRCFILE(ROUTINES/QRPGLESRC)
> DBGVIEW(*SOURCE)
>       * CRTSRVPGM  SRVPGM(ROUTINES/SRVPGM) TGTRLS(V5R1M0) BNDDIR(QC2LE)
>       *            ACTGRP(SRVPGM) SRCFILE(ROUTINES/QSRVSRC)
>
>
> Rob Berendt
> --
> "They that can give up essential liberty to obtain a little temporary
> safety deserve neither liberty nor safety."
> Benjamin Franklin
> _______________________________________________
> 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.
>