RE: CRTSQLPKG

["Haas, Matt" <Matt.Haas@xxxxxxxxxxx>]

Rob,

I don't know of any way to automatically create them (I think I tried catching 
the SQLCOD and running a command to create them but I remember that not 
working) but they are a requirement. They actually get created as part of the 
object when you compile the program. I don't think you can just move the 
packages from one system to another since they contain things like access plans 
and those can differ depending upon what's installed on each machine.

The basic syntax to create them is CRTSQLPKG PGMLIB/PGM DBNAME. DBNAME is the 
database name in WRKRDBDIRE. If you are doing this for a service program, 
you'll need to prompt it and change the object type to *SRVPGM. You'll also 
need to prompt it if you have to specify a user name and password on the 
connect.

Matt

-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Friday, July 23, 2004 4:30 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: CRTSQLPKG




I have a SQLRPGLE program that does a CONNECT to our various iSeries.  The
problem is that, with the way I currently have it set up, I need a SQL
package distributed to all the systems.  When I recompile the program I
need to redistribute that package to all of our iSeries.
Is there some way to do the CONNECTs and not use a SQLPKG?
If not, what parameters do I use on CRTSQLPKG?

Looks like I'll have to add some post run commands to the Turnover form to
create and/or distribute these SQLPKG's unless I can figure out how to do
without them.

(see also CRTSQLPKG)


Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com




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