RE: Use SQL instead of RPG?

Mike you need to look again.

You _CAN_ do 

Select * from myview
Order by fld1, fld2


But you _CAN'T_ do

Create view myview (select * from mytbl order by fld1, fld2)


HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike the 
> Code Monkey
> Sent: Thursday, May 18, 2006 9:28 AM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: Use SQL instead of RPG?
> 
> We are doing it and we are at V5R3.
> 
> On 5/18/06, Rick.Chevalier@xxxxxxxxxxxxxxx 
> <Rick.Chevalier@xxxxxxxxxxxxxxx>
> wrote:
> 
> > I don't believe you can use the ORDER BY clause with a 
> view.  At least,
> > not at V5R3.  You also can't create an index over a view.  
> Using a view
> > would require two SQL statements.  One for the view and a 
> second select
> > to order the records.
> >
> 
> 
> -- 
> Mike Wills
> koldark@xxxxxxxxx
> http://theriverbendpodcast.com
> 
> Code Monkey like Fritos
> Code Monkey like Tab and Mountain Dew
> Code Monkey very simple man
> - Johnathan Coulton - Code Monkey
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
>