INSERT INTO .. SELECT with BLOB columns

Is it correct that "INSERT INTO new SELECT * FROM old" does not copy
BLOB columns? Or is there something I failed to configure properly?

Thank you,
Peter Arrenbrecht
Opus Software AG

You are mistaken. No column values are ever shared, including LOBs.
What's the symptom you see?

Cheers
Serge

Sorry, the values in the destination table are NULL. But I do suspect
that something in the application is wrong here. Please excuse the
trouble I caused.

Peter

Serge Rielau wrote:[color=blue]
> You are mistaken. No column values are ever shared, including LOBs.
> What's the symptom you see?
>
> Cheers
> Serge[/color]

INSERT INTO .. SELECT with BLOB columns

re: INSERT INTO .. SELECT with BLOB columns

re: INSERT INTO .. SELECT with BLOB columns

Similar DB2 Database bytes

/bytes/development

/bytes/it

/bytes/about