RE: Error in EXTFILE

[Jerry Adams <Jerry@xxxxxxxxxxxxxxx>]

It seems obvious that the table cannot be labeled both FILE and NAME.  In order for the compiler to resolve the external definitions of the table, FILE must be the name of the table on disk, or you must use an OVRDBF command prior to the compilation for the resolution to occur.  If I am incorrect in this analysis, please let us know the actual name of the table as it exists on disk.

Ergo, NAME is a variable, which must be defined and populated.  (Re: alternative #2).  By the way, EXTMBR( ) is only needed if the table has multiple members AND you want a member other than the *First member.

Jerry C. Adams
IBM System i Programmer/Analyst
B&W Wholesale
office: 615-995-7024
email:  jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of manish soni
Sent: Tuesday, December 09, 2008 6:45 AM
To: RPG programming on the IBM i / System i
Subject: Re: Error in EXTFILE

HI Jerry,

I tried the same with the new code as below:

FFILE      IF   E             DISK    EXTFILE(NAME)
F                                     EXTMBR(NAME)
F                                     USROPN
C                   OPEN      FILE
C                   READ      REC
C     FIRSTNAME     DSPLY
C                   CLOSE     FILE
C                   SETON                                        LR

It still gives me the same problem.... NAME is the PF name as on disk.
also, it has the member name as NAME too.

Still have the same problem :-(

Regards
Manish

On Tue, Dec 9, 2008 at 1:29 PM, Jerry Adams <Jerry@xxxxxxxxxxxxxxx> wrote:

> If NAME is the name of the file as it exists on disk, get rid of the
> quotes: EXTFILE(NAME).
>
> If NAME is a variable, which is more likely in this case, you need to:
> a) still remove the quotes,
> b) define the variable in the D-specs, and
> c) populate the value of NAME (either as an INZ( ) on the D-spec or in
> Calcs.
>
> Thanks.
>
> Jerry C. Adams
> IBM System i Programmer/Analyst
> B&W Wholesale
> office: 615-995-7024
> email:  jerry@xxxxxxxxxxxxxxx
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of manish soni
> Sent: Tuesday, December 09, 2008 4:29 AM
> To: RPG programming on the IBM i / System i
> Subject: Error in EXTFILE
>
> Dear All,
>
> I am trying to make a simple program out of EXTFILE and EXTMBR concept.
> However, my system never identifies the file and gives me "The name or
> indicator is not defined." Errors. I have setup the library list correctly
> which contains the PF.
>
> Program:
> FFILE      IF   E             DISK    EXTFILE('NAME')
> F                                     EXTMBR('NAME')
> F                                     USROPN
> C                   OPEN      FILE
> C                   READ      REC
> C     FIRSTNAME     DSPLY
> C                   CLOSE     FILE
> C                   SETON                                        LR
>
> PF: NAME
> R REC
>  FIRSTNAME     10A
>
> Any idea where am I going wrong here ?
>
> Regards and Thanks
> Manish
> --
> This is the RPG programming on the IBM i / System i (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 IBM i / System i (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.