RE: CHAIN to an SQL LF?

[<Rick.Chevalier@xxxxxxxxxxxxxxx>]

Did you create an index or a view?  Views aren't keyed but indexes are.  I 
don't think you can do selection with SQL views though.

If you need random access to the file there is a substring keyword in DDS that 
should help.  

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Tony Carolla
Sent: Tuesday, September 14, 2004 1:12 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: CHAIN to an SQL LF?


I have a file with a memo field, and I want an LF over this file that
only shows records where the first character of the memo field
contains a '6'.  I dont' know that there is a way to do this using
DDS, so I have built an SQL LF using the RUN SQL SCRIPTS applet over
the file, that only selects records based on this condition.  The
problem is I can't CHAIN to this file because it is non-keyed.

Is there a way to create an SQL LF with 'keys'?  

I don't have the iSeries SQL development LPs either...


-- 
"Enter any 11-digit prime number to continue..."
--
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.