<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-4373663334124272866</id><updated>2026-11-18T05:14:44.548-06:00</updated><category term="programming"/><category term="sql"/><category term="rpg"/><category term="new release"/><category term="cl"/><category term="history"/><category term="operations"/><category term="user group"/><category term="dspf"/><category term="pf"/><category term="query"/><category term="ifs"/><category term="shared"/><category term="lf"/><category term="virtual user group"/><category term="node.js"/><title type='text'>RPGPGM.COM - The IBM i blog</title><subtitle type='html'>From AS/400 to IBM i, advice about programming, operations, and anything else I can think of.</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default?start-index=26&amp;max-results=25'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>1142</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-8085878803460477070</id><published>2026-11-18T05:00:00.000-06:00</published><updated>2026-11-18T05:00:00.270-06:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="operations"/><category scheme="http://www.blogger.com/atom/ns#" term="sql"/><title type='text'>List user profiles with default passwords</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiG1lMR3z_sLT_8di2NSz8JAK3FOXfrvraszj9KHIy9k46IBLb5mmg6PCXvkJAIx6z1BLNdc3LwgOYKIFcxlq0Sa8vrp1D4M9dCPFn8ozG3FS_vBH2hiIrq3-s4vD7Ttz-cpbeeKGg1dyCHo3sKbhK6aaznJBqyF1Lz-qyNWnexfAWKa-R6nxuSnyw0VDk/s200/ops.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;The idea for this post came from a LinkedIn post by &lt;a href=&quot;https://www.linkedin.com/in/pete-massiello-a834697/&quot; target=&quot;_blank&quot; rel=&quot;nofollow&quot;&gt;Pete Massiello&lt;/a&gt;. In it he mentioned a command I had not heard of before, &lt;tt&gt;ANZDFTPWD&lt;/tt&gt;, and I decided to investigate it did to determine how I could use it.&lt;/p&gt;

&lt;p&gt;IBM&amp;#39;s definition of a default password is where the password is the same as the user profile. The Analyze Default Passwords command, &lt;abbr title=&quot;Analyze Default Passwords&quot;&gt;&lt;tt&gt;ANZDFTPWD&lt;/tt&gt;&lt;/abbr&gt;, can do three things:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;List all of those user profiles, and perform no further action&lt;/li&gt;
&lt;li&gt;List all of those user profiles, and disable them&lt;/li&gt;
&lt;li&gt;List all of those user profiles, and change the profile to password expired making the user change the password the next time they use it&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Steps 2 and 3 can be combined.&lt;/p&gt;

&lt;p&gt;If I type the command at a command line and press F4 to prompt the following screen is displayed:&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/09/list-user-profiles-with-default.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/8085878803460477070/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/09/list-user-profiles-with-default.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/8085878803460477070'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/8085878803460477070'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/09/list-user-profiles-with-default.html' title='List user profiles with default passwords'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiG1lMR3z_sLT_8di2NSz8JAK3FOXfrvraszj9KHIy9k46IBLb5mmg6PCXvkJAIx6z1BLNdc3LwgOYKIFcxlq0Sa8vrp1D4M9dCPFn8ozG3FS_vBH2hiIrq3-s4vD7Ttz-cpbeeKGg1dyCHo3sKbhK6aaznJBqyF1Lz-qyNWnexfAWKa-R6nxuSnyw0VDk/s72-c/ops.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-68881216122961974</id><published>2026-11-12T05:00:00.000-06:00</published><updated>2026-11-12T05:00:00.112-06:00</updated><title type='text'>A couple of new IBM performance guides are available</title><content type='html'>&lt;img align=&quot;right&quot; border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFSFf5-HBZhpFJNW01tF2h4c6gxbGY1zNnmKTlcxVMn9vqI1LYg7voqxQn35MUjgvVSQkFQYn2wYAlOddm8cXty3xtwlrxVkkYFIsdOupcX_OmVwRAxftCegzViha-dBHnhtcrocyurqW3/s200-rw/ibm_logo.jpg&quot; width=&quot;200&quot; /&gt;

&lt;p&gt;IBM have published a couple of interesting guides in the past few days.&lt;/p&gt;

&lt;p&gt;The first is the biannual update to the &quot;IBM i on Power - Performance FAQ&quot;. This guide provides us, &lt;em&gt;IBM i&lt;/em&gt; developers and administrators, with tips on how to measure and improve the performance of our IBM Power servers, &lt;em&gt;IBM i&lt;/em&gt; partitions, the Db2 database, and the programs that run within it.&lt;/p&gt;

&lt;p&gt;You can download the document from &lt;a href=&quot;https://www.ibm.com/downloads/documents/us-en/107a02e95dc8f88d&quot; target=&quot;_blank&quot; rel=&quot;nofollow&quot;&gt;here&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;The second is the &quot;IBM Power11 performance optimization for IBM i&quot; which endeavors to help us minimize the CPU utilization of our &lt;em&gt;IBM i&lt;/em&gt; applications on IBM Power servers.&lt;/p&gt;

&lt;p&gt;This document can be downloaded &lt;a href=&quot;https://www.ibm.com/downloads/documents/us-en/10c31775c6540034&quot; target=&quot;_blank&quot; rel=&quot;nofollow&quot;&gt;here&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;I download these guides and read the passages I feel are relevant to my situation. I recommend you do the same with both of these.&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/68881216122961974/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/11/ibm-performance-guide-update-available.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/68881216122961974'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/68881216122961974'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/11/ibm-performance-guide-update-available.html' title='A couple of new IBM performance guides are available'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFSFf5-HBZhpFJNW01tF2h4c6gxbGY1zNnmKTlcxVMn9vqI1LYg7voqxQn35MUjgvVSQkFQYn2wYAlOddm8cXty3xtwlrxVkkYFIsdOupcX_OmVwRAxftCegzViha-dBHnhtcrocyurqW3/s72-c-rw/ibm_logo.jpg" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-3177475313408847211</id><published>2026-11-11T05:00:00.000-06:00</published><updated>2026-11-11T05:00:00.145-06:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><category scheme="http://www.blogger.com/atom/ns#" term="sql"/><title type='text'>Identifying IBM&#39;s libraries</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s200/sql.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;I have always wanted the best way to identify which libraries, on the &lt;em&gt;IBM i&lt;/em&gt; partition I was using, belong to IBM. I had come up with doing things like considering all libraries that start with &amp;quot;&lt;tt&gt;Q&lt;/tt&gt;&amp;quot;, &amp;quot;&lt;tt&gt;SYS&lt;/tt&gt;&amp;quot;, and &amp;quot;&lt;tt&gt;#&lt;/tt&gt;&amp;quot;. But that was never a guarantee to separate IBM&amp;#39;s from others&amp;#39; libraries.&lt;/p&gt;

&lt;p&gt;IBM gave me a way to identify their libraries, using the &lt;a href=&quot;/2016/01/using-sql-for-objects-statistics.html&quot; target=&quot;_blank&quot;&gt;SQL &lt;tt&gt;OBJECT_STATISTICS&lt;/tt&gt; table function&lt;/a&gt;. It allowed me to identify most of the IBM libraries, but not all. I have made some additions to what they told me to make it mostly work.&lt;/p&gt;

&lt;p&gt;I need to use three columns from &lt;tt&gt;OBJECT_STATISTIC&lt;/tt&gt; results:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;tt&gt;OBJNAME&lt;/tt&gt;:  Name of the returned object, which in this case will be a library&lt;/li&gt;
&lt;li&gt;&lt;tt&gt;OBJDEFINER&lt;/tt&gt;:  User profile who created the object&lt;/li&gt;
&lt;li&gt;&lt;tt&gt;OBJNAME&lt;/tt&gt;:  User profile that owns the object&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;IBM told me that any libraries created by the profiles &lt;tt&gt;QLPINSTALL&lt;/tt&gt; and &lt;tt&gt;*IBM&lt;/tt&gt; would allow me to identify what should be considered IBM libraries. On further investigation on several &lt;em&gt;IBM i&lt;/em&gt; partitions I have found what I would also consider to be IBM libraries that were created by the user profile &lt;tt&gt;QSYS&lt;/tt&gt;, or are owned by &lt;tt&gt;QSYS&lt;/tt&gt;.&lt;/p&gt;

&lt;p&gt;The statement I came up with is:&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/11/identifying-ibms-libraries.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/3177475313408847211/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/11/identifying-ibms-libraries.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/3177475313408847211'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/3177475313408847211'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/11/identifying-ibms-libraries.html' title='Identifying IBM&#39;s libraries'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s72-c/sql.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-1576138565535708656</id><published>2026-11-10T05:00:00.000-06:00</published><updated>2026-11-10T05:00:00.226-06:00</updated><title type='text'>RPGPGM.COM-unity grows at TechXchange</title><content type='html'>&lt;center&gt;
&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHeyzS6N_TmR65DRRcyMqFtr3uZSRmDqk23HPV0sGIk_S-spo8TqtF9UrNhWnRc9d8T0YF70CdEn3rQHw4MLES9DRNUOqOcAW8u80nFbiMKnGYtspF5DDDgUZcuhRUW_QBp_yqTRqcziVQWdNonuGEtQHrKzEw-5Qjr6gBaNTcQhKjdJvQrrjIKpstz_c/s400/ribbon.jpg&quot; width=&quot;400&quot;/&gt;
&lt;/center&gt;

&lt;p&gt;At IBM’s TechXchange I had the opportunity to expand the &lt;b&gt;RPGPGM.COM-unity&lt;/b&gt;. You can see who joined, and I gave ribbons to, &lt;a href=&quot;https://rpgpgmcomunity.rpgpgm.com/p/rpgpgmcom-unity-2026.html#techxchange&quot; target=&quot;_blank&quot; rel=&quot;nofollow&quot;&gt;here&lt;/a&gt;. I am sure you will recognize some of the faces and names of the people.&lt;/p&gt;

&lt;p&gt;If you see me at an &lt;em&gt;IBM i&lt;/em&gt; event, feel free to come over and say &quot;Hi&quot;. In all likelihood I will have a &lt;b&gt;RPGPGM.COM-unity&lt;/b&gt; ribbon on me, and you can join the community.  All I ask in return is a photograph of you with it.&lt;/p&gt;

&lt;p&gt;If you would like to learn more about the &lt;b&gt;RPGPGM.COM-unity&lt;/b&gt; click &lt;a href=&quot;https://rpgpgmcomunity.rpgpgm.com/&quot; target=&quot;_blank&quot; rel=&quot;nofollow&quot;&gt;here&lt;/a&gt;.&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/1576138565535708656/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/11/rpgpgmcom-unity-grows-at-techxchange.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/1576138565535708656'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/1576138565535708656'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/11/rpgpgmcom-unity-grows-at-techxchange.html' title='RPGPGM.COM-unity grows at TechXchange'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHeyzS6N_TmR65DRRcyMqFtr3uZSRmDqk23HPV0sGIk_S-spo8TqtF9UrNhWnRc9d8T0YF70CdEn3rQHw4MLES9DRNUOqOcAW8u80nFbiMKnGYtspF5DDDgUZcuhRUW_QBp_yqTRqcziVQWdNonuGEtQHrKzEw-5Qjr6gBaNTcQhKjdJvQrrjIKpstz_c/s72-c/ribbon.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-889742391630766817</id><published>2026-11-04T05:00:00.000-06:00</published><updated>2026-11-04T05:00:43.603-06:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><category scheme="http://www.blogger.com/atom/ns#" term="sql"/><title type='text'>New parameters added to JOBLOG_INFO makes sorting and selecting so much better</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s200/sql.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;One of what, &lt;abbr title=&quot;In My Humble Opinion&quot;&gt;IMHO&lt;/abbr&gt;, is the best modifications in the latest Technology Refreshes, &lt;a href=&quot;/2026/07/first-tr-of-2026.html&quot; target=&quot;_blank&quot;&gt;&lt;em&gt;IBM i&lt;/em&gt; 7.6 &lt;abbr title=&quot;Technology Refresh&quot;&gt;TR&lt;/abbr&gt;2 and 7.5 TR8&lt;/a&gt;, has been the new parameters added to the &lt;a href=&quot;/2015/06/using-sql-to-get-information-from-job.html&quot; target=&quot;_blank&quot;&gt;&lt;tt&gt;JOBLOG_INFO&lt;/tt&gt; table function&lt;/a&gt;. These being:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;tt&gt;MESSAGE_ORDER&lt;/tt&gt;:  The order of the results returned&lt;/li&gt;
&lt;li&gt;&lt;tt&gt;MESSAGE_LIMIT&lt;/tt&gt;:  The number of messages to return in the results&lt;/li&gt;
&lt;li&gt;&lt;tt&gt;MESSAGE_TIMESTAMP&lt;/tt&gt;:  All messages that are equal or greater (newer) than the entered timestamp&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;I can view all of my job&amp;#39;s joblog using the following SQL statement:&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/10/new-parameters-added-to-jobloginfo_0886538615.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/889742391630766817/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/10/new-parameters-added-to-jobloginfo_0886538615.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/889742391630766817'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/889742391630766817'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/10/new-parameters-added-to-jobloginfo_0886538615.html' title='New parameters added to JOBLOG_INFO makes sorting and selecting so much better'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s72-c/sql.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-7393736160889439780</id><published>2026-11-02T05:00:00.000-06:00</published><updated>2026-11-03T07:56:53.779-06:00</updated><title type='text'>November’s presentations</title><content type='html'>&lt;img border=&quot;0&quot; height=&quot;150&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMCLlsfsGaitTe05m16VkcsjD_VWOnhYPNn5xvvzRSzZSVE_WOWuAMB0IPqTlmAzzA4Qp64uECU8L3Yo9H8RnBGXGqjwtfc82n5LfUNAK2x1X-J5eURcTOAoSv2snf7qnNm-eElDTF_fY6Nsap-DB_4Z_j2yGT6A6Uwtz4ZVT75a9AxYCvmqiHSTnwb3A/s200/man-with-megaphone.gif&quot; align=&quot;right&quot;&gt;

&lt;p&gt;I will be making two presentations this month, November, both of them online.&lt;/p&gt;

&lt;p&gt;The first is for the &lt;a href=&quot;https://ctxiug.blogspot.com/&quot; target=&quot;_blank&quot;&gt;&lt;b&gt;Central Texas IBM i User Group&lt;/b&gt;&lt;/a&gt;. This month&amp;#39;s meeting is on Tuesday November 10 at 6:30 PM (&lt;abbr title=&quot;US Central time&quot;&gt;CT&lt;/abbr&gt;). I will be giving two 30-ish minute presentations, that proved very popular at &lt;a href=&quot;https://powerup2026.sched.com/speaker/simon_hutchinson.27q3i94d&quot; target=&quot;_blank&quot;&gt;COMMON PowerUp&lt;/a&gt; earlier this year:

&lt;ul&gt;
&lt;li&gt;Designing your own CL commands&lt;/li&gt;
&lt;li&gt;Using SQL triggers to track file changes on IBM i&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;As I said the meeting is online, and free. You register from their web page &lt;a href=&quot;https://ctxiug.blogspot.com/2026/10/november-meeting.html&quot; target=&quot;_blank&quot;&gt;here&lt;/a&gt;.&lt;/p&gt;

&lt;br&gt;

&lt;p&gt;The following week, Tuesday November 17 starting at 2:00 PM (CT), I will be talking to the &lt;a href=&quot;https://www.quser.org/&quot; target=&quot;_blank&quot;&gt;&lt;b&gt;QUSER&lt;/b&gt;&lt;/a&gt; group of Minnesota. I will be making two presentations here too:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;RPG Built-in Functions You Should Be Using (50-60 minutes)&lt;/li&gt;
&lt;li&gt;RPG Arrays – Modern Features You Should Be Using (30-ish minutes)&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;This online meeting is only open to members of QUSER, who can register at their website &lt;a href=&quot;https://www.quser.org/presentation/quser-november-2026/&quot; target=&quot;_blank&quot;&gt;here&lt;/a&gt;.&lt;/p&gt;

&lt;/p&gt;&lt;a href=&quot;https://www.rpgpgm.com/2026/11/novembers-presentations.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/7393736160889439780/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/11/novembers-presentations.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/7393736160889439780'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/7393736160889439780'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/11/novembers-presentations.html' title='November’s presentations'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMCLlsfsGaitTe05m16VkcsjD_VWOnhYPNn5xvvzRSzZSVE_WOWuAMB0IPqTlmAzzA4Qp64uECU8L3Yo9H8RnBGXGqjwtfc82n5LfUNAK2x1X-J5eURcTOAoSv2snf7qnNm-eElDTF_fY6Nsap-DB_4Z_j2yGT6A6Uwtz4ZVT75a9AxYCvmqiHSTnwb3A/s72-c/man-with-megaphone.gif" height="72" width="72"/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-1284289177204666913</id><published>2026-10-28T04:00:00.000-05:00</published><updated>2026-11-03T07:50:14.104-06:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="new release"/><title type='text'>Fall TRs announced</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_JeuhayaTu7PB8TiXMtze7XciJ1q7B5XZF72hXgJ3cvsffcklIGA5U2lxSsvxGOqLU1Hw5E9YsB-UbQqeLmDNybvdjbzfiFQd0f8wqrhpSqBBzJ58TiLsj-aw4XX1tkUvxcuT0yTMAPHQiaW8LT1yjs3tHG1IC5BfhSKic5xx3NRiIxi1mY2bf4jJiyc/s200/ibm_i_2021.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;The Fall Technology Refreshes were announced at IBM’s TechXchange conference yesterday. &lt;em&gt;IBM i&lt;/em&gt; &lt;abbr title=&quot;Technology Refresh&quot;&gt;TR&lt;/abbr&gt;3 and 7.5 TR 9 are planned to be available November 20, 2026.&lt;/p&gt;

&lt;p&gt;What caught my eye in these are:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;SQL
&lt;ul&gt;
&lt;li&gt;The creation of a &lt;abbr title=&quot;SQL Error Logging Facility&quot;&gt;SELF&lt;/abbr&gt; exclusion list&lt;/li&gt;
&lt;li&gt;Changes to the QSYS2/HTTP functions to allow for header options for decompression and logging&lt;/li&gt;
&lt;/ul&gt;&lt;/li&gt;
&lt;/ul&gt;
 
&lt;ul&gt;
&lt;li&gt;RPG
&lt;ul&gt;
&lt;li&gt;When defining an array be able to initialize it with a list of values&lt;/li&gt;
&lt;li&gt;A new Built in Function &lt;tt&gt;%INFO&lt;/tt&gt; that will return the types of information that is currently found in the RPG status data structure&lt;/li&gt;
&lt;li&gt;A parameter in the Create RPG commands to prevent the program from being changed with the Update Program command, &lt;tt&gt;UPDPGM&lt;/tt&gt;&lt;/li&gt;
&lt;/ul&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;And many more cool things!&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/10/fall-trs-announced.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/1284289177204666913/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/10/fall-trs-announced.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/1284289177204666913'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/1284289177204666913'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/10/fall-trs-announced.html' title='Fall TRs announced'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_JeuhayaTu7PB8TiXMtze7XciJ1q7B5XZF72hXgJ3cvsffcklIGA5U2lxSsvxGOqLU1Hw5E9YsB-UbQqeLmDNybvdjbzfiFQd0f8wqrhpSqBBzJ58TiLsj-aw4XX1tkUvxcuT0yTMAPHQiaW8LT1yjs3tHG1IC5BfhSKic5xx3NRiIxi1mY2bf4jJiyc/s72-c/ibm_i_2021.png" height="72" width="72"/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-1237645444754003370</id><published>2026-10-27T04:00:00.000-05:00</published><updated>2026-10-27T04:00:00.135-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><category scheme="http://www.blogger.com/atom/ns#" term="sql"/><title type='text'>GENERATE_SPREADSHEET now allows me to give sheet a name</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s200/sql.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;Thanks to the latest Technology Refreshes, &lt;a href=&quot;/2026/07/first-tr-of-2026.html&quot; target=&quot;_blank&quot;&gt;&lt;em&gt;IBM i&lt;/em&gt; 7.6 &lt;abbr title=&quot;Technology Refresh&quot;&gt;TR&lt;/abbr&gt;2 and 7.5 TR8&lt;/a&gt;, we can now give our sheets generated by &lt;a href=&quot;/2024/01/creating-excel-spreadsheets-with-sql.html&quot; target=&quot;_blank&quot;&gt;&lt;tt&gt;GENERATE_SPREADSHEET&lt;/tt&gt;&lt;/a&gt; real names, rather than &amp;quot;Sheet 1&amp;quot;. This only works for Microsoft Excel, XLS and XLSX, and OpenDocument, ODS, spreadsheets.&lt;/p&gt;

&lt;p&gt;There is a new parameter for &lt;tt&gt;GENERATE_SPREADSHEET&lt;/tt&gt;, &lt;tt&gt;SHEET_NAME&lt;/tt&gt;, that allows you to give the sheet a name. While there does not appear to be a limit in the number of characters you can use in this parameter, Excel has a limitation of 31 characters for a sheet name. Before you go and start making your sheet name 31 characters you need to read on to understand why your sheet names will need to be less than that.&lt;/p&gt;

&lt;p&gt;In my examples I want to generate a list of names in Excel from the &lt;tt&gt;PERSON&lt;/tt&gt; file I have used before. I want to concatenate the last and first names together, and sort the results by name.&lt;/p&gt;

&lt;p&gt;Let me jump straight to my first example, generating an Excel spreadsheet in ACS&amp;#39; Run SQL Scripts, &lt;abbr title=&quot;Run SQL Scripts&quot;&gt;RSS&lt;/abbr&gt;.&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/10/generatespreadsheet-now-allows-me-to.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/1237645444754003370/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/10/generatespreadsheet-now-allows-me-to.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/1237645444754003370'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/1237645444754003370'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/10/generatespreadsheet-now-allows-me-to.html' title='GENERATE_SPREADSHEET now allows me to give sheet a name'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s72-c/sql.png" height="72" width="72"/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-1055190445397567870</id><published>2026-10-22T05:00:00.000-05:00</published><updated>2026-10-22T05:00:00.117-05:00</updated><title type='text'>Award for this website for second year</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2HM0cLsFuDm_gme_m_7FXsw79nOQMu-7M8D03wMo3ZnTweQe4XGBo5y8GFOpjiSR47JUcBa-hNEE00aH86TcQz6B42AvTnDzbctuaKp5H0AaofeJHRsmazhB3TgZCVDV4wa6loaQQmDt05ji0mbQEA84e6oFHy9Wyi2zkc14h-CtyetR0D4hDIA6LOjU/s200/feedspot_top_ibm_blogs_2025.png&quot; align=&quot;right&quot; /&gt;

&lt;p&gt;I was notified on Monday that this website, &lt;b&gt;RPGPGM.COM&lt;/b&gt;, for the second year has won an award from &lt;a href=&quot;https://www.feedspot.com/&quot; target=&quot;_blank&quot;&gt;Feedspot&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;Anuj Agarwal, founder of FeedSpot, informed me of this:&lt;/p&gt; 

&lt;blockquote class=&quot;blockquote-custom&quot;&gt;
&lt;p&gt;I emailed regarding your blog Rpgpgm.Com which was selected by FeedSpot as one of the Top 10 IBM Blogs on the web (2026 Edition).&lt;/p&gt;

&lt;p&gt;&lt;a href=&quot;https://bloggers.feedspot.com/ibm_blogs/&quot; target=&quot;_blank&quot; rel=&quot;nofollow&quot;&gt;https://bloggers.feedspot.com/ibm_blogs/&lt;/a&gt;&lt;/p&gt;

&lt;/blockquote&gt;

&lt;p&gt;This year &lt;b&gt;RPGPGM.COM&lt;/b&gt; is ranked in eighth place.&lt;/p&gt;

&lt;p&gt;Thank you Anuj, and the panel at FeedSpot, for this honor.&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/1055190445397567870/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/10/award-for-this-website-for-second-year.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/1055190445397567870'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/1055190445397567870'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/10/award-for-this-website-for-second-year.html' title='Award for this website for second year'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2HM0cLsFuDm_gme_m_7FXsw79nOQMu-7M8D03wMo3ZnTweQe4XGBo5y8GFOpjiSR47JUcBa-hNEE00aH86TcQz6B42AvTnDzbctuaKp5H0AaofeJHRsmazhB3TgZCVDV4wa6loaQQmDt05ji0mbQEA84e6oFHy9Wyi2zkc14h-CtyetR0D4hDIA6LOjU/s72-c/feedspot_top_ibm_blogs_2025.png" height="72" width="72"/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-2713356192069586429</id><published>2026-10-21T05:00:00.000-05:00</published><updated>2026-10-21T05:00:00.113-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="new release"/><title type='text'>ACS 1.1.9.17 available now</title><content type='html'>&lt;img border=&quot;0&quot; height=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkyDKdAcBrsjkD0S91KFQ9s3xp0B7NFnDG4veJ3Ns2soXeefddbzHYOL8QzSI2UybQ2t1BNygQXVTrkYRsVRHs4OBQQOPvIPRoXVVtx1I9PGjnJd5k6Bz5cyadZ5TZPkh8uBcvscnui8C2PMyeQYCJfGovpEQ-qdtaYpH6LqXBHqvCXoXM9vDKd4YPeII/s200/acs_logo.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;Another release of IBM&amp;#39;s Access Client Solutions, &lt;abbr title=&quot;Access Client Solutions&quot;&gt;ACS&lt;/abbr&gt; 1.1.9.17, is available.&lt;/p&gt;

&lt;center&gt;
&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFD0-xgx71bDl5Y741aYpBCDx_2hI_OmONCbhZUjx2qj7RAOPfMzODHvnPvhh3xbSs2Hau_oJW-suIj4tGRWx_GQPxp2gSQFMafGoDOHW-Xg0yj11BydUbW8z8oeLB6mXoEE_Cfi4ZclgVKq5nHRBW9zUmonNrM1FF0LoyRqjjDkSaKoboR3Ith3oKM54/s1600/acs_1.png&quot;&gt;
&lt;/center&gt;

&lt;p&gt;This version is to remedy a couple of &lt;a href=&quot;/2026/07/it-is-now-so-easy-to-view-cve-using-sql.html&quot; target=&quot;_blank&quot; title=&quot;Common Vulnerabilities and Exposures&quot;&gt;CVE&lt;/a&gt; related to the SFTP client. And to fix an error with the &lt;tt&gt;RESTRICT ON DROP&lt;/tt&gt; on the &lt;tt&gt;CREATE&lt;/tt&gt; object SQL statement. You can learn more about them on IBM&amp;#39;s ACS updates page &lt;a href=&quot;https://www.ibm.com/support/pages/ibm-i-access-acs-updates&quot; target=&quot;_blank&quot; rel=&quot;nofollow&quot;&gt;here&lt;/a&gt;.&lt;/p&gt;
&lt;a href=&quot;https://www.rpgpgm.com/2026/10/acs-11917-available-now.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/2713356192069586429/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/10/acs-11917-available-now.html#comment-form' title='4 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/2713356192069586429'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/2713356192069586429'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/10/acs-11917-available-now.html' title='ACS 1.1.9.17 available now'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkyDKdAcBrsjkD0S91KFQ9s3xp0B7NFnDG4veJ3Ns2soXeefddbzHYOL8QzSI2UybQ2t1BNygQXVTrkYRsVRHs4OBQQOPvIPRoXVVtx1I9PGjnJd5k6Bz5cyadZ5TZPkh8uBcvscnui8C2PMyeQYCJfGovpEQ-qdtaYpH6LqXBHqvCXoXM9vDKd4YPeII/s72-c/acs_logo.png" height="72" width="72"/><thr:total>4</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-3029444712770674958</id><published>2026-10-20T05:00:00.000-05:00</published><updated>2026-10-20T05:00:00.115-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cl"/><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><title type='text'>When copying data from IFS file preventing errors due to nulls</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwp6wOJVwdtdNBKPKhwNlKZZHtBYN2G-q3I1rRbJDdrOkMqSJmfvY3Vr_sxtD2KwvRjP_Nu9njJLh8G1V0ExRrnFJP7S7267a1JsUslWn-d1qYY0atlJM5e582OaWkIGQyKroJCpMaG8xYzX2A-qMpN4IUAfvb89RncpKUVL1a7uSx_D5EZAsUyVSyyiU/s200/cl.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;I was asked to help a colleague with a problem he was having. He had a CSV, Comma Separated Variable length record, file in the IFS, and was getting errors with a program when it tried to copy the contents of the CSV file to a DDS files. The program had been running for many years without errors, until now. Looking in joblog I could see that the copy was failing due to null values in the CSV file&amp;#39;s columns.&lt;/p&gt;

&lt;p&gt;How is null shown in a CSV? Normally it is when two commas are next to each other: &amp;quot;&lt;tt&gt;,,&lt;/tt&gt;&amp;quot;&lt;/p&gt;

&lt;p&gt;For this post I created a DDS file, you will not be surprised to learn that I called it &lt;tt&gt;TESTFILE&lt;/tt&gt;, and it contains three fields:&lt;/p&gt;

&lt;table border=&quot;1&quot; width=&quot;95%&quot; class=&quot;table-code&quot;&gt;&lt;tr&gt;
&lt;td&gt;&lt;pre&gt;
01 A          R TESTFILER
02 A            FIELD1        10A
03 A            FIELD2         5P 0
04 A            FIELD3          Z
&lt;/pre&gt;&lt;/td&gt;
&lt;/tr&gt;&lt;/table&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/10/when-copying-data-from-ifs-file.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/3029444712770674958/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/10/when-copying-data-from-ifs-file.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/3029444712770674958'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/3029444712770674958'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/10/when-copying-data-from-ifs-file.html' title='When copying data from IFS file preventing errors due to nulls'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwp6wOJVwdtdNBKPKhwNlKZZHtBYN2G-q3I1rRbJDdrOkMqSJmfvY3Vr_sxtD2KwvRjP_Nu9njJLh8G1V0ExRrnFJP7S7267a1JsUslWn-d1qYY0atlJM5e582OaWkIGQyKroJCpMaG8xYzX2A-qMpN4IUAfvb89RncpKUVL1a7uSx_D5EZAsUyVSyyiU/s72-c/cl.png" height="72" width="72"/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-6271387081979160824</id><published>2026-10-14T05:00:00.000-05:00</published><updated>2026-10-14T05:00:00.151-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><category scheme="http://www.blogger.com/atom/ns#" term="sql"/><title type='text'>Being proactive about system sizings</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s200/sql.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;There are a couple of SQL views that keep track of objects exceeding the maximum system sizes. I can use these to be proactive, capture information about objects reaching their maximums, before it happens.&lt;/p&gt;

&lt;p&gt;In this example I want to show any object whose sizing limit has reached a value of 75% or more.&lt;/p&gt;

&lt;p&gt;The Views I could use are:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;tt&gt; SYSLIMITS&lt;/tt&gt;:  Full version of the View. You need &lt;tt&gt;*JOBCTL&lt;/tt&gt; authority, or QIBM_DB_SQLADM or QIBM_DB_SYSMON function usages. If the Limit Type is &amp;quot;&lt;tt&gt;OBJECT&lt;/tt&gt;&amp;quot; then you will need &lt;tt&gt;*EXECUTE&lt;/tt&gt; to the library and &lt;tt&gt;*OBJOPR&lt;/tt&gt; and &lt;tt&gt;*READ&lt;/tt&gt; authority to the object.&lt;/li&gt;
&lt;li&gt;&lt;tt&gt; SYSLIMITS_BASIC&lt;/tt&gt;:  Requires less authority than &lt;tt&gt;SYSLIMITS&lt;/tt&gt;, and as it has less columns the results are returned faster.&lt;/li&gt;
&lt;/ul&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/10/being-proactive-about-system-sizings.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/6271387081979160824/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/10/being-proactive-about-system-sizings.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/6271387081979160824'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/6271387081979160824'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/10/being-proactive-about-system-sizings.html' title='Being proactive about system sizings'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s72-c/sql.png" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-5902105356576950128</id><published>2026-10-13T05:00:00.000-05:00</published><updated>2026-10-13T05:00:00.118-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="new release"/><title type='text'>Latest IBM i roadmap</title><content type='html'>&lt;center&gt;
&lt;img border=&quot;0&quot; width=&quot;775&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyJRNyg6JGu88K5XYjlHiRMwLjpYMZUyw-X31fcyGFSJ7aWWBpeeETcwYHndWjS4IfxYKMW-4RQ_VprgfyJIxbk7h5LXiudH-R98DmwxLRLWn-8D3pm4kQrEfQkjywnP8Xp7QC2FdGrBlqnN0YoaHsMBIs5tvljIy_xo3cKM6wrj2h5yrWvQmnU4Swqr0/s1600/ibmi_roadmap_2026_%282%29.png&quot;/&gt;
&lt;/center&gt;

&lt;p&gt;When I find these &lt;em&gt;IBM i&lt;/em&gt; Roadmaps I always like to share them with you.&lt;/p&gt;

&lt;p&gt;The next time someone tells you that &quot;AS400&quot; or &quot;iSeries&quot; is old, show them this chart. Explain that &lt;em&gt;IBM i&lt;/em&gt; is a thoroughly modern operating system, and its creator, IBM, has plans for new releases into the next decade.&lt;/p&gt;

&lt;p&gt;I don&#39;t know of another operating system vendor who provides similar information.&lt;/p&gt;

&lt;p&gt;I copied this from the &lt;a href=&quot;/2026/08/ibm-redbook-covers-modernization-in.html&quot; target=&quot;_blank&quot;&gt;IBM Modernizing IBM i Applications&lt;/a&gt; Redbook.&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/5902105356576950128/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/10/latest-ibm-i-roadmap.html#comment-form' title='3 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/5902105356576950128'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/5902105356576950128'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/10/latest-ibm-i-roadmap.html' title='Latest IBM i roadmap'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyJRNyg6JGu88K5XYjlHiRMwLjpYMZUyw-X31fcyGFSJ7aWWBpeeETcwYHndWjS4IfxYKMW-4RQ_VprgfyJIxbk7h5LXiudH-R98DmwxLRLWn-8D3pm4kQrEfQkjywnP8Xp7QC2FdGrBlqnN0YoaHsMBIs5tvljIy_xo3cKM6wrj2h5yrWvQmnU4Swqr0/s72-c/ibmi_roadmap_2026_%282%29.png" height="72" width="72"/><thr:total>3</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-139952406285247205</id><published>2026-10-07T05:00:00.000-05:00</published><updated>2026-10-07T15:33:17.279-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><category scheme="http://www.blogger.com/atom/ns#" term="sql"/><title type='text'>Copying JSON in CLOB to an IFS file</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s200/sql.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;The germ for this post comes from a comment made on the &lt;a href=&quot;/2026/01/better-examples-for-creating-and.html&quot; target=&quot;_blank&quot;&gt;Better examples for creating and consuming JSON&lt;/a&gt; post. The question was:&lt;/p&gt;

&lt;blockquote class=&quot;blockquote-custom&quot;&gt;
&lt;p&gt;How can I create an IFS File of the JSON Object from the MYLIB.OUTPUT object?&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;In that post I used the &lt;tt&gt;JSON_OBJECT&lt;/tt&gt; scalar function to create a JSON array in a DDL table with a &lt;abbr title=&quot;Character Large OBject&quot;&gt;CLOB&lt;/abbr&gt; column:&lt;/p&gt;

&lt;table border=&quot;1&quot; width=&quot;95%&quot; class=&quot;table-code&quot;&gt;&lt;tr&gt;
&lt;td&gt;&lt;pre&gt;
01  CREATE TABLE MYLIB.OUTPUT (OUTPUT CLOB)
&lt;/pre&gt;&lt;/td&gt;
&lt;/tr&gt;&lt;/table&gt;

&lt;p&gt;I filled the CLOB with a SQL Insert statement with the &lt;tt&gt;JSCON_OBJECT&lt;/tt&gt; scalar function, creating a JSON array from the data in the Person file:&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/08/copying-json-in-clob-to-ifs-file.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/139952406285247205/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/08/copying-json-in-clob-to-ifs-file.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/139952406285247205'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/139952406285247205'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/08/copying-json-in-clob-to-ifs-file.html' title='Copying JSON in CLOB to an IFS file'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s72-c/sql.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-6487748473937190630</id><published>2026-10-06T05:00:00.000-05:00</published><updated>2026-10-06T05:00:00.183-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="history"/><category scheme="http://www.blogger.com/atom/ns#" term="rpg"/><title type='text'>Who remembers the RPG Debugging Template?</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD5vqsclKp8wzeUbRrA-vvJIw5b24K8ieciBR2x0vok-GmXw3I_VvQ03RWsn3cyieTwot95LXTPsLPT7O4TkD8oNeJL7oMvR1G56SHTZIzvkPWr2BU5dp1_RdQoZX2pnBk5U-hBTQN1lZ73sQl9MMXpsrWNHm4b18zFa00R_wAW5Yf8oO0Xw5RJYNFuMk/s200/rpg.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;Someone asked me about what IBM midrange programming was like in the days before the AS/400. I am old enough to have first worked on the &lt;a href=&quot;https://en.wikipedia.org/wiki/IBM_System/36&quot; target=&quot;_blank&quot; rel=&quot;nofollow&quot;&gt;IBM System/36&lt;/a&gt;, learning &lt;a href=&quot;https://en.wikipedia.org/wiki/IBM_RPG_II&quot; target=&quot;_blank&quot; rel=&quot;nofollow&quot;&gt;RPGII&lt;/a&gt;. One of my most treasured possessions was a &amp;quot;RPG Debugging Template&amp;quot;, this folded piece of card had all of RPGII specifications on each fold. This could then be use on a green bar print of a program to determine which column various operations and indicators were in and, therefore, would help me determine what the code would do.&lt;/p&gt;

&lt;p&gt;I know it came in a two-card set. I thought I had both. After going through all of the draws in my desk I could only find the one with the specifications I used the most:&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/10/who-remembers-rpg-debugging-template.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/6487748473937190630/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/10/who-remembers-rpg-debugging-template.html#comment-form' title='11 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/6487748473937190630'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/6487748473937190630'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/10/who-remembers-rpg-debugging-template.html' title='Who remembers the RPG Debugging Template?'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD5vqsclKp8wzeUbRrA-vvJIw5b24K8ieciBR2x0vok-GmXw3I_VvQ03RWsn3cyieTwot95LXTPsLPT7O4TkD8oNeJL7oMvR1G56SHTZIzvkPWr2BU5dp1_RdQoZX2pnBk5U-hBTQN1lZ73sQl9MMXpsrWNHm4b18zFa00R_wAW5Yf8oO0Xw5RJYNFuMk/s72-c/rpg.png" height="72" width="72"/><thr:total>11</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-809495869480104869</id><published>2026-10-01T05:00:00.000-05:00</published><updated>2026-10-01T05:00:00.116-05:00</updated><title type='text'>What I will be doing in October</title><content type='html'>&lt;img border=&quot;0&quot; height=&quot;150&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMCLlsfsGaitTe05m16VkcsjD_VWOnhYPNn5xvvzRSzZSVE_WOWuAMB0IPqTlmAzzA4Qp64uECU8L3Yo9H8RnBGXGqjwtfc82n5LfUNAK2x1X-J5eURcTOAoSv2snf7qnNm-eElDTF_fY6Nsap-DB_4Z_j2yGT6A6Uwtz4ZVT75a9AxYCvmqiHSTnwb3A/s200/man-with-megaphone.gif&quot; align=&quot;right&quot;&gt;

&lt;p&gt;This month I do not have any speaking engagements.&lt;/p&gt;

&lt;p&gt;But I will be attending IBM&amp;#39;s &lt;a href=&quot;https://www.ibm.com/events/techxchange&quot; target=&quot;_blank&quot; rel=&quot;nofollow&quot;&gt;TechXchange&lt;/a&gt;, in Atlanta GA, Sunday October 25 - Tuesday October 27. I will have my &lt;a href=&quot;https://rpgpgmcomunity.rpgpgm.com/p/rpgpgmcom-unity-pictures.html&quot; target=&quot;_blank&quot;&gt;RPGPGM.COM-unity ribbons&lt;/a&gt; with me. If you see me say &amp;quot;Hi&amp;quot;, and ask for a ribbon. All I ask in return is a photograph of you with the ribbon.&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/10/what-i-am-doing-in-october.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/809495869480104869/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/10/what-i-am-doing-in-october.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/809495869480104869'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/809495869480104869'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/10/what-i-am-doing-in-october.html' title='What I will be doing in October'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMCLlsfsGaitTe05m16VkcsjD_VWOnhYPNn5xvvzRSzZSVE_WOWuAMB0IPqTlmAzzA4Qp64uECU8L3Yo9H8RnBGXGqjwtfc82n5LfUNAK2x1X-J5eURcTOAoSv2snf7qnNm-eElDTF_fY6Nsap-DB_4Z_j2yGT6A6Uwtz4ZVT75a9AxYCvmqiHSTnwb3A/s72-c/man-with-megaphone.gif" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-4256388223763034645</id><published>2026-09-30T05:00:00.000-05:00</published><updated>2026-09-30T05:00:00.238-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="history"/><title type='text'>End of support for IBM i 7.4</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_JeuhayaTu7PB8TiXMtze7XciJ1q7B5XZF72hXgJ3cvsffcklIGA5U2lxSsvxGOqLU1Hw5E9YsB-UbQqeLmDNybvdjbzfiFQd0f8wqrhpSqBBzJ58TiLsj-aw4XX1tkUvxcuT0yTMAPHQiaW8LT1yjs3tHG1IC5BfhSKic5xx3NRiIxi1mY2bf4jJiyc/s200/ibm_i_2021.png&quot; align=&quot;right&quot; /&gt;

&lt;p&gt;Today &lt;a href=&quot;/2019/06/new-release-ibm-i-74-day.html&quot; target=&quot;_blank&quot;&gt;&lt;em&gt;IBM i&lt;/em&gt; 7.4&lt;/a&gt; reaches End Of Standard Support, &lt;abbr title=&quot;End Of Standard Support&quot;&gt;EOSS&lt;/abbr&gt;.&lt;/p&gt;

&lt;p&gt;If you are still using &lt;em&gt;IBM i&lt;/em&gt; 7.4 what does that mean?&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;You already know that there have been no new features since April 2026.&lt;/li&gt;
&lt;li&gt;Standard PTFs stop, although critical security fixes will be available if you purchase a Service Extension for this release.&lt;/li&gt;
&lt;li&gt;Increase in the cost of you IBM Software Support. Typically, a Service Extension sees...
  &lt;ul&gt;
  &lt;li&gt;Year 1: increase of 1.5x to 2x of your previous base Software Maintenance rate per core.&lt;/li&gt;
  &lt;li&gt;Later years: increase could reach 3x to 4x.&lt;/li&gt;
  &lt;/ul&gt;&lt;/li&gt;
&lt;li&gt;End of Service Extension will be September 30, 2029.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;For more information see this IBM page &lt;a href=&quot; https://www.ibm.com/support/pages/ibm-i74x&quot; target=&quot;_blank&quot; rel=&quot;nofollow&quot;&gt;here&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;If you have IBM Power9 – Power11 you should plan to upgrade your &lt;em&gt;IBM i&lt;/em&gt; to 7.5 or 7.6 as soon as you can.&lt;/p&gt;

&lt;p&gt;If you have IBM Power8 or older, you need to upgrade your hardware too.&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/4256388223763034645/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/09/end-of-support-for-ibm-i-74.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/4256388223763034645'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/4256388223763034645'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/09/end-of-support-for-ibm-i-74.html' title='End of support for IBM i 7.4'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_JeuhayaTu7PB8TiXMtze7XciJ1q7B5XZF72hXgJ3cvsffcklIGA5U2lxSsvxGOqLU1Hw5E9YsB-UbQqeLmDNybvdjbzfiFQd0f8wqrhpSqBBzJ58TiLsj-aw4XX1tkUvxcuT0yTMAPHQiaW8LT1yjs3tHG1IC5BfhSKic5xx3NRiIxi1mY2bf4jJiyc/s72-c/ibm_i_2021.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-3575429580945171298</id><published>2026-09-29T05:00:00.000-05:00</published><updated>2026-09-29T05:00:00.124-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><category scheme="http://www.blogger.com/atom/ns#" term="sql"/><title type='text'>Making a list of users with *ALLOBJ authority is much easier with SQL</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s200/sql.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;The germ for this post comes from a series of conversations I had with a colleague. He had been asked to generate a Microsoft Excel spreadsheet that contained a list of all the current enabled user profiles with All Object, &lt;tt&gt;*ALLOBJ&lt;/tt&gt;, authority. This was something that had been done for years as a series of manual steps, but he decided could do it more efficiently with a CL program.&lt;/p&gt;

&lt;p&gt;He would come to me to show me what he had done, and to say he could do it without using any SQL. It is right there are many, many processes that can be done without using SQL, but is that the efficient and timely way to do it?&lt;/p&gt;

&lt;p&gt;I am not showing his work, but what I would do if I could not use SQL.&lt;/p&gt;

&lt;p&gt;Firstly he would need to use the Display User Profile command, &lt;tt&gt;DSPUSRPRF&lt;/tt&gt;, to make a list of all the user profiles:&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/07/making-list-of-users-with-allobj.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/3575429580945171298/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/07/making-list-of-users-with-allobj.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/3575429580945171298'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/3575429580945171298'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/07/making-list-of-users-with-allobj.html' title='Making a list of users with *ALLOBJ authority is much easier with SQL'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s72-c/sql.png" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-1351076133197003187</id><published>2026-09-23T05:00:00.000-05:00</published><updated>2026-09-23T05:00:00.141-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="dspf"/><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><category scheme="http://www.blogger.com/atom/ns#" term="rpg"/><title type='text'>Controlling the action of the cursor in a subfile</title><content type='html'>&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQBp02H6cYza6NNOGi5y5bNrjauHvsZAO2_XGAZGnmgGmmDp8uWj2Y2jlegg9a6QfIIcEN-rMJ-kK4_xnW-yCCk5inf5MczIsjy9ALYQBraV3ZKdKVgNnsTtHyaJOwwMgId4CoWPOHnwUrK3uFhHUILxsXUJi7JcHv_APWo8vbZ86SwcGA3VrhgkBemZg/s1600/dspf.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;After reading the post about &lt;a href=&quot;/2020/06/control-progression-of-cursor-in.html&quot; target=&quot;_blank&quot;&gt;controlling the cursor&amp;#39;s movement on a display file&lt;/a&gt;, a friend asked:&lt;/p&gt;

&lt;blockquote class=&quot;blockquote-custom&quot;&gt;
&lt;p&gt;How can I make the cursor stay in the same column when I tab through a subfile?&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;What I described in that post will not work on a subfile as each record&amp;#39;s fields have the same names. I would have to use another approach.&lt;/p&gt;

&lt;p&gt;Subfile have their own keyword to control cursor movement: Subfile Cursor Progression, &lt;tt&gt;SFLCSRPRG&lt;/tt&gt;. This is a field level keyword that is placed with a field in the subfile. The field must be input or both, of course. Alas, only one field in the subfile can have this keyword. You cannot condition the keyword by using indicators.&lt;/p&gt;

&lt;p&gt;Here is my very simple display file with a subfile with the &lt;tt&gt;SFLCSRPRG&lt;/tt&gt; keyword:&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/09/controlling-action-of-cursor-in-subfile.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/1351076133197003187/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/09/controlling-action-of-cursor-in-subfile.html#comment-form' title='3 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/1351076133197003187'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/1351076133197003187'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/09/controlling-action-of-cursor-in-subfile.html' title='Controlling the action of the cursor in a subfile'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQBp02H6cYza6NNOGi5y5bNrjauHvsZAO2_XGAZGnmgGmmDp8uWj2Y2jlegg9a6QfIIcEN-rMJ-kK4_xnW-yCCk5inf5MczIsjy9ALYQBraV3ZKdKVgNnsTtHyaJOwwMgId4CoWPOHnwUrK3uFhHUILxsXUJi7JcHv_APWo8vbZ86SwcGA3VrhgkBemZg/s72-c/dspf.png" height="72" width="72"/><thr:total>3</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-4035373682971176263</id><published>2026-09-16T05:00:00.000-05:00</published><updated>2026-09-16T06:34:59.148-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cl"/><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><title type='text'>Chopping up a file that is too big</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwp6wOJVwdtdNBKPKhwNlKZZHtBYN2G-q3I1rRbJDdrOkMqSJmfvY3Vr_sxtD2KwvRjP_Nu9njJLh8G1V0ExRrnFJP7S7267a1JsUslWn-d1qYY0atlJM5e582OaWkIGQyKroJCpMaG8xYzX2A-qMpN4IUAfvb89RncpKUVL1a7uSx_D5EZAsUyVSyyiU/s200/cl.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;I know the title sound intriguing, and I thought the subject was worthy of a post. A friend approached me wanting to know how could he &amp;quot;chop up&amp;quot; files that contain hundreds of millions of records into smaller files, that he would transfer to another platform. He knew he could do it manually, but he wanted a program.&lt;/p&gt;

&lt;p&gt;Something like this is very simple in CL. In no time I had a program for him that would take a file, copy one million records at a time to a work file, and copy the work file&amp;#39;s contents to a CSV in the IFS.&lt;/p&gt;

&lt;p&gt;Unfortunately I do not have file containing hundred of millions of records, so I am going to use my Person file. This file has only 41 records, and I am going to show how I can &amp;quot;chop&amp;quot; it up into files that contain a maximum of ten records. The principal is the same as copying the files with hundred of millions of records.&lt;/p&gt;

&lt;p&gt;The source for the program is not big, just 36 lines. I am going to start with the first 17 lines:&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/09/chopping-up-file-that-is-too-big.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/4035373682971176263/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/09/chopping-up-file-that-is-too-big.html#comment-form' title='4 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/4035373682971176263'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/4035373682971176263'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/09/chopping-up-file-that-is-too-big.html' title='Chopping up a file that is too big'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwp6wOJVwdtdNBKPKhwNlKZZHtBYN2G-q3I1rRbJDdrOkMqSJmfvY3Vr_sxtD2KwvRjP_Nu9njJLh8G1V0ExRrnFJP7S7267a1JsUslWn-d1qYY0atlJM5e582OaWkIGQyKroJCpMaG8xYzX2A-qMpN4IUAfvb89RncpKUVL1a7uSx_D5EZAsUyVSyyiU/s72-c/cl.png" height="72" width="72"/><thr:total>4</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-5102170578515702503</id><published>2026-09-09T05:00:00.000-05:00</published><updated>2026-09-09T05:00:00.114-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><category scheme="http://www.blogger.com/atom/ns#" term="sql"/><title type='text'>Separating parts of qualified job name with SQL</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s200/sql.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;In a previous post I explained how I could &lt;a href=&quot;/2019/07/extracting-jobs-name-from-job-name.html&quot; target=&quot;_blank&quot;&gt;extract the parts of the qualified job name&lt;/a&gt; using the &lt;tt&gt;LOCATE_IN_STRING&lt;/tt&gt; scalar function. With the latest Technology Refreshes, &lt;a href=&quot;/2026/07/first-tr-of-2026.html&quot; target=&quot;_blank&quot;&gt;&lt;em&gt;IBM i&lt;/em&gt; 7.6 &lt;abbr title=&quot;Technology Refresh&quot;&gt;TR&lt;/abbr&gt;2 and 7.5 TR8&lt;/a&gt;, a number of &lt;i&gt;Db2 for i&lt;/i&gt; scalar functions and a table function were added to make this easier. These are:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;tt&gt;JOB_NAME&lt;/tt&gt; scalar function:  Returns the job name&lt;/li&gt;
&lt;li&gt;&lt;tt&gt;JOB_NUMBER&lt;/tt&gt; scalar function:  Returns the job number&lt;/li&gt;
&lt;li&gt;&lt;tt&gt;JOB_USER&lt;/tt&gt; scalar function:   Returns the job user&lt;/li&gt;
&lt;li&gt;&lt;tt&gt;JOB_NAME_DETAILS&lt;/tt&gt; table function:  Returns all of the above&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;All of the above are found in the library &lt;tt&gt;SYSTOOLS&lt;/tt&gt;.&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/09/separating-parts-of-qualified-job-name.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/5102170578515702503/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/09/separating-parts-of-qualified-job-name.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/5102170578515702503'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/5102170578515702503'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/09/separating-parts-of-qualified-job-name.html' title='Separating parts of qualified job name with SQL'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s72-c/sql.png" height="72" width="72"/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-4441254831189332762</id><published>2026-09-02T05:00:00.000-05:00</published><updated>2026-09-02T05:00:00.117-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><category scheme="http://www.blogger.com/atom/ns#" term="rpg"/><category scheme="http://www.blogger.com/atom/ns#" term="sql"/><title type='text'>Validating CL commands with SQL</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s200/sql.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;There has been an &lt;a href=&quot;/2017/03/command-syntax-validation-api.html&quot; target=&quot;_blank&quot;&gt;API to validate CL commands&lt;/a&gt; for as long as I can remember, but is not simple to use. Fortunately, as part of the latest Technology Refreshes, &lt;a href=&quot;/2026/07/first-tr-of-2026.html&quot; target=&quot;_blank&quot;&gt;&lt;em&gt;IBM i&lt;/em&gt; 7.6 &lt;abbr title=&quot;Technology Refresh&quot;&gt;TR&lt;/abbr&gt;2 and 7.5 TR8&lt;/a&gt;, a &lt;i&gt;Db2 for i&lt;/i&gt; scalar function was introduced that performs the same function.&lt;/p&gt;

&lt;p&gt;&lt;tt&gt;CHECK_COMMAND_SYNTAX&lt;/tt&gt; requires one parameter, the command string to be validated. The string can be up to 32,000 characters, which should cover most command strings I use. It returns a Boolean value:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;True = the command string is valid&lt;/li&gt;
&lt;li&gt;False = the command string is invalid&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Here are a couple of examples I made and ran in &lt;a href=&quot;/acs&quot; target=&quot;_blank&quot;&gt;ACS&lt;/a&gt;&amp;#39;s Run SQL Scripts, &lt;abbr title=&quot;Run SQL Scripts&quot;&gt;RSS&lt;/abbr&gt;:&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/09/validating-cl-commands-with-sql.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/4441254831189332762/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/09/validating-cl-commands-with-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/4441254831189332762'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/4441254831189332762'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/09/validating-cl-commands-with-sql.html' title='Validating CL commands with SQL'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s72-c/sql.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-1282736237234437123</id><published>2026-08-26T05:00:00.000-05:00</published><updated>2026-08-26T05:00:32.726-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><category scheme="http://www.blogger.com/atom/ns#" term="sql"/><title type='text'>Creating and using a data journal reader</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s200/sql.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;Every so often IBM delivers something for the &lt;em&gt;IBM i&lt;/em&gt; that makes me say &amp;quot;Wow!&amp;quot; Data journal readers are one of these cases. It has changed the way I am thinking of retrieving data from journals.&lt;/p&gt;

&lt;p&gt;The &lt;tt&gt;CREATE_DATA_JOURNAL_READER&lt;/tt&gt; SQL scalar function was introduced as part of &lt;a href=&quot;/2026/07/first-tr-of-2026.html&quot; target=&quot;_blank&quot;&gt;&lt;em&gt;IBM i&lt;/em&gt; 7.6 &lt;abbr title=&quot;Technology Refresh&quot;&gt;TR&lt;/abbr&gt;2 and 7.5 TR8&lt;/a&gt;, and is very simple to set up. It creates a SQL table function that allows me to see the entries for one of the files whose data is within a journal.&lt;/p&gt;

&lt;p&gt;Before I can show examples of this, I need a file and it needs to be journaled.&lt;/p&gt;

&lt;p&gt;I created a DDS file, &lt;tt&gt;TESTFILE&lt;/tt&gt;, in my library, &lt;tt&gt;MYLIB&lt;/tt&gt;. It contains nine fields I named &lt;tt&gt;FIELD1&lt;/tt&gt; to &lt;tt&gt;FIELD9&lt;/tt&gt;. The layout of the file is immaterial to showing how to create and use a data journal reader.&lt;/p&gt;

&lt;p&gt;Once the file was created, I needed it to be journaled. Which I did with the following commands:&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/08/creating-and-using-data-journal-reader.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/1282736237234437123/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/08/creating-and-using-data-journal-reader.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/1282736237234437123'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/1282736237234437123'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/08/creating-and-using-data-journal-reader.html' title='Creating and using a data journal reader'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s72-c/sql.png" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-3273277951148878436</id><published>2026-08-20T05:00:00.000-05:00</published><updated>2026-08-20T05:00:00.118-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><title type='text'>IBM Redbook covers modernization in depth</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_JeuhayaTu7PB8TiXMtze7XciJ1q7B5XZF72hXgJ3cvsffcklIGA5U2lxSsvxGOqLU1Hw5E9YsB-UbQqeLmDNybvdjbzfiFQd0f8wqrhpSqBBzJ58TiLsj-aw4XX1tkUvxcuT0yTMAPHQiaW8LT1yjs3tHG1IC5BfhSKic5xx3NRiIxi1mY2bf4jJiyc/s200/ibm_i_2021.png&quot; align=&quot;right&quot; /&gt;

&lt;p&gt;IBM has published a Redbook about modernization: &quot;Modernizing IBM i Applications&quot;.&lt;/p&gt;
 
&lt;p&gt;The list of authors and contributors is very impressive, including both IBM and &lt;em&gt;IBM i&lt;/em&gt; community experts.&lt;/p&gt;

&lt;p&gt;The 810-page guide covers what it describes as &quot;all levels of the operating system&quot;, including the development concepts needed to achieve effective modernization. It takes us on the journey from from the database to the front-end, and everything in between, including RPG and COBOL&#39;s place.&lt;/p&gt;

&lt;p&gt;You can download it &lt;a href=&quot;https://www.redbooks.ibm.com/docs/pdfs/MD260020.pdf&quot; target=&quot;_blank&quot; rel=&quot;nofollow&quot;&gt;here&lt;/a&gt; as a PDF.&lt;/p&gt;

&lt;p&gt;Happy reading!&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/3273277951148878436/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/08/ibm-redbook-covers-modernization-in.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/3273277951148878436'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/3273277951148878436'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/08/ibm-redbook-covers-modernization-in.html' title='IBM Redbook covers modernization in depth'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_JeuhayaTu7PB8TiXMtze7XciJ1q7B5XZF72hXgJ3cvsffcklIGA5U2lxSsvxGOqLU1Hw5E9YsB-UbQqeLmDNybvdjbzfiFQd0f8wqrhpSqBBzJ58TiLsj-aw4XX1tkUvxcuT0yTMAPHQiaW8LT1yjs3tHG1IC5BfhSKic5xx3NRiIxi1mY2bf4jJiyc/s72-c/ibm_i_2021.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4373663334124272866.post-2621751684747314388</id><published>2026-08-19T05:00:00.000-05:00</published><updated>2026-08-19T05:00:00.117-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="programming"/><category scheme="http://www.blogger.com/atom/ns#" term="rpg"/><category scheme="http://www.blogger.com/atom/ns#" term="sql"/><title type='text'>Convert number to hexadecimal with SQL</title><content type='html'>&lt;img border=&quot;0&quot; width=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s200/sql.png&quot; align=&quot;right&quot;&gt;

&lt;p&gt;In an earlier post I wrote about how to convert a &lt;a href=&quot;/2023/08/convert-character-to-hexadecimal-with.html&quot; target=&quot;_blank&quot;&gt;character string to hexadecimal, and back to character again&lt;/a&gt;.  The obvious question followed:&lt;/p&gt;

&lt;blockquote class=&quot;blockquote-custom&quot;&gt;
&lt;p&gt;What if wanted to convert a number to hexadecimal with SQL?&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;One of the issues is that numbers come in different forms in &lt;a href=&quot;/2016/05/the-different-flavors-of-free-format-rpg.html#2&quot; target=&quot;_blank&quot;&gt;modern RPG&lt;/a&gt; and in &lt;a href=&quot;/2018/09/sql-type-variables-in-rpg.html&quot; target=&quot;_blank&quot;&gt;SQL&lt;/a&gt;. Here are the common types of numbers I encounter:&lt;/p&gt;

&lt;center&gt;
&lt;table border=&quot;1&quot; cellpadding=&quot;5&quot;&gt;
&lt;tr&gt;
&lt;td align=&quot;center&quot;&gt;&lt;b&gt;Type&lt;/b&gt;&lt;/td&gt;
&lt;td align=&quot;center&quot;&gt;&lt;b&gt;RPG&lt;/b&gt;&lt;/td&gt;
&lt;td align=&quot;center&quot;&gt;&lt;b&gt;SQL&lt;/b&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align=&quot;center&quot;&gt;Packed&lt;/td&gt;
&lt;td align=&quot;center&quot;&gt;&lt;tt&gt;PACKED&lt;/tt&gt;&lt;/td&gt;
&lt;td align=&quot;center&quot;&gt;&lt;tt&gt;DECIMAL&lt;/tt&gt;, &lt;tt&gt;DEC&lt;/tt&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align=&quot;center&quot;&gt;Signed&lt;/td&gt;
&lt;td align=&quot;center&quot;&gt;&lt;tt&gt;ZONED&lt;/tt&gt;&lt;/td&gt;
&lt;td align=&quot;center&quot;&gt;&lt;tt&gt;NUMERIC&lt;/tt&gt;, &lt;tt&gt;NUM&lt;/tt&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td align=&quot;center&quot;&gt;Integer&lt;/td&gt;
&lt;td align=&quot;center&quot;&gt;&lt;tt&gt;INT&lt;/tt&gt;&lt;/td&gt;
&lt;td align=&quot;center&quot;&gt;&lt;tt&gt;INTEGER&lt;/tt&gt;, &lt;tt&gt;INT&lt;/tt&gt;, &lt;tt&gt;SMALLINT&lt;/tt&gt;, &lt;tt&gt;BIGINT&lt;/tt&gt; &lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;/center&gt;

&lt;p&gt;In this post I am going to give examples of how to convert each of these RPG number types to hexadecimal, and then back again.&lt;/p&gt;

&lt;p&gt;This is my program:&lt;/p&gt;

&lt;a href=&quot;https://www.rpgpgm.com/2026/08/convert-number-to-hexadecimal-with-sql.html#more&quot;&gt;Read more »&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='https://www.rpgpgm.com/feeds/2621751684747314388/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='https://www.rpgpgm.com/2026/08/convert-number-to-hexadecimal-with-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/2621751684747314388'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4373663334124272866/posts/default/2621751684747314388'/><link rel='alternate' type='text/html' href='https://www.rpgpgm.com/2026/08/convert-number-to-hexadecimal-with-sql.html' title='Convert number to hexadecimal with SQL'/><author><name>Simon Hutchinson</name><uri>http://www.blogger.com/profile/11190349031029500428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='30' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE7C4I6b9NsZbBq7jgJ1lLDYcwnZ2Tf_8W5AogXwOpuHjV9YkwSHKS9wwPJSYXkj727mBixwFb-cfGDXUqJwBYFhEXAdwIfFNuz9INaBmNBvlOTjaQmJawFnXSj0KhudIbgSCzQSyMcSpFknpnJF8RLQ_sjeaYPXvq9e0kiFNbiHNh18/s220/simon_hutchinson_2025.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3wbkA3IVsmB_BH9NvijYt3LB9KiQitQocCtop_mqznyIGhP0zLviDV0sLODg3NHKINv7Wx8okZ0eMsH5B6bC9-oZjMUycD92WGGOuIirNfWXDWISPdWoX-jf6srxTUTpJOe2qv6WgsKrG7txXp074Vbl-rt-wIb91-8340_qT4gYAuQZ__ks1sdpGg2U/s72-c/sql.png" height="72" width="72"/><thr:total>0</thr:total></entry></feed>