Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
using ER to clone a table with different column type
Answered: amber (hollow confidence) — Reply with no archived question: suggests keeping schemas identical for ER loopback and using a trigger on the target to move rows, or simply INSERT INTO new SELECT * FROM old.
Paul Watson — source: IBM Community (ConnectedCommunity.org) Informix forum
Keep the schemas the same for loopback then trigger on the target to move the row into the new table.
But why can you just insert into new select * from old ?
Cheers
Paul
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.