Webinar iSecurity for DORA Compliance

​Webinar iSecurity for DORA Compliance – Nov 20th 2024 Probably you already have documented security policies in place for GDPR, but these will need to be supplemented and updated for DORA. Raz-Lee’s iSecurity Suite makes it easy to secure your IBM i systems and meet DORA compliance standards. Join our upcoming webinar to learn how Read More 

ERROR Built-In Function In IBM i Programmers IO

​In this session we will learn about the Built-In function ERROR in RPGLE.For detailed description and explanation refer the E-Book.EBook Link: https://programmers.io/ibmi-ebook/Programmers.io is a registered IBM business partner and a global IT services and consulting firm, providing on-demand software development Read More 

Learning about active queries [email protected] (Simon Hutchinson)

​[[{“value”:”Have you ever wanted to know what is going on within an active SQL Query Engine, SQE, query?
If, like me, you do there is a table function that shows all kinds of interesting information.
The table function ACTIVE_QUERY_INFO has been around since IBM i 7.3 . It has four parameters that allow you to select the results you want returned.

JOB_NAME:  This is the parameter I have found the most useful. Rather than it using the qualified job name it uses the job name part of the job name. Therefore I can just search for jobs with wildcards, for example ‘DSP1*’. I can also use ‘*’ to return results for the current job only, and ‘*ALL’, or blank, to return the results for all active jobs.
JOB_USER:  The user name from the job name. A wildcard can be used here too.
JOB_NUMBER:  The job number part of the job name. ‘*ALL’ can be used here.
USER_NAME:  The user name for the job, which may not be the same as the job user name.

Read more »”}]] Read More 

Verified by MonsterInsights