LS Consulting

  • Home
  • About
  • Blog
  • Contact

API

Notes

Querying data queues with QMHQRDQD

Someone recently asked me if I knew of an API that could be used to retrieve the number of entries in a data queue without pulling the entries from the data queue. I didn’t, but a quick search turned up QMHQRDQD.: The Retrieve Data Queue Description (QMHQRDQD) API retrieves the Read more…

By Paul, 4 years4 years ago
Notes

Using QSYRUSRI to check whether a user profile exists

Sometimes you have a table that captures user profiles. Obviously, if the user profile is deleted, there is nothing to delete these table entries. And sometimes, auditors can see this as a problem. There are several ways of handling this, one of which is to make use of the QSYRUSRI Read more…

By Paul, 4 years4 years ago
Notes

Writing messages to the joblog with QMHSNDPM

I have previously mentioned using Qp0zLprintf (Print Formatted Job Log Data) to write messages to the joblog. Here’s an alternative approach using QMHSNDPM (Send Program Message). In this case, I am executing an SQL statement and checking the SQL state afterwards. If the state is not 00000 (completed normally), I Read more…

By Paul, 5 years5 years ago
Notes

Writing messages to the job log with RPG

So here’s a fun situation. An interface that works perfectly in the test environment but which randomly falls over in production. Better still, it’s part of the overnight batch processing so it tends to fall over at around 9:30 in the evening. I need to be able to determine what Read more…

By Paul, 5 years5 years ago
Notes

Service Programs and Call Stack APIs

I’m a big fan of service programs. From a maintainability point of view, encapsulated procedures are great. And exported procedures, which mean you only need to develop any piece of functionality once, are even better. However, I now find myself in the position of having to start creating a set Read more…

By Paul, 5 years5 years ago
Search
Categories
  • Announcements
  • News
  • Notes
  • Uncategorised
Tags
%bif API CL CPYSPLF Data Queues Documentation IFS INSTR LOCATE_IN_STRING QMHQRDQD QShell QSYRUSRI Regular Expressions REXX RPG SQL Vim

Find me on LinkedIn


Hestia | Developed by ThemeIsle