Re: INSERTing datastructure into table with GENERATED ALWAYS column.

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 01/23/2017 12:08:45
PM:

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 01/23/2017 12:00:10
PM:

Without listing all the columns individually on the insert statement

is

there a way to insert the data structure?

Yes. You use an extended indicator array to specify those columns
to be ignored.

Oh, one caveat... If you don't list the column names that match
the data structure then you would have a problem down the road if any
columns are ever added to the table. So, the route that requires the
least recompiles is to list every column name that matches the current
data structure and use the extended indicator array to ignore GENERATED
ALWAYS columns. In the case of dynamic SQL, this will at least prevent
having to list every column twice -- once when building the statement and
again when the prepared statement is executed.

Sincerely,

Dave Clark