Note: The code accompanying this article is available for download here.

I’d like to use SQL Descriptors in an embedded SQL program to read column data into host variables. However, if my host variable type doesn’t match exactly the parameter or column data type then I receive an SQL0076 error: “DATA or INDICATOR item not correct.” How can I, for example, receive the data from a CHAR(10) column from the SQL descriptor into an RPG varying-length character 20 variable, without using an explicit CAST in the SQL statement?

–J.B.

AUTHOR’S NOTE: If you’re unfamiliar with SQL descriptors, please see

Note: The code accompanying this article is available for download here.

It has been a while since my last tip on RPG Open Access and now that everyone running IBM i V6 or 7 has access to it for no additional cost, I thought it was time to revisit the subject.

OA handlers operate in one of two modes: buffer and names/values. The buffer option performs better, but requires the handler to know the layout of the data in the buffer in advance. Names/values (NV) handlers, such as the one I introduced in the previous article, do not

Every so often, our system storage breaches its threshold level, and we have to find the job that is filling up storage before it crashes our system. This is usually a race against time. Do you have any tips on how to quickly find runaway jobs that are gobbling up storage?

–Mike

I feel your pain on this one. Hitting the threshold can be a recurring event in some shops, and it’s always better to find out sooner when this problem occurs rather than later.

Here’s how I handle this issue.

Set Your ASP Threshold At A Reasonable Level

On