Re: SQL Indicator Arrays

[Peter Dow <petercdow@xxxxxxxxx>]

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