• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Equivalent technique to OVRDBF in AS/400 OneWorld??

DShea

Member
I am trying to figure out if a technique that works in a 'traditional'
As/400 green screen environment would work in OneWorld.

In a traditional environment with CL programs and RPG, there is a technique
where it's possible to archive old data to another library on disk and make
it selectively visible to certain production programs. This technique
allows you to get 18 of your 20 years sales history out of the way of
production (hence speeding up your machine) but still include it on the VP
of Sales 'Quarterly Report' (hence overcoming that one last dreadful
long-standing objection to purging). This technique involves tinkering with
the logical files, then either using an OVRDBF in the Quarterly Report CL or
manipulating your library list so that the program uses your new LF.

So... this works great in a 'traditional' environment.

Not being a OW jockey, I need to understand if there's an equivalent
technique in an As/400 based OneWorld environment.

After I create this logical file, how would I get selective programs to use
it instead of the 'vanilla' logical file? The goal is to leave the vast
majority of the programs alone - they are perfectly happy using the
slimmed-down, purged files. It's just the one or two exceptions (the
dreaded Quarterly Report, for example) that needs to see all 20 years
history.

Thanks.

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

vap

Active Member
Well, I can't say that I implemented this method, but it seems sound
enough:
I don't think you can selectively override files on "per application
basis". However, you can either
1. Copy applications in question to a custom, change the files to your
logicals.
2. Create a separate environment for these special reports and
inquiries, make a separate set of OCM mappings and map your "special"
tables to a different datasource (library), where they are logicals.
This has the advantage of not modifying OneWorld applications.
The only disadvantage is the following: I have heard (not verified it
myself) that XE on Oracle does not work with RDBMS views (Create view as
select). AS400 maybe a different story, and logical files in AS400 may
be different from Oracle views (I believe they are, but I'm not sure if
they are different enough). You never know until you check

Regards,
Vladimir Ponomarev
B733, B7331, B7332, XE (mostly XE at the moment); SQL 7.0, Oracle 8.1.5,
DB/400 (mostly SQL); Wintel, HP, AS/400 (mostly Wintel)
 

Frosty the Coder

Legendary Poster
We'd tried to accomplish the OVRDBF under 73.2.

I believe the jde.list concensus was that there was no easy way.

Try searching under OVRDBF in the FORUM to verify
my memory (it slips quickly....)

Gene



Gene Piekarski, Jr

AS/400, B733, SP11.2, NT client
AS/400, B733, SP14, W2000 client
XE, SP13
 

DShea

Member
Perry:

This is _exactly_ what I want to do. I will have a logical file by the same
name in another library that is _identical_ to the original, except that it
will 'see' all 20 years of data - the 2 years in the live environment and
the 18 years in the archive environment.

So, if I'm reading your message correctly, the 'pathcode' is similar to a
'library list' to us dinosaurs, er... uh... classically trained AS/400 (er..
uh... iSeries) professionals. If this is
 

vap

Active Member
DShea,

I'm not sure what was written in Perry's reply (could not find it in the
list). However, pathcode in OneWorld contains only the code. Data is
stored separately. Normally OneWorld works with an environment, which is
a combination of ONE pathcode and an arbitrary number of mappings (not
more then 5000 I believe, there's no more tables in OW), which may point
to different datasources. Datasources may point to different libraries
or even different database servers (with different RDBMS). Technically
an environment is a set of OCM (object configuration manager) records,
which point different tables to different Datasources. In this sense
there is some analogy to library list, but very remote.

I do suggest that you read CNC chapter in Foundation guide (on your doc
CD or Knowledge garden). It's a short, but really informative reading.

Regards,
Vladimir Ponomarev
B733, B7331, B7332, XE (mostly XE at the moment); SQL 7.0, Oracle 8.1.5,
DB/400 (mostly SQL); Wintel, HP, AS/400 (mostly Wintel)
 

Frosty the Coder

Legendary Poster
Perry,

Please repost your comments. I couldn't find them either.

I appreciated your input the 1st go 'round and am interested
in what you have to say now.

TIA

Gene



Gene Piekarski, Jr

AS/400, B733, SP11.2, NT client
AS/400, B733, SP14, W2000 client
XE, SP13
 

Larry_Jones

Legendary Poster
DShea,

is there any reason you can't simply create a Business View that does a UNION JOIN of the current (production table) with the Archive version of the same table? This is the technique JDE uses for Sales orders.

Just wondering.

Larry Jones
ljones@wagstaff.com
OneWorld XE, SP 15.1
HPUX 11, Oracle SE 8.1.6
Mfg, Distribution, Financials
 
Top