Re: Free form SQL

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Having just come from the RPG & DB2 Summit, I know all!!! NOT!!

The semi-colon comes after the entire statement - only rule otherwise 
is that "exec sql" have to be on the same line, as it shows here.

So it LOOKS OK - Pete, dumb question #1 -- are you sure the member 
type is really SQLRPGLE? This feels like the message I get when 
putting SQL into an RPGLE source type. Or did you use CRTBNDRPG or 
CRTRPGMOD to create it?

Told you, dumb questions from me!

Googled "RNF5347 sqlrpgle" - Scott K and Birgitta have said the same 
thing in a link there - also to be careful about TGTRLS - can't go 
back from V5R3 with this.

Regards
Vern

At 07:03 PM 10/5/2007, you wrote:

> Missing the semi-colon at the end of "exec sql"??
>
> >>> Pete@xxxxxxxxxx 10/05/2007 4:59:58 PM >>>
> I have applied (I think) the correct PTF's on my V5R3M0 270 and I am
> attempting to compile an SQLRPGLE source member that has free format SQL
>
> in it and it is acting like it doesn't know what to do with it.
>
> The error is:
>
>   6161         exec
> sql
> ======>
> aaa
> *RNF5347 30 a      368388  An assignment operator is expected with the
> EVAL operation.
>
> The actual code from the member is:
>
>      c/free
>           if Mode = 'I';
>              exec sql
>              insert into pasa408a
>                     values(:ID,:ADate,:Line1,:Line2);
>           endif;
>
> It throws the RNF5347 error just after the exec sql.
>
> I have some similar code on another V5R3M0 machine that compiles so I
> think this machine must be missing some PTF's or perhaps they were
> applied delayed?
>
> Can't remember the PTF numbers although I think I found them on this
> list (somewhere).  How can I tell if the PTF's are applied (or waiting
> as delayed)? Or, is there some syntax issue?
>
> Thanks,
>
> Pete Helgren