Join Logical F4211 and F42119

scott_parker

Reputable Poster
Greetings.

About a year ago I created a Join Logical file using F4211 and F42119. The reason for this was to give me access with world writer to all orders. Open and Closed.
It worked at the time. (runs forever but works)

Now I am at a different company. and I tried doing the same thing and it does not seem to be working.

It creates the file and I can run a WW against it and get the records from both files.

The problem comes in when I try using this file in a RPG program I get a compile time error saying that the format name I4211 is already defined specification ignored. (or something like that.)

The Member name of the Join Logical HAS to be either I4211 or I42119 in order for the Logical to be created. Below is the Code specs of the Join Logical.

Anyone know what I am doing wrong?

A R I4211 PFILE(F4211 F42119)
A K SDDOCO
A K SDDCTO
A K SDKCOO
A K SDLNID
 
I am misunderstanding what I am seeing. Because I do not see any Join logic?

Steve
 
Are you sure you don't have the F4211 in your file specs also? It normally
says that if you have two files with the same format name. Sometimes when
I'm cut and paste a program together I forget and leave something in there
that shouldn't be in there. If you're using a physical and a logical over
the physical, then you have to rename one of the formats.


Mary Cogdell
Manager of AS/400 Programming Support
Eat'n Park Restaurants
100 Park Manor Drive
Pittsburgh, Pa 15205
(412) 788-1600 x236
 
This is how I set up my joined logical file. I use it in all my RPG programs.
Works fine.


A*
A* LOGICAL VIEW OVER BOTH HISTORY & CURRENT FILE (BY YTAN8)
A*
A*
A R I0618 PFILE(F0618)
A K YTSALY
A K YTAN8
A*
A R I06116 PFILE(F06116)
A K YTSALY
A K YTAN8

____________________Reply Separator____________________
Subject: Join Logical F4211 and F42119 ~~0:296
Author: <[email protected]>
Date: 11/02/2000 6:20 AM

Greetings.

About a year ago I created a Join Logical file using F4211 and F42119. The
reason for this was to give me access with world writer to all orders. Open and
Closed.
It worked at the time. (runs forever but works)

Now I am at a different company. and I tried doing the same thing and it does
not seem to be working.

It creates the file and I can run a WW against it and get the records from both
files.

The problem comes in when I try using this file in a RPG program I get a compile
time error saying that the format name I4211 is already defined specification
ignored. (or something like that.)

The Member name of the Join Logical HAS to be either I4211 or I42119 in order
for the Logical to be created. Below is the Code specs of the Join Logical.

Anyone know what I am doing wrong?

A R I4211 PFILE(F4211 F42119)
A K SDDOCO
A K SDDCTO
A K SDKCOO
A K SDLNID



--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=W&Number=296
*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
Scott,

Sounds like a situation where you are using your Join Logical and the F4211
files in the same program. If so, you need to rename one of the formats in
the RPG. (Use IPFC in the seq line to prompt the FC line spec).

If not, ?

Rich


At 06:20 AM 11/2/2000, you wrote:
>Greetings.
>
>About a year ago I created a Join Logical file using F4211 and
>F42119. The reason for this was to give me access with world writer to
>all orders. Open and Closed.
>It worked at the time. (runs forever but works)
>
>Now I am at a different company. and I tried doing the same thing and it
>does not seem to be working.
>
>It creates the file and I can run a WW against it and get the records from
>both files.
>
>The problem comes in when I try using this file in a RPG program I get a
>compile time error saying that the format name I4211 is already defined
>specification ignored. (or something like that.)
>
>The Member name of the Join Logical HAS to be either I4211 or I42119 in
>order for the Logical to be created. Below is the Code specs of the Join
>Logical.
>
>Anyone know what I am doing wrong?
>
>A R I4211 PFILE(F4211 F42119)
>A K SDDOCO
>A K SDDCTO
>A K SDKCOO
>A K SDLNID
>
>
>
>--------------------------
>Visit the forum to view this thread at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=W&Number=296
>*************************************************************
>This is the JDEList World Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************

===========================================================
Rich Buttenhoff Phone:(208)799-4181
Potlatch Corporation Fax:(208)799-1687
805 Mill Road Mailto:[email protected]
Lewiston, ID 83501-1016 http://www.potlatchcorp.com
===========================================================
Walking on water and programming from
specifications are easy, if both are frozen.
===========================================================
 
Thanks for all the responces.

After checking to make sure I am not using the F4211 in the program I found out I wasn't. (so that's out)

I can not create the Join Logical file using JFILE because I want Every Record from Both files.

A R I4211 PFILE(F4211)
A K sddoco
A K sddcto
A*
A R I42119 PFILE(F42119)
A K sddoco
A K sddcto

The above also will not work because with the 2 different Memeber names World Writer can not use it.


Again, Thanks everyone.
 
Scott,

I tried several things myself to no avail, so I passed your problem along to
aN RPGIV users list.
Here are their responses:

***
I am guessing that you can't do it in RPG III, I just tried to do it with my
file and couldn't get it to work, when I ran my test RPG III through the
conversion to RPG IV it then compiled fine.

*** I TRIED THIS ONE, IT DIDN'T WORK.

the member name is not the problem it's the record format name and it should
be different then the record format names of any of the PFIlEs':

***
Where does the error occur? On the file spec. or somewhere else in the
program? If on the file spec, what does it look like? I have a similar
file and it works fine for me in RPG IV to just do the rename on the file
spec.

fwaybills if e k disk rename(rrwcb : rrwcb2)

where rrwcb is the record format in the file.

***
In the logical, you need a unique record name for each PFILE and the
complete set of fields you want to reference:

R FMT1 PFILE(XXX)
A
B
C
K C
R FMT2 PFILE(YYY)
A
B
C
K C

Why? When you have records with the same key in both files, YOU need a way
to identify which PF the record came from.
 
Re: RE: Join Logical F4211 and F42119

Thanks a lot for looking at this problem.

From what I can see I can not use the file in an RPG.
Even though with WW I can run over it and get records back from both files. An interesting concept to dewl on.
Open Query File's (and SQL's) dont care about the member name.
Of course RPG 3 does. I did try doing a Rename on the file spec. (which is where the error is happening) but it still gave me the same error message.

oh well It was worth a try.
I am just glad that the World Writer I have using that file works.

Again Thanks.

SP
 
What happens if you do not name the recordformat of the join-file I4211 but J4211 instead?

Marcel.

scott parker wrote:

> Greetings.
>
> About a year ago I created a Join Logical file using F4211 and F42119. The reason for this was to give me access with world writer to all orders. Open and Closed.
> It worked at the time. (runs forever but works)
>
> Now I am at a different company. and I tried doing the same thing and it does not seem to be working.
>
> It creates the file and I can run a WW against it and get the records from both files.
>
> The problem comes in when I try using this file in a RPG program I get a compile time error saying that the format name I4211 is already defined specification ignored. (or something like that.)
>
> The Member name of the Join Logical HAS to be either I4211 or I42119 in order for the Logical to be created. Below is the Code specs of the Join Logical.
>
> Anyone know what I am doing wrong?
>
> A R I4211 PFILE(F4211 F42119)
> A K SDDOCO
> A K SDDCTO
> A K SDKCOO
> A K SDLNID
>
> --------------------------
> Visit the forum to view this thread at:
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=W&Number=296
> *************************************************************
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
 
Hummm I don't think I did try that.
Doing a rename and picking something totaly different.

I will let you know if it works.
 
Back
Top