Dream Writer Base File

In my RPG I am using I am using a different logical (keyed differently) to read a file. but due to different versions requested by users, .. Can I use a different Logical (keyed differently) as my based file in dream writter.

Your help will be appreciated.

Yes, you can. I use logical files as the based on file very frequently.

Teri

In my RPG I am using I am using a different logical (keyed differently)
to read a file. but due to different versions requested by users, .. Can
I use a different Logical (keyed differently) as my based file in dream
writter.Your help will be appreciated.
------------------------
JDE/400 7.3 00009
Papua New Guinea
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=52411
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList WorldO mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards.

+ - - - - - - - - - - - - - - - - - - - - - - - -+

JDE - "DREAM stands for Data Record Extraction And Management."

Fancy way of saying - let me give you a user interface to do SQL statement
of a single file (that JDE choose) and give you away of passing parms (and
maybe header descriptions for a report) to a program.

So the meat of Dream Writer
Based on file (in the additional parameters) - is what the SQL statement is
based on. Be careful changing this one, you probably will have to "touch"
(mod) the CL & RPG program.
Processing options - just parms passed to the program
Data selection - the "where" or "qryslt" part of the SQL statement
Data sequence - the "order by" or "keyfld" part of the SQL statement If it
is a report you might be able to change this, life is cool here if the
program was created using "hierarchical totaling". JDE gives you the
capabilities of doing, but almost never uses themselves.

Let me get my consience right...

Before RPG do a read on the file.. the CL or DW will do a SQL on the File and store the selected records onto another file (DUMMY) and then the RPG will do a READ on the DUMMY. ..

Am I right??

The DREAMWriter versions will build an open query file which I believe is an
index on the file being read and not a dummy file, so the data is not
copied. You can use option 7 on a DREAMWriter version to see the open query
file (OPNQRYF) statement that is used. I believe the CALL statement in the
CL to P98315 is what builds the open query file. Because of the OVRDBF
statement with a SHARE(*YES), when the RPG program opens the file it will
process only the records in the index. SQL is not used by DREAMWriter. I
hope this helps.

Mike Iaconis, President
Soar Technology Solutions
330-722-8106

Hi List,

Boy oh Boy (or Girl oh Girl) am I having a major understanding problem with
what is on the list tonight.

DVerner posted a good reply but I am not sure everyone comprehends.

Seems to me there is a problem out there in the JDE community about what a
DW is about. I guess that too many people have expectations beyond what DW
controlled programs are all about. There is always World Writer (WW)
supplied by JDE to enable you to interrogate files (with JOIN capabilities)
and IBM's Query as well as IBM's SQL etc etc.

All readers and contributors to this posting, please read the various JDE
User Reference Manuals (we used to call the major one "BASIC"). In almost
every case each JDE module User Reference Guide contains very specific
details about what each DW program can do and what you can change.

In very simple terminology the DW concept is based around an RPG program
that has various parameters that can be passed to it, and you have the
opportunity to influence what data and the sequence of that data that the
program sees. NOTE, however that these variables are very FINITE and very
SPECIFIC. The tough part is that the program may not be able to cope with
the sequence and totalling you want.

If you don't understand what OPNQRYF is capable of then don't look to JDE -
it is (these days) a very basic AS/400 operating system type function - you
need to get up to speed (that is, you need to become technically proficient)
and go and do some IBM based courses.


Regards

Colin HUGILL
(Yes I know I can be a b***ard sometimes)


----- Original Message -----
From: "DVerner" <[email protected]>
To: <[email protected]>
Sent: Wednesday, April 02, 2003 7:00 AM
Subject: Re: Dream Writer Base File


is



Colin Hugill
Consultant
(World A7.3 cum12)

Re: RE: Dream Writer Base File

This really helps.

Thank you.

How refreshing to see someone out there with passion and convictions.
Thank you Colin.
Sometimes this list can be very boring . . . but not today!!!

Jim Zimmerman
JDE World consultant, A7.3 c8 upgrading to c13, in the near future.

By the way, we have some 50 to 60 objects we have modified for various
reasons, all with extensive documentation (the key to upgrades). And some
100 *55 and *65 objects. We allow JDE to function as designed, for the
most part, and append our custom changes to update files and process as
needed. This also helps save time during the upgrade.
Testing then becomes the 'major' event.

One of the best ways to tackle differing user requirements for sorting is to use the method of "dynamic totalling" in a report program. See Type of Totalling parameter under the dreamwriter additional parameters.

You can then set up the program itself to handle the sorting by itself - main subroutines for this being the S002 and S010. Be careful of trying to copy some JDE programs for this, if any DD item is hard coded in the S002, it is not truely dynamic.