Kbase P103909: Error -210043 when moving data between tables and tables contain LVARBINARY fields
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/05/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
SYMPTOM(s):
Trying to move data from one table to another table (exact same schema) in SQL92
Tables contain an LVARBINARY field
Using INSERT INTO PUB.SomeTable SELECT * FROM OtherUser.SomeTable to move the data between tables
The INSERT works if there is no LVARBINARY field in the tables
[JDBC Progress Driver]:-210043
CAUSE:
When moving data using an INSERT with a SELECT a derived table is generated. A derived table cannot contain a BLOB (which is what the LVARBINARY data type is).
FIX:
The only way to move this data to the new table is to explicitly insert each record (i.e. in the same manner in which the records were originally added to the database).