Re: Creating SQL Stored Procedures and Trigger programs without DB2 Query 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