Avatar of awking00
Flag for United States of America

asked on 

Populating a generated column that has been added

I had a DB2 table, mytable, with a field named flr that was defined as char(9). A column was added with a alter table mytable add column flr_num generated always as cast(flr as decimal(5,0). After the column was added, I would have expected to see values in the flr_num column but all the values are null. How does that column get populated or is the problem that the column is decimal(5,0) while the source is char(9)?

Avatar of undefined
Last Comment

8/22/2022 - Mon