I have a wild idea but maybe you can check with the vendor if it can be
done.
1) Create a table that will hold only the other fields.
2) Create a second table that will have the same PK and long raw field.
3) Create a view that will combine them by the PK.
4) Since I am not sure in a view with
The reason that vendors often use LONG RAW is that that datatype meets the ANSI SQL
standard, while BLOB doesn't. That way, they can use the same DDL against most SQL
databases. Sometimes you can modify the vendor's DDL before or during installation.
Sometimes you can re-create a table right