Re: [Bulk] Where does CRTSQLRPG store the text of SQL instructions?

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Of course you see the source of the SQL statement - what do you think

SELECT COUNT(*)

is, other than the beginning of a SELECT statement? The rest of the 
statement is on the following lines.

HTH
Vern

On 11/30/2011 10:34 AM, Mark S. Waterbury wrote:
> Hi, Steve:
>
> It is stored in the primary associated space of the program object.
>
> To see it, issue:
>
>       DMPOBJ    OBJ(yourlib/yourpgm) OBJTYPE(*PGM)
>
> Then issue WRKSPLF to view the QPSRVDMP spool file listing and search
> for "ASSOC" ...
>
> HTH,
>
> Mark S. Waterbury
>
>   >  On 11/30/2011 10:42 AM, Steve Richter wrote:
> > When CRTSQLRPG runs it places the converted SQLRPG ->   RPG code in a srcmbr
> > in QTEMP/QSQLTEMP. When I look at the QSQLTEMP code I don't see the text of
> > the sql instructions. Just a call to SQLRT.
> >
> > How is it I can compile and run the source in QSQLTEMP without the sql
> > instruction text being passed to any of the SQL processor programs?
> >
> > this is the rpg code in QSQLTEMP that runs the SQL instruction:
> >
> >       C*EXEC SQL
> >       C*    SELECT          COUNT(*)
> >       C*    INTO            :VCOUNT
> >       C*    FROM            BOLMSTRH
> >       C*    WHERE           BOL2DH = :VBOL2D
> >       C*END-EXEC
> >       CL0                   Z-ADDVBOL2D    SQL005
> >       CL0                   Z-ADD-4        SQLER6            1
> >       CL0                   CALL SQLRT
> >       CL0                   PARM           SQLCA
> >       CL0                   PARM           SQL000
> >       CL0         SQL004    IFEQ '1'
> >       CL0                   Z-ADDSQL006    VCOUNT
> >       CL0                   END