RE: Any example available to print a PDF stored in database

Eddie,

I would love for you to explain how to setup a Zebra printer to do the 4x6 PDF labels. You can email me directly if you have time.

I've used PRTSTMF to do exactly what you are doing - I have encountered PDF files that will not print that way (Wayfair changed the software they used to create the PDF and they will no longer direct print).

Thanks,
Greg

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Eddie Gomez
Sent: Friday, September 07, 2018 1:22 PM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Subject: Re: Any example available to print a PDF stored in database

We store our .PDF files on the IFS. We print our .PDF’s directly from our AS400 with no problem. Like anything IBM, there is a trick.

I print .PDF’s from the IFS using the PRTSTMF developed by Scott Klement.

The “trick” is that in order to print it to a printer, the printer must natively support PDF-Direct. We discovered that most CURRENT off-the-shelf HP printers support PDF-Direct. So once we configured our new $120 HP laser jet printer as a standard 3812 printer, PRTSTMF to that printer output queue works like a charm.

We use this method countless times per day, not just for 8.5x11” paper stock, but also to generate PDF 4x6 shipping labels and print to a Zebra printer which also supports PDF-direct. Works great. It worked so well, we are removing our old HP laser printers that are 10+ years old, and replacing them with new, cheap HP printers right from BestBuy that support PDF-Direct. Our users have been in ecstatic since then.

Hope this helps.

Eddie

On Sep 7, 2018, at 10:12 AM, Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

You'll almost certainly need to read the BLOB into an IFS file. From there, there are a number of options. Personally, I've found them to be varying degrees of disappointing, but YMMV.

Options for Printing PDF Stream Files which are Stored in the Integrated File System (IFS):
http://www-01.ibm.com/support/docview.wss?uid=nas8N1018851

Good luck,



-----Original Message-----
From: Mohammad Tanveer [mailto:surgum@xxxxxxxxx]
Sent: Thursday, September 06, 2018 4:12 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
<rpg400-l@xxxxxxxxxxxx>
Subject: Any example available to print a PDF stored in database

Is there any example to create a spool file for a PDF stored in a database table BLOB field? or send it directly to a printer.

Regards

--
This is the RPG programming on the IBM i (AS/400 and iSeries)
(RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD