Re: Record name the same as the file name

[rob@xxxxxxxxx]

I stand corrected.  Ok, I'll run with your nudge as to what I must have
been originally thinking:  Trying to use the view, with the index.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                                                                                
                                                        
                      "Brian Parkins"                                           
                                                        
                      <PARKIB@xxxxxxxxxx        To:       RPG400-L@xxxxxxxxxxxx 
                                                        
                      >                         cc:                             
                                                        
                      Sent by:                  Fax to:                         
                                                        
                      rpg400-l-bounces@x        Subject:  Record name the same 
as the file name                                         
                      idrange.com                                               
                                                        
                                                                                
                                                        
                                                                                
                                                        
                      08/21/2003 01:03                                          
                                                        
                      PM                                                        
                                                        
                      Please respond to                                         
                                                        
                      RPG programming on                                        
                                                        
                      the AS400 /                                               
                                                        
                      iSeries                                                   
                                                        
                                                                                
                                                        




>>>A logical file created with CREATE INDEX cannot be
>>>specified as the file in an RPG program using native access.

Yes it can.  The following works just fine - BUT the entire record is
presented since the INDEX has the same record format as the TABLE.

  // 1). CREATE TABLE MYLIB/MYTABLE (DEPTCODE CHAR (2 ) NOT NULL WITH
  //       DEFAULT, DEPTNAME CHAR (15 ) NOT NULL WITH DEFAULT)
  // 2). CREATE INDEX MYLIB/MYINDEX ON MYTABLE (DEPTNAME ASC)
  // 3). Populate with a few records

FMyIndex   IF   E           K Disk
D KeyArg          S                   Like(DeptName)
 /Free
   KeyArg = 'PERSONNEL';
   SetLL KeyArg MyIndex;
   Read MyIndex;
   Dsply DeptCode '*REQUESTER';
   *InLR = *On;
 /End-Free


Brian Parkins

_______________________________________________
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.