Re: Free form SQL

["Roger Harman" <RHarman@xxxxxxxxxx>]

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