Trying to use the cursors with the null indicators I verified that in the presence of null values a zero value is always returned. 01 COM-NULL-IND PIC S9(4) COMP. * Cursor declaration EXEC SQL DECLARE ...
The challenging part is that this SQL statement executes fast that could be easily missed in AX trace or SQL profiler trace. The part with performance hit is the cursor fetch though that surfaces ...
Although an interactive SQL facility might provide an interface that gives the appearance of interactive execution, this statement can only be embedded within an application program. It is an ...