Re: Free form SQL

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