RE: Free format vs SQL

["Smith, Nelson" <NSmith@xxxxxxxxxxx>]

Why couldn't we have an SQL BIF?

> -----Original Message-----
> From: boldt@ca.ibm.com [SMTP:boldt@ca.ibm.com]
> Sent: Friday, September 07, 2001 11:33 AM
> To:   rpg400-l@midrange.com
> Subject:      Re: Free format vs SQL
>
> rob wrote:
> >Any chance of them allowing
> >/exec-sql
> >...
> >/endsql
> >
> >within the free format?
>
> Yeah, allowing embedded sql within /free blocks would be
> nice.  Personally, I'd like to see something like:
>
> /free
>    DoStuff(abc);
>    level Ð'better than today';
>    sql declare c cursor for
>         select fld1, fld2
>         from myfile
>         where rpgsqlsupport Ð:level;
>    sql fetch c into :f1, :f2;
>    DoMoreStuff(f1:f2);
>    etc();
> /end-free
>
> (It's fun to daydream, isn't it?)
>
> Hans Boldt, ILE RPG Development, IBM Toronto Lab, boldt@ca.ibm.com
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.


************************************************************************************************************************************************************************************************************
This message originates from Lincare Holdings Inc. It contains information 
which maybe confidential or privileged and is intended only for the individual 
or entity named above.
It is prohibited for anyone else to disclose, copy, distribute or use the 
contents of this message.
All personal messages express views solely of the sender, which are not to be 
attributed to Lincare Holdings Inc., and may not be copied or distributed 
without this disclaimer.
If you received this message in error, please notify us immediately at 
MailAdmin@lincare.com or (800) 284-2006.
************************************************************************************************************************************************************************************************************