RE: Record name the same as the file name

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

I swear I tried that.... I'm really surprised.  I guess I assumed that since
you couldn't use an index LF in a select statement, that it would not work
in RPG.  Thanks Brian.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Thursday, August 21, 2003 1:19 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Record name the same as the file name






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.



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