× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



No problem. Our users couldn't believe it came from "the 400". Multiple
colors, tabs, fonts. It's also easy to maintain & duplicate for other
reports.

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



Thank you


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:30 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: 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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.