RE: Sharing a Print File

Sorry about that....I found it on his website...

http://www.scottklement.com/presentations/#RPGHSSF



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Florin Todor - YYZ Concord
Sent: Wednesday, September 24, 2008 1:14 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Sharing a Print File

Do you have a link or something for Scott's presentation?

Florin Todor


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Frank Kany
Sent: Wednesday, September 24, 2008 2:00 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: Sharing a Print File

Scott Klement has a cool presentation on using JAVA and RPG to create
multi-tabbed excel spreadsheets. We used the technique to solve the exact
same problem you're having.

Hth,

Frank


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Kesterson, Randy
Sent: Wednesday, September 24, 2008 12:48 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Sharing a Print File

The reports are being run in one job. They are each called within one
single CL program. What I'm trying to accomplish is to combine a number of
reports all into one Spool File so I can email the reports to various users.
The actual number of reports is over 20. They're used to getting the
reports in a single PDF document manually created from spreadsheets. They
don't want to have to open 20 plus emails each morning.


____________________________________________________________________________
__________________
Randy Kesterson, Information Services
Market Transport Services - a UTi Worldwide Company| 110 N Marine Drive |
Portland, OR 97217 | USA
rpkesterson@xxxxxxxxxxxxxxxxxxx | D +1 503.978.4353 | O +1 503.283.2405 x353
| F +1 503.978.4392


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Haas, Matt (CL Tech Sv)
Sent: Wednesday, September 24, 2008 10:26 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: Sharing a Print File

Are the programs being run in separate jobs? If so, I'm not sure you can do
this since the spool file is associated with the job.

This does beg the question: What are you trying to accomplish? Maybe there
is a better way to do what you want.

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Kesterson, Randy
Sent: Wednesday, September 24, 2008 1:21 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Sharing a Print File

Sorry, I meant to add that part to my initial email. I tried doing an
override of the print file with a SHARE(*YES) and a USROPN in both RPG
programs. I did not close the print file on the first program but it still
created two spooled files. I also tried opening with a scope of *JOB and
got the same results.

____________________________________________________________________________
__________________
Randy Kesterson, Information Services
Market Transport Services - a UTi Worldwide Company| 110 N Marine Drive |
Portland, OR 97217 | USA
rpkesterson@xxxxxxxxxxxxxxxxxxx | D +1 503.978.4353 | O +1 503.283.2405 x353
| F +1 503.978.4392


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Frank Kany
Sent: Wednesday, September 24, 2008 10:10 AM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: Sharing a Print File

Never tried that before....but maybe if you use the 'USROPN' keyword on the
printer file and manually open and close the file.

Hth,

Frank

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Kesterson, Randy
Sent: Wednesday, September 24, 2008 12:01 PM
To: RPG programming on the AS400 / iSeries
Subject: Sharing a Print File

Is there a way to run two RPG report programs, both outputting to the
same Print File name and have them share the open of that print file so
that both reports end up in one spool file?



________________________________________________________________________
______________________
Randy Kesterson, Information Services

Market Transport Services - a UTi Worldwide Company| 110 N Marine Drive
| Portland, OR 97217 | USA
rpkesterson@xxxxxxxxxxxxxxxxxxx <mailto:rpkesterson@xxxxxxxxxxxxxxxxxxx>
| D +1 503.978.4353 | O +1 503.283.2405 x353 | F +1 503.978.4392