RE: Null capable sub field

In embedded SQL, what you actually do is create an array of one or several
16-bit (or two-byte) integers, *DIM*med the same as the number of columns
that could return NULL values.

DCL-S indNulls INT(5) DIM(NULL_COLS_COUNT) INZ;

If you are using a CURSOR, you would do this:

FETCH CURSOR_NAME INTO :yourDS :indNulls FROM YOUR_TABLE WHERE....

If your SQLCODE is not an error, then you would test every element of
indNulls like:

IF indNulls(1) > -1;
// this column returned a non-NULL value
ELSE;
// this column did return a NULL value
ENDIF;

and then you would take actions for the NULL values instances.

JS.

message: 4
date: Tue, 4 Aug 2020 12:43:05 -0400
from: Raul Alberto Jager Weiler <raul.jager@xxxxxxxxx>
subject: Null capable sub field

How can I declare a sub field that is null capable in a DCL_DS?