Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
Hi, anybody have experience of label printing, sorry to say I don't. We are going to use Ave* 2”x4” labels. There are 2 x 5 labels on a page. I wonder if the spoolfile has to have certain parameters set, like formtype cpi/lpi etc. The spoofilel is going to be converted to pdf and emailed to user for printing. Would appreciate any advice.
The formtype doesn't matter unless you're allowing a printer writer to do the printing. If you're converting to PDF and e-mailing, it won't be used.
CPI and LPI will have an effect if you're using normal row and column output. LPI affects how many rows from the top, either directly or using SPACEx and SKIPx. CPI affects how many columns from the left.
If you're using AFP, you typically place by units down and across. See POSITION() keyword, for example. In this case, CPI could affect the appearance of the characters (CPI converts to default font), but not so much their location.
Thanks, didn't know about the AFP, position(). Looks like I have to test combinations of cpi/lpi to position onto the labels.
if you do scs, then what you will want to do is to use a fix width font and know the cpi of said font. And you will have to lay out the output in the program carefully not only for the left to right but also for the up and down because the gap between labels is not the same as you go across page boundary, AND probably running with cut sheets will make it o.k.
The other thing you will run into is if the label is a true 2", then at 6 lpi, that is 12 lines but if the gap between the labels is not 1/6" of an inch, you will have to possibly play with the number of lines you skip, etc. If it happens that it is 1/8" of an inch then you might have to run at 8 lpi.
Depending on how tight the printing has to hug the top or bottom of each label, you may have to actually design to print a page at a time, and vary the starting line, etc.
Wow, that's ... Sounds it's better to design a page with Position() then or are there any layouts ready to be used? How do you find them. A colleague doing the same thing in mainframe used certain pagedef/formdef to accomplish it.
I remember seeing the font identifier numbers and what font they represent somewhere but now I cannot find it. Anybody know where I can find them?
Good question.
Try Basic Printing, chapter on AFP Compatibility font substitution in Reference information. Specifically the Font information, though other parts may be useful. You want the Font global identifiers (FGID).
Not all printers have all font numbers, and substitutions are not always the same printer to printer, so you may want to create a small program and printer file to print samples.