Re: CHAIN to an SQL LF?

[Chris_Bougher@xxxxxxxxxxxxx]

You can do this with DDS.

A                      R RCDFMT        PFILE(PHYSICAL)

A                        FIELD1
A                        FIELD2
A                        MEMO
A                        MMOPFX   I    SST(MEMO 1 1)

A                      K FIELD1
A                      O MMOPFX        COMP(*NE '6')

note that mmopfx is an input-only field


Chris Bougher



                                                                                
                                                        
                      Tony Carolla                                              
                                                        
                      <carolla@xxxxxxxxx        To:       rpg400-l@xxxxxxxxxxxx 
                                                        
                      >                         cc:                             
                                                        
                      Sent by:                  Subject:  CHAIN to an SQL LF?   
                                                        
                      rpg400-l-bounces@m                                        
                                                        
                      idrange.com                                               
                                                        
                                                                                
                                                        
                                                                                
                                                        
                      09/14/2004 02:12                                          
                                                        
                      PM                                                        
                                                        
                      Please respond to                                         
                                                        
                      RPG programming on                                        
                                                        
                      the AS400 /                                               
                                                        
                      iSeries                                                   
                                                        
                                                                                
                                                        
                                                                                
                                                        




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.