Re: Verifying SQL statement in RPG program.

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

Try putting a C before the +.

On 9/15/06, Alan Campin <Alan.Campin@xxxxxxxxxxxxxxxx> wrote:
> I have SQL statements in an RPG IV program that look like this:
>
>      C/EXEC SQL
>       +  Declare C2 Cursor for
>       +   select a.fitemf, b.wkctrf, sum(a.qtyrcf),
>       +   sum(b.sslhuf), sum(b.slhtdf), sum(b.srlhuf * a.qtyrcf),
>       +   sum(b.rlhtdf), c.pfdsc2
>       +   from cstsum a join labeff b
>       +   on a.ordnof = b.ordnof and a.fitemf = b.fitemf
>       +   join facmstl0 c on b.wkctrf = c.pfidc2
>       +   where a.ostatf between '45' and '55' and a.qtyrcf > 0
>       +   and a.latdtf >= :SDATE and a.latdtf < :LRDATE
>       +   and a.fitemf = :ITEM# and b.opstcf <> 00
>       +   group by a.fitemf, b.wkctrf, c.pfdsc2
>      C/END-EXEC
>
> If I run this program through the compiler, everything compiles fine but
> if I use the verify in WDSC, I get errors on each line with a "+".
>
>      C/EXEC SQL
>       +  Delete from LEADSWRK
> RNF0257: Form-Type entry for main procedure not valid or out of
> sequence.
>      C/END-EXEC
>
> Anyone else running into this? I am up to date with all fixes in V6.0.
>
> --
> This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
> mailing list
> To post a message email: WDSCI-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/wdsci-l.