Re: SQL Indicator Arrays

[dlclark@xxxxxxxxxxxxxxxx]

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 11/18/2016 
11:37:33 AM:
> What else is it about?  A google for "SQL null indicator array" finds 
> it.  Are you saying /you/ use it for more than just nulls? Or the system 

> does?  If the system, what else does it use it for?


        The system does -- if EXTIND = *YES has been specified as an 
option setting.  ALL of our programs use EXTIND = *YES as a standard.

        After a select-into or a fetch SQL sets the indicators to one of 
three values: 0, -1, or -2; where if you use <> -1 to check for nulls then 
the check is in error.  -2 means that not all data could be transferred to 
your program, but some of the data could have been transferred as in the 
case of truncation.

        For insert and update SQL accepts one of four indicator values as 
conditions for how to use the associated data columns specified in the SQL 
statement.  The values are: 0, -1, -5, or -7; where 0 means to insert or 
update the associated column using the value specified in the statement; 
-1 means to insert or update the associated column as a null value; -5 
means to insert or update the associated column as the DDL-defined default 
value; and -7 means to ignore the associated column completely skipping 
its insert or update.

Sincerely,

Dave Clark