RE: SQL pre-compiler & the new Template keyword

[Gina M Whitney <whitneyg@xxxxxxxxxx>]

How are you bringing in the copybook?  /INCLUDE is not opened by the
precompiler.  The precompiler also doesn't open nested copybooks.
Try compiling with RPGPPOPT(*LVL2) on the CRTSQLRPGI command.


Thanks,
Gina


> message: 5
> date: Wed, 6 Apr 2011 11:28:24 -0500
> from: Kurt Anderson <kurt.anderson@xxxxxxxxxxxxxx>
> subject: RE: SQL pre-compiler & the new Template keyword
>
> Alan, that's good to hear.
> I guess my next step is to see if we can get the latest PTF cume (we are
never up to date on them).  But even so, I found a handout by >Barbara
Morris stating that the SQL Precompiler, " Supports all the new features in
ILE RPG V6R1."  Which means I either have a code >issue, or I need to open
a PMR.
> I'll give some more detail (as it turns out the caveat I previously
mentioned wasn't exactly what's happening in my situation).
> I have a copybook with the following D-spec.
>      //  Shared Templates
>     D dsTmpl_CalTypTID...
>     D               E DS                  Qualified Template
>     D                                     ExtName( 'CALTYPTIDP' )
>
> In the service program module, I have the following code, which does
compile:
>     D ds_CalTypTID  E DS                  ExtName( CalTypTIDP ) Qualified
>     D                                     Dim( MAX_BLOCK_READ )
>
> However what I want is this, which does not compile (due to SQL below).
The Verifier says this is ok for the rest of the RPG code.
>     D ds_CalTypTID    DS                  LikeDS( dsTmpl_CalTypTID )
>     D                                     Dim( MAX_BLOCK_READ )
>
> The SQL that uses this DS based on a Template that is failing in the
pre-compile is this:
> Exec SQL
>  Fetch CalTypTIDPCursor FOR :epMaxRead ROWS into :ds_CalTypTID;
>
> Precompiler listing:
> DS_CALTYPTID                     53
> DS_CALTYPTID                     ****     1098
>
> SQL5011  30    1098  Position 59 Host structure array DS_CALTYPTID not
>                     defined or not usable.
>
> Thanks,
>
> Kurt Anderson
> Sr. Programmer/Analyst
> CustomCall Data Systems