Re: What installs CRTSQLRPGI

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
On supported products commands may appear in these previous release
libraries (QSYSVvRrMm) even though the program product may not be
installed.  You cannot try to sneak in and run them by qualifying the
library:  QSYSV4R3M0/CRTSQLRPGI.  It won't work.  On other products, (like
fax and service director) I've found that I often have to copy the command
into the previous release library in order to compile to earlier releases.

You have to load 5769ST1 - SQL developers kit.  Or you can convert all the
embedded SQL into SQL Call Level Interface (SQL-CLI).  That's rather ugly,
but it does offer capability to the cheapo's and to people disgruntled
with the precompiler.  You could also try OPNQRYF, traditional record
level access, writing a client program that uses SQL there, farming out
your SQL development to someone with the SQL developers kit loaded,
RUNSQLSTM, STRQMQRY, and a number of other solutions.  Me, I'd recommend
loading 5769ST1, (actually I'd recommend loading V5R2 and 5722ST1).

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Jack Mullins" <jackm@sundash.com>
Sent by: rpg400-l-admin@midrange.com
11/19/2002 09:53 AM
Please respond to rpg400-l

        To:     <rpg400-l@midrange.com>
        cc:
        Fax to:
        Subject:        What installs CRTSQLRPGI


My programmer is working on a mod for one of our ERP programs and the
program type is SQLRPGLE.  When we try to compile, we receive an error
message stating that CRTSQLRPGI can't be found.  I searched the system
for the command and found it on the system from OS releases prior to
V4R4 (our current release) but nothing current.  I suspect that
something isn't installed correctly or at all but I haven't found any
information yet to support my suspicions.  Does anyone on the list have
any ideas?

Thanks,

Jack Mullins
Sun Ergoline, Inc


_______________________________________________
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.