Re: SQL Indicator Arrays

Hi Dave,

Thanks for the info!

Do you actually use those extended values? I haven't had the opportunity to work with a file that has fields that are too large for RPG to handle. But if you're interested in one of those fields and it's getting truncated regularly, what do you do? I would think that in the absence of EXTIND=*YES the system would give an error, which you could monitor for.

As for the values used on INSERT or UPDATE, when you specify EXTIND=*YES are you then required to set all those indicators as shown? So if I have 100 fields and I want to update one of them I have to set the indicators for the other 99 fields? Do those values override what was specified on the DDL? I mean if the DDL says

FldA char(20) not null with default

and I set the associated indicator to -1, is FldA now going to be null, even though the DDL says not to do that?

I ask, because all those values are just what happens under normal circumstances afaik.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /



On 11/18/2016 9:01 AM, dlclark@xxxxxxxxxxxxxxxx wrote:

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