DW's

dale_draper

Well Known Member
DW\'s

Is there any way to have a DW's output go to an outfile rather than
a spoolfile?


TIA
 
Re: DW\'s

None that I know of using vanilla Dream Writer (although there are a few vanilla
ones that do allow that option, if memory serves me right), only World Writer or
a custom Dream Writer. If you are looking to download the report and if you have
Client Access, there is a way to do that. Let me know directly if that is what
you are trying to do.





Jill Fralick
ABB Flexible Automation
Auburn Hills, MI 48313
A7.3 cum 10
(248) 391-8618
 
Re: DW\'s

Do you mean WW's. DW's do not produce a spoolfile (not directly atleast) .
If yes then you can set the following parameters on the add'nl parameters
screen
Output Media . . . . . . . . . F (Disk File)
Output File. . . . . . . . . .
Output Library . . . . . . . .

Cheers!



dale_draper
<[email protected] To: [email protected]
ega.com> cc:
Sent by: Subject: DW's
owner-jdeworldml@j
delist.com


06/12/01 01:12 PM
Please respond to
jdeworld







Is there any way to have a DW's output go to an outfile rather
than
a spoolfile?


TIA




--------------------------
 
RE: DW\'s

DW's are programs so unless there is a processing option to produce an output
file, you cannot have it go to an outfile. You can have a logical file be
created on the system. On the Additional Parameters screen of DREAMWriter
there is a File Output Type filed. It's default is 1 for open query file, but
you can enter a 4 in it to create and keep a logical file. This will give you
a logical file of the data selected.

Not sure if this is what you were looking for, but I hope it helps.

Gary
 
RE: DW\'s

Dale,

In a word No. You would need to modify the program behind the DW to output
to disk rather than printer. You could try one of the various
tools/proprietary products for downloading a spoolfile as text then pulling
into excel etc.

Regards...... Colin HUGILL




Colin Hugill
Consultant
 
Re: DW\'s

DW's consist of a procedure which calls a program that accepts pre-defined
(in a table) parameters, passes them to another program which does the
selections from the files, and then passes the selected and sorted file to a
final program which is typically, but not always, a customized print
program. These procedures can be cloned to do what ever you want and we have
modified and/or created and a good many of them. Also, the DW selection
parameters are available in a field in the CL (which is too small and many
times needs to be expanded) and can be read into the program processing the
output. This is a very useful feature when the final program needs to use
the input selections to tailor its usage of the input file. The whole set is
a very complex chain of CL and RPG programs and requires a programmer's
skill with both CL and RPG to modify and make work.

We have done quite a few of these for our clients and find that the DW set
is very useful tool when the standard tools are inadequate.


Gerry Parker
PMK Consulting Group, Inc.
Information Technology Consulting
Tel: 713-621-7521 Fax: 713-661-7749
[email protected]
www.pmkc.com
.
----- Original Message -----
From: "Gary_Gallant" <[email protected]>
To: <[email protected]>
Sent: Tuesday, June 12, 2001 4:24 PM
Subject: RE: DW's


| DW's are programs so unless there is a processing option to produce an
output
| file, you cannot have it go to an outfile. You can have a logical file be
| created on the system. On the Additional Parameters screen of DREAMWriter
| there is a File Output Type filed. It's default is 1 for open query file,
but
| you can enter a 4 in it to create and keep a logical file. This will give
you
| a logical file of the data selected.
|
| Not sure if this is what you were looking for, but I hope it helps.
|
| Gary
|
|
|
|
| --------------------------
|

PMK Consulting Group, Inc.
Information Technology Consultants
Tel: 713-621-7521 Fax: 713-661-7749
 
Re: DW\'s

Yes you can take a dream writters output to a file instead of a spool file but it requires programming changes. (We have done a lot of that here)

Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R5
 
RE: DW\'s

From what Gerry said, the program changes sound like they can be pretty
complex. So, if I'm the one man shop and only basic CL, this sound's like it
may be beyond my bag of tricks?
 
RE: DW\'s

The program change isn't that hard. Create a physical, clear the file in the CL,
add the file to the program and every time you write to the report, you write to
the file.

The only other thing you may want to add is a processing option if the file is
to be written to.




Jill Fralick
ABB Flexible Automation
Auburn Hills, MI 48313
A7.3 cum 10
(248) 391-8618
 
RE: DW\'s

You can always take a pc tool like Monarch, which allows you to take any
report (AS400 or otherwise) and convert it into a file/Excel spreadsheet
etc. I think the licence is a little over $100 and it's very easy to use.
Having generated a DW report, you only need to extract it to a file
(CPYSPLF), download to pc and then run Monarch to create your file.
Having defined a Model in Monarch, you can automate your file creation next
time instead of having to define the layout of your report again.
Hope this helps.
----------------------------------------------------------
Tony Payne - Senior Systems Analyst
United Musical Instruments USA Inc.
1000 Industrial Parkway
Elkhart, Indiana 46516
Tel: (219) 295 0079 ext. 2337
Fax: (219) 295 8613
Email: [email protected]
(Running JDE A73 cum 10 on V4R3M0)
 
RE: DW\'s

Gotcha, does this need to be done for each DW version or at the form level?
 
Back
Top