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

[Alan Campin <alan0307d@xxxxxxxxx>]

They check to make sure you are not doing this. There may be someway to get
around it but I don't know of one.

You can use the CLI interface. Don't need the precompiler for that but all
queries are dynamic which may or may not mean anything since the system
caches the run time plans or at least as long as you are using the new query
engine.

On Mon, Sep 21, 2009 at 10:30 AM, Steve Richter <stephenrichter@xxxxxxxxx>wrote:

> On Wed, Sep 2, 2009 at 9:21 AM, Vern Hamberg <vhamberg@xxxxxxxxxxx> wrote:
> > Steve
> >
> > Basically, to deVELop anything using SQL in RPG, you have to have the
> > licensed product. Everything involves embedded SQL in some way.
>
> Is it possible to call the SQLROUTE program the same as the code
> emitted by the sql precompiler does?   Looking at that compiler
> listing code I see that the return values from the SQLROUTE call are
> available in a variable passed as a program parameter.  Problem is
> that the text of the sql statement passed to SQLROUTE is not visible
> in the compiler listing.
>
> Likely that information is stored in the associated space of the
> module/or program.  I was just experimenting with calling
> QbnRetriveAssociatedSpace from an SQLRPGLE program. where call level
> is 0 and associated space identifier is *PREPROC.
>
> http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/topic/apis/qclras.htm
>  Was hoping to see contents of the SQL statements that the rpg sql
> program prepares and executes. Instead I get an error - CPF5D24 (
> unexpected error during preprocessor processing ).
>
> - another Steve
> --
> This is the RPG programming on the IBM i / System i (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.