CRTSQLPKG

[rob@xxxxxxxxx]

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