https://www.rpgpgm.com/2013/08/
August 2013 @ RPGPGM.COM
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
august
https://www.rpgpgm.com/2018/10/easiest-way-to-search-job-descriptions.html
Easiest way to search job descriptions @ RPGPGM.COM
Using a SQL view to get information from job descriptions is so simple when compared to using the QWDRJOBD API
easiest wayto searchjob descriptions
https://www.rpgpgm.com/2023/11/validating-email-address.html
Validating an email address @ RPGPGM.COM
Creating a program to validate an email address using RPG and SQL
an emailvalidatingaddress
https://www.rpgpgm.com/2018/09/sql-type-variables-in-rpg.html
SQL type variables in RPG @ RPGPGM.COM
The different SQL types available when defining RPG variables
sqltypevariablesrpg
https://www.rpgpgm.com/2023/09/creating-spool-file-from-sql-select.html
Creating a spool file from a SQL Select @ RPGPGM.COM
How to create a SQL statement whose results are output to a spool file (printed)
from sqlcreatingspoolfileselect
https://www.rpgpgm.com/2024/10/audit-journal-entry-services.html
Audit Journal Entry Services @ RPGPGM.COM
Audit Journal Entry Services make it so much easier to retrieve data from the Audit Journal, QAUDJRN.
journal entryauditservices
https://www.rpgpgm.com/2022/11/improvement-to-generatepdf.html
Improvement to GENERATE_PDF @ RPGPGM.COM
SQL scalar function introduces *LAST that can be used instead of the spool file number
generate pdfimprovement
https://www.rpgpgm.com/2015/01/
January 2015 @ RPGPGM.COM
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
january
https://www.rpgpgm.com/2016/07/the-versatile-clear-operation-code.html
The versatile Clear operation code @ RPGPGM.COM
Use the CLEAR operation code to initialize your fields, variables, arrays, record formats, etc. rather than Z-ADD or MOVE
versatileclearoperationcode
https://www.rpgpgm.com/2014/08/user-spaces-introduction-continued.html
User Spaces introduction continued @ RPGPGM.COM
When outputting to IBM i User Spaces it is a good idea to set the automatic extend parameter to extend
userspacesintroductioncontinued
https://www.rpgpgm.com/2023/10/determining-time-zone-and-calculating.html
Determining the time zone, and calculating the time in another country @ RPGPGM.COM
Determining which Time Zone my partition is in, and how to calculate UTC time from that
the timeanother countrydeterminingzone
https://www.rpgpgm.com/2020/11/
November 2020 @ RPGPGM.COM
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
november
https://www.rpgpgm.com/2017/04/nested-data-structures-in-rpg.html
Nested data structures in RPG @ RPGPGM.COM
Defining nested data structures within other data structures released as part of IBMi 7.3 TR2
nested datastructuresrpg
https://www.rpgpgm.com/2019/03/copying-part-of-existing-spool-file-to.html
Copying part of an existing spool file to a new one @ RPGPGM.COM
Copying a few pages from one spool file to another so that a page range can be printed by an IBM i remote output queue
https://www.rpgpgm.com/2024/08/retrieving-printer-file-information.html?m=0
Retrieving Printer File information using SQL @ RPGPGM.COM
New SQL View allows me to learn about all the printer files in my partition, including information about the record formats.
file informationusing sqlretrievingprinter
https://www.rpgpgm.com/2019/01/
January 2019 @ RPGPGM.COM
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
january