load and generatedoverride

[Sebastian Ciesielski]

hello,

my database has column defined as GENERATED ALWAYS:

TXT_VERMITTLERN R 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:

- GENERATEDOVERRI DE crashes with SQL3526N reason code 9 and suggest to use
identityoverrid e,
- IDENTITYOVERRID E 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]

Re: load and generatedoverri de

Since you seem to have both a regular generated column and an identity
column I think you need to use both GENERATEDOVERRI DE and IDENTITYOVERRID E.

n 9/15/2008 at 4:10 AM, in message <galcap$lhc$1@i news.gazeta.pl> ,
Sebastian Ciesielski<seba c@poczta.fmwrot e:

hello,
>
my database has column defined as GENERATED ALWAYS:
>
TXT_VERMITTLERN R 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:
>
- GENERATEDOVERRI DE crashes with SQL3526N reason code 9 and suggest to
use
identityoverrid e,
- IDENTITYOVERRID E 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.