Thanks for the informative responses. One more quick question... So I
can create the stored procedure. Is there a simple means to call this
from an RPG program or do I need the Development Kit to embed the CALL
command? (Note: I'm aware of the CLI APIs but was wondering if there was
an easier means?)
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: Wednesday, 2 September 2009 2:28 PM
To: RPG programming on the IBM i / System i
Subject: Re: Creating SQL Stored Procedures and Trigger programs without
DB2Query Manager and SQL Development Kit...
Hi Steve
In addition to Simon's comments, see inline -
Steven Harrison wrote:
Hi all,
-snip-
As a side note, I'm relatively new to the iSeries environment but it
seems strange that if IBM are pushing SQL as the new standard for
iSeries (to replace RPG IO and DDS) that the SQL pre-compilers are not
part of the standard iSeries package? Does anyone know if there is any
push to make them part of the standard operating system?
Putting support in place for creating stored procedures and SQL triggers
and probably user-defined functions is part of the strategy to make SQL
more usable. Those items also used to require the development kit.
Another item IBM have put into general distribution is the RUNSQLSTM
command - that also used to require the SQL SDK.
The precompilers are required only on a box where the programs are
created - they are not needed to run those programs on any box, because
the database stuff IS in the OS. So many companies, I believe, get a
smaller development box and get the SQL SDK fairly cheap, then
distribute programs to the more expensive production boxes.
Of course, all iSeries and AS/400 and all have always had the query
management objects and commands - things like QMQRY and QMFORM objects -
these can be used and created and all without the SDK at all. Of course,
they don't give you embedded SQL, but you are able to run any kind of
SQL statement with them.
I do agree with you, however - I've also wondered why IBM do not take
the extra step to help things with providing the precompilers - of
course, they do have to recoup expenses, so the cost would probably be
wrapped up in a slightly more expensive OS cost. ;-)
Vern
Cheers,
Steve
midrange.com
