Re: Creating SQL Stored Procedures and Trigger programs without DB2 Query Manager and SQL Development Kit...

On 21/09/2009, at 2:10 PM, Steven Harrison wrote:

I'm working in an environment that does not have the DB2 Query Manager
and SQL Development Kit so we can't embed SQL into our RPG and C
applications. I have recently been working on a project where I thought
a trigger program would be very useful. After doing a bit of research I
found that SQL trigger programs are created in the background with the
CRTSQLCI command which is the C SQL pre-compiler (part of the
development kit).

Under the covers there is sufficient C/SQL support to create stored procedures but not enough to compile your own C programs with embedded SQL.

I was therefore very surprised that when I went into Operations
Navigator to attempt to create a SQL trigger it worked??? I even found a
number of sources that explicitly claim that SQL Stored Procedures and
Trigger programs can not be created without the SQL Development kit so
I'm wondering if anyone has any idea why I am able to do this?

See above. Normal situation.

I'm
certainly not complaining because it's nice to have the extra
functionality but I would like to know why this is possible? If I try
and run CRTSQLCI from the command line it of course fails but Operations
Navigator seems to be successfully using the pre-compiler? We are
running on V5R3.



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?

The pre-compilers are an option but usually supplied as part of a new hardware purchase by forward-looking business partners. I think most of the Express software editions include SQL. Still chargeable but 'hidden' in the initial purchase cost. If your company has owned iSeries systems for years and did not request SQL then it will not automatically be included in later upgrades. You'll need to talk to a business partner about the gory details.


Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists

http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------