RE: INSERTing datastructure into table with GENERATED ALWAYS column.

Evidently you need to set EXTIND=*YES with an EXEC SQL SET OPTION statement.

Unfortunately, I was only looking at the UPDATE statement and found no way to activate the option for a single static statement.

Which means that if you want to use an extended indicator arrays with Static statements, you must use them for all statements within the program. Or am I missing something?

With Dynamic statements you can specify the WITH EXTENDED INDICATORS on a Prepare statement, so it can only affects a single statement in the program.


Thanks for the tip Michael, I don't normally look the "Database Embedded SQL programming" manual and do most of my research using the "DB2 for i SQL Reference".
Which also shows the EXTIND with the Set Options statement, it just didn't occur to me that I would need to make a global setting to activate a feature for a single statement.

Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.