My company is upgrading some applications and I need to copy the data from current files into the new files. In some cases the new files have additional fields. Is there a way with sql to copy the current data and at the same time add either a default value or a running sequentional value to the new fields? SQL will not copy if the number of fields isn't equal:
insert into ccurra select * from ccurra_old where cucutd >= 20140101
produces an SQL0117 error. Ideally I need the load the additional field with a running sequence number though zero would be acceptable if necessary.
Any thoughts would be appreciated.