Re: SQLSTT Error Code 01003

Hi Mike,

Messages that start with 01 (like 01003) are "warning" or "informational" messages that do not indicate a failure per se. Normally, I see them dealt with using code like this:

exec SQL blah blah;
dow sqlstt='00000' or %subst(sqlstt:1:2)='01';
// do work.
exec SQL blah blah;
enddo;

That's pretty much standard in my shop, so these warning messages will be visible in the job log, but don't change the flow of the code.

01003 is that null values were removed from column function arguments... the wording of that message leaves a lot to be desired. Column functions are, presumably, functions that operate on SQL columns (traditionally called "fields").

The word "arguments" is another term for "parameters".

So they are saying that null values were eliminated from the parameter list when calling a function (either a built-in one or a UDF). In other words, a field value was passed as a parameter, but the corresponding null indicator was not. Probably the function used a parameter style that doesn't include null indicators.

Hope that helps.

Mike wrote:

I am trying to figure out what this error means beyond "01003 - Null values
removed from column function argument(s)." It is causing issues in my
program. I check to be sure that SQLSTT is 0 or 2000. This is the first time
I have come across this error and the error message isn't very helpful here.