Okay, you described the task. Now, what is your question? What problem are you having? — Tom

Is this for something written in Java? Or are you thinking of a tool that helps to develop with Java on AS/400s? — Tom

Every report uses an external printer file. Commonly QSYSPRT or QPRINT is used. You can use OVRPRTF if necessary.
.
You really should not use an IBM-supplied printer file, just as you wouldn’t use an IBM-supplied DSPF or PF for your own applications. It would be better if you copied one of those and used the copy instead. You could also make multiple copies with different names and use CHGPRTF to give each copy different attributes so that OVRPRTF wouldn’t be needed.
.
However, best would be not to use internal printer specs at all. How often do you code internal display file specs? Why would you use external display files and not use external printer files? The benefits of external printer files are more than those for display files.
.
Tom

It might depend on your certificate provider. You need to contact them and ask what options they provide. I would expect that you can’t change the expiration period since longer periods can require longer key lengths. Instead of renewing, you will probably need to request a new certificate that has a longer period.
.
I believe that 1-year renewals can be better because they can be easier to schedule. Also, if personnel change, procedures might be forgotten or reminder e-mails might be lost. Organization details can also change and need to be re-authenticated as more years go by. However, longer terms can also come with slightly less cost per year.
.
As I understand things, you can typically purchase server certificates for 1, 2 or 3 years. From at least one provider I’ve seen, a 4-year certificate can be bought. Root certificates typically expire after 10 years. Someone with detailed experience might post corrections to what I’ve written here or add useful details.
.
Tom

You can insert hex values with SQL if the column allows the hex value. Otherwise the INSERT would fail. — Tom

One minor side note… You can create, populate and read a subfile in your program code without ever actually displaying it on a screen. Sometimes this can work as an array or MODS. By declaring an array over DSPF record format fields and arranging DSPF fields in a desired order, it can be easier to populate the DSPF. Sometimes. — Tom

And you might want to test a query using option 3=Define the sequence. Change the sequences of some characters to see how it changes sorted results or changes comparisons for ‘greater than’, ‘less than’ or ‘equals’ in the test query that you create. — Tom

Option 2 on your system causes Query to use the collating sequence for English. On someone else’s system, the option might show a different language or it might not be shown at all. Language collating sequences are often different from a hexadecimal sequence. For most things that involve a person looking at results, you should use the language sequence that is associated with that user. — Tom

I have a screen that does this with non-subfile data. Tab key advances thru “left side” fields and then “right side” fields (not actually columnar, more by proximity). The only unusual thing I found in the DDS (I didn’t write this one) is a display size override
DSPSIZ(27 132 *DS4)
My guess is any field located beyond some value (80 ?) is treated like it’s at the end.
So in your spare time, you may want to try this with your subfile to see how it responds.

I’m 99% sure you won’t like it.
Times Roman is a proportional font.
Spaces take less horizontal distance then characters in a font of that type.
But RPG print spec’s locate by number of characters from the left margin.
Your columns of data will not be aligned.
But the printing will be very nice.

Do an OVRPRTF to set the Font jsut before you call your program that will produce the output.

People create a tool to satisfy a need.
There are hundreds of free tools available on the web today.
Can you be more specific on what you are trying to accomplish?
Are you tryting to build something to sell? Or just a timesaver to give away?
What are your needs?

Tom – I bet you didn’t think your extra tidbit of advice would be so useful so quickly. Thanks again … now that I consistantly populate the message subfile I saw that it was not properly clearing. Focussing on the api parms, I tried many combinations. Nothing worked until I reread your “Binary” advice – so I switched that parm (silly me – taking the IBM site info literally) to a 10 digit integer and it finally seems to work perfectly. So you answered my next question before I even asked it.
Have you ever thought of starting a “you want it yesterday – OK” service ? (like next day delivery only better)

The last poster said you could copy the text into doc and save with .eml extension. Easier to just save the email (from within notes). It automatically is saved with a .eml extension. Then just embed as a doc but will open up as an email once clicked.

Great .. SETGT and,READPE aren’t operations that I need to use frequently.

If you are creating a table, you have predefined fields. So I do not understand how you would insert something after the last field in the file.
If you want to insert a new record with a hex value, you can do that with SQL.

INSERT INTO yourlib/yourfile VALUES(X'3F')

Oops. yes.

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/books/c4152104.pdf
pages 111-114
To see the collating sequence
- select collating sequence
- Enter Collating sequence option 3 .. (Define the Sequende)
F15 will show the language sequence (for your computer this is English )
F14 will show hexadecimal sequence

The sequence used will determine sort order and greater then / less then logic
F23 will allow you to save a sequence as the default.

Option 3 allows you to modify the sequence .. it has upper case = lower case
a=70 and A=70. So A and a will be sorted as equal.

How is the job scheduled now? — Tom

Post your working code here, and we’ll see if we can help improve it. I’ll post mine after yours.

Tom