Re: Free form SQL

[Pete Helgren <Pete@xxxxxxxxxx>]

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
> >     
>
>