Re: Free form SQL

No. Not dumb questions at all.

The member type is SQLRPGLE but I WAS compiling with *PRV so you get the bonus points. However, that wasn't the problem. The actual problem was that the PTF's hadn't been applied at all. I thought I was looking up the correct PTF's but apparently I was more burnt out yesterday than I thought because today the link I referenced gave me a list of PTF's that I didn't have. I applied them and all is well. That link, for future reference, is:

http://www-1.ibm.com/support/docview.wss?uid=nas38a889974f48e82dd862572ba00527b4f

However, your pointer on *PRV probably saved me much time since I would have never thought to compile *CURRENT (*PRV is the default) and would have chased my tail even further.

Thanks, Mr. Know-it-all!

Pete

Vernon Hamberg wrote:

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