RE: Sales Order Detail / History

RE: Sales Order Detail / History

Sure, it is possible to create a join logical file. What I want to know is
what is the difference between the record formats for these two files? Both
seem to have 218 fields, and a record length of 1266. The record format
identifier is ALMOST the same - just a tad bit different at the end of the
id itself. So they have to be very similar, and I always thought they were
the same. Anyway, back to the original question, you can indeed create a
logical file over the two physical files. JDE has some join logicals if you
want to look at their source.

John Dickey
White-Rodgers IS

RE: Sales Order Detail / History

Not too sure you could join them as they don't contain any records with a
relationship with each other. Besides they have identical field names in
both files. You might create a multi-format logical file that would combine
the records from both files into a single file.

though

. This would give you access to all the records in a single view but not
real sure what report writing would do since it would have multi-formats
with the same field names.





George Smith
World A7.3, Cum10 - V4R5
Walco International, Inc.

RE: Sales Order Detail / History

We have a join logical of F4211 and F42119. We are on 8.1.2

Looks like the following.



Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R5

You might want to take a look at the previous thread :
http://198.144.193.139/cgi-bin/wwwt...DEV&Number=3723&page=&view=&sb=&vc=1#Post3723
or search for Union in the developers forum. Go back a year though, this one is from January.

Tim Rathjen
B7332 SP16 Oracle 8.1.6 Intel/NT

RE: Sales Order Detail / History

When I'm pitching my archive software, the question always comes up about
'how can I see all the old data along with my live data'? Here are a couple
tricks...

If the record format names are the same and the fields are the same, you
_can_ have a LF that accesses two PFs with a single record format. This
only works for batch processes - reports, query, etc. The LF must be
created with MAINT(*REBLD) or the box will go nuts every time you add a
record to the live file.

The file looks this:

R X1234 PFILE(LIB1/FILE1 +
LIB2/FILE1)
K YOURKEY

RPG won't compile over this file, but you can override at run time and the
program will pick up all the records.

I wouldn't call this a 'join', I'd call it an 'append' file. It brings the
2 years live data and the 18 years history together so that you can feed the
VP of Sales Quarterly Report as if you'd never purged.

The other option is to use a multi-format logical file. This works for RPG
if your program does a READ FILENAME. If it does a READ RECFORMAT, it won't
work without tinkering with the program. This looks like:

R X1234 PFILE(LIB1/FILE1)
K YOURKEY

R X1234B PFILE(LIB2/FILE2)
K YOURKEY


This won't work with Query. But if your RPG does a READ to the FILENAME,
this will bring back records from either file, sorted by your key.

++++++++++++++++++++++++++++++++++++++++++++
Go... FASTER! Without an upgrade! With ARCTOOLS/400(tm)
http://www.arctools.com
[email protected]
DCSoftware, Inc.
Ph: (508) 435-8243
Fax: (508) 435-4498
++++++++++++++++++++++++++++++++++++++++++++