RE: CHAIN to an SQL LF?

[CWilt@xxxxxxxxxxxx]

Q. - Create SQL view with keys?
A. - Nope.

Q. - DDS logical file with subset of physical by first char of a particular
field.
A. - maybe.  how about:

If the field isn't too big:

S FIELDA        COMP(GE x'06000000')
   FIELDA        COMP(LE x'06FFFFFF')  

Otherwise:

add an additional field to the logical
   FRSTCH      SST(FIELDA 1 1)

S FRSTCH      COMP(EQ '6')


HTH,
Charles


> -----Original Message-----
> From: Tony Carolla [mailto:carolla@xxxxxxxxx]
> Sent: Tuesday, September 14, 2004 2: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.
>