×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
"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
midrange.com
