load and generatedoverride

[Sebastian Ciesielski]

hello,

my database has column defined as GENERATED ALWAYS:

TXT_VERMITTLERNR VARCHAR(10) NOT NULL GENERATED ALWAYS AS
(RTRIM(CAST(ID_VERMITTLER AS CHAR(10))))

ID_VERMITTLER is:

ID_VERMITTLER INTEGER NOT NULL GENERATED BY DEFAULT AS
IDENTITY
I try using LOAD column to import data, but I can't find appropriate
modifier:

- GENERATEDOVERRIDE crashes with SQL3526N reason code 9 and suggest to use
identityoverride,
- IDENTITYOVERRIDE crashes with SQL3526N reason code 5

It is possible to use GENERATEDIGNORE, but I strongly prefer to override to
overwrite content of generated column

Some suggestions?
regards

S.

[Frank Swarbrick]

Since you seem to have both a regular generated column and an identity
column I think you need to use both GENERATEDOVERRIDE and IDENTITYOVERRIDE.

n 9/15/2008 at 4:10 AM, in message <ga**********@inews.gazeta.pl>,
Sebastian Ciesielski<se***@poczta.fmwrote:

hello,

my database has column defined as GENERATED ALWAYS:

TXT_VERMITTLERNR VARCHAR(10) NOT NULL GENERATED ALWAYS AS

(RTRIM(CAST(ID_VERMITTLER AS CHAR(10))))

ID_VERMITTLER is:

ID_VERMITTLER INTEGER NOT NULL GENERATED BY
DEFAULT AS
IDENTITY
I try using LOAD column to import data, but I can't find appropriate
modifier:

- GENERATEDOVERRIDE crashes with SQL3526N reason code 9 and suggest to
use
identityoverride,
- IDENTITYOVERRIDE crashes with SQL3526N reason code 5

It is possible to use GENERATEDIGNORE, but I strongly prefer to override
to
overwrite content of generated column

Some suggestions?
regards

S.